Synopses & Reviews
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
With Access getting a major overhaul in its look and usage, Access For Dummies will get a similar overhaul. The book will still feature the basics on building databases and mining data that have made the book a best seller for six editions. This edition will also contain material focusing on the new interface and how it differs from the classic Office interface. This edition will also feature more power user tools that are more easily found and used with the new version.
A beginner's guide to the latest version of the database management application explains the ins and outs of Access 2007, discussing the changes to the program's interface, as well as concepts including tables, relational database design, data integrity, formats, queries, wizards, forms, and new power user tools. Original. (Beginner)
* Previous For Dummies guides to Access have sold more than 1.1 million copies in six editions
* The radically retooled new Access version has a totally new interface, easier interactivity with Excel, and many other new features-which makes this plain-English guide indispensable for both new and veteran Access users
* Includes information designed for experienced Access users that explains exactly what's different in the new interface
* Features expanded coverage of power-user tools, which are easier to find and use in the new Access version
* Continues to provide accessible coverage of Access basics, from building databases to mining data
About the Author
Laurie Ulrich Fuller
has been writing about and teaching people to use Microsoft Office since the 1980’s. Her teaching career goes back to the time before Microsoft Windows – which means she also remembers the first time she taught people to use a Windows-based application, and a student picked up the mouse and aimed it at the computer screen as though using a TV remote. Nobody laughed (except Laurie, after class), because everyone was new to the mouse back then. As new as the mouse was, so was the idea of keeping a database on a computer that could fit on your desk — and Laurie’s been there through every new version of Access — as Office has evolved to meet the needs of users from all walks of life — from individuals to huge corporations, from growing business to non-profit organizations.
Since those early days of Office and Windows, Laurie has personally trained more than 10,000 people to make better, more creative use of their computers, has written and co-written more than 25 nationally-published books on computers and software — including several titles on Microsoft Office. In the last few years, she’s also created two video training courses — one on Word 2003, and the other on the entire Office 2003 suite. She runs her own company, Limehat & Company, offering training, educational materials, and web development services. She invites you to contact her at firstname.lastname@example.org, and to visit her personal website, www.planetlaurie.com, for more information.
Laurie would also like you to know that despite being able to remember the world before Windows, she does not remember a time before cars, television, or fire.
Ken Cook has built and managed a successful computer consulting business since 1990 serving clients in New Jersey, New York, Pennsylvania, and California. He began as a trainer - training numerous users (too many to count!) on a variety of software packages — specializing in Microsoft Office.
Currently, he “dabbles in training” but his main focus is creating expert Microsoft Office solutions and Microsoft Access database solutions for Fortune 500 and small business clients.
He can be contacted through his Web site www.kcookpcbiz.com or email: email@example.com.
John Kaufeld is a popular For Dummies author.
Table of Contents
Part I: Basic Training.
Chapter 1: Getting to Know Access 2007.
Chapter 2: Finding Your Way Around Access.
Chapter 3: Database Basics.
Part II: Getting It All on the Table.
Chapter 4: Keys, Relationships, and Indexes.
Chapter 5: Remodeling Your Data.
Chapter 6: What’s Happening Under the Table?
Part III: Data Mania and Management.
Chapter 7: Creating Data Forms.
Chapter 8: Importing and Exporting Data.
Chapter 9: Automatically Editing Data.
Chapter 10: Gather Locally, Share Globally.
Part IV: Ask Your Data, and Ye Shall Receive Answers.
Chapter 11: Fast Finding, Filtering, and Sorting Data.
Chapter 12: I Was Just Asking . . . For Answers.
Chapter 13: I’ll Take These AND Those OR Them.
Chapter 14: Queries That Think Faster Than You.
Chapter 15: Calculating with Your Data.
Part V: Plain and Fancy Reporting.
Chapter 16: Quick and Not-So-Dirty Automatic Reporting.
Chapter 17: Dazzling Report Design.
Chapter 18: Headers and Footers and Groups, Oh My!
Chapter 19: Magical Mass Mailings.
Part VI: More Power to You.
Chapter 20: Making It All Better with the Analyzer Tools.
Chapter 21: Hello! Creating an Interface to Welcome Data Users.
Part VII: The Part of Tens.
Chapter 22: Ten Common Problems.
Chapter 23: Ten Uncommon Tips.
Appendix: Getting Help.