Book description
Reduce stress with timesaving database shortcuts
Explore database basics and build tables and reports that corral
your data
Access has undergone an extreme makeover! Whether you've used one
of the older versions or this is your first exposure to Access,
here's where you'll find the essentials you need to make this
database system work for you. Cruise around the new interface, team
up Access with other Office applications, use wizards to automate
your work, and much more.
Discover how to
* Create a new Access database
* Import and export data
* Build forms for efficient data entry
* Search tables for specific data
* Construct custom reports
* Customize your database navigation
Table of contents
- Copyright
- About the Authors
- Introduction
-
I. Basic Training
- In this part . . .
- 1. Getting to Know Access 2007
- 2. Finding Your Way Around Access
- 3. Database Basics
-
II. Getting It All on the Table
- In this part . . .
- 4. Keys, Relationships, and Indexes
- 5. Remodeling Your Data
- 6. What's Happening under the Table?
- III. Data Mania and Management
-
IV. Ask Your Data, and Ye Shall Receive Answers
- In this part . . .
- 11. Fast Finding, Filtering, and Sorting Data
- 12. I Was Just Asking . . . For Answers
- 13. I'll Take These AND Those OR Them
- 14. Queries That Think Faster than You
- 15. Calculating with Your Data
-
V. Plain and Fancy Reporting
- In this part . . .
- 16. Quick and Not‐So‐Dirty Automatic Reporting
- 17. Dazzling Report Design
- 18. Headers and Footers and Groups, Oh My!
- 19. Magical Mass Mailings
- VI. More Power to You
-
VII. The Part of Tens
- In this part . . .
-
22. Ten Common Problems
- You Type 73.725, but it Changes to 74
- The Words they are A‐Changing
- The Record was There and Now it's Gone
- You Run a Query, but the Results Aren't What You Expect
- The Validation That Never Was
- The Slowest Database in Town
- Your Database File Is as Big as a Whale
- You Get a Mess When Importing Your Spreadsheet
- We're Sorry; Your Database File Is Corrupt
- The Program Won't Start
-
23. Ten Uncommon Tips
- Document Everything as Though You'll be Questioned by the FBI
- Keep Your Fields as Small as Possible
- Use Number Fields for Real Numbers
- Validate Your Data
- Use Understandable Names to Keep Things Simple
- Delete with Great Caution
- Backup, Backup, Backup
- Think, Think, and Think Again
- Get Organized and Stay Organized
- There's No Shame in Asking for Help
- Getting Help
Product information
- Title: Access® 2007 For Dummies®
- Author(s):
- Release date: December 2006
- Publisher(s): Wiley
- ISBN: 9780470046128
You might also like
book
Special Edition Using Microsoft® Office Access 2003
Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of …
book
Special Edition Using Microsoft® Access 2000
Special Edition Using Access 2000 is your authoritative guide to mastering the essentials of this powerful …
book
Microsoft® Access® 2010 Inside Out
You're beyond the basics, so dive right in and really put your database skills to work! …
book
Microsoft® Office Access 2003 Inside Out
Take your database expertise to the next level! This supremely organized reference packs hundreds of timesaving …