Build powerful custom database solutions to keep your data organized and accessible
What kind of golden nuggets are in your data? This reference shows how to take advantage of Microsoft Access 2010's new features and capabilities so you can, well, access the information you need. You'll breeze through everything from tables, queries, and forms to database administration and Visual Basic for Applications as you learn this program.
Set the table — follow easy ways to make new tables, create table templates, and utilize the Table Wizard
Pick and choose your data — learn how to find the information you want and organize it in a way that's more useful
Get creative with forms — build your own forms using the Form Wizard
Cut your workload — find out how to write simple instructions that tell Access how to automate steps instead of doing it yourself
Show it off — see the best ways to design reports and print form letters, mailing labels, numbers with totals and subtotals, and more
Keep your database clean — discover what you need to do to ensure that your data is neat and tidy
Go beyond Access — interact with and move data to and from other programs on your computer or computers all over the world
Open the book and find:
How to easily design your relational database
Ways to create select queries
How to design and use forms for editing data
Techniques for spiffing up reports with charts and graphs
Methods for making macros smarter
Steps for securing your database
Tips for programming in VBA
How to use Access with SharePoint and SQL Server
9 Books in 1
Essential Concepts
Tables
Queries
Forms
Reports
Macros
Database Administration
Programming in VBA
Going Beyond Access

Download File Size:13.14 MB

---