This fast-paced book teaches you the basics of Access 2007 so you can start using this popular database program right away. You'll learn how to work with Access' most useful features to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. The new Access is radically different from previous versions, but with this book, you'll breeze through the new interface and its timesaving features in no time with: Clear explanations Step-by-step instructions Lots of illustrations Larger type Plenty of friendly advice Ideal for small businesses and households, Access runs on PCs and manages large stores information, including numbers, pages of text, and pictures -- everything from a list of family phone numbers to an enormous product catalog. Unfortunately, each new version of the program crammed in yet another set of features -- so many that even the pros don't know where to find them all. Access 2007 breaks the mold: Microsoft changed the user interface by designing a tabbed toolbar that makes features easy to locate. One thing that hasn't improved is Microsoft's documentation.
Even if you find the features you need, you still may not know what to do with them. Access 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). His website is www.prosetech.com.
The Missing Credits Introduction What You Can Do with Access The New Face of Access 2007 About This Book One:. Storing Information in Tables Chapter 1. Creating Your First Database Understanding Access Databases Getting Started Saving and Opening Access Databases The Navigation Pane Chapter 2. Building Smarter Tables Understanding Data Types Design View Access Data Types The Primary Key Six Principles of Database Design Chapter 3. Mastering the Datasheet: Sorting, Searching, Filtering, and More Datasheet Customization Datasheet Navigation Printing the Datasheet Chapter 4. Blocking Bad Data Data Integrity Basics Input Masks Validation Rules Lookups Chapter 5. Linking Tables with Relationships Relationship Basics Using a Relationship More Exotic Relationships Relationship Practice Two:. Manipulating Data with Queries Chapter 6. Queries That Select Records Query Basics Creating Queries Queries and Related Tables Query Power: Calculated Fields and Text Expressions Calculated Fields Chapter 7. Queries That Update Records Understanding Action Queries Update Queries Append Queries Delete Queries Three:. Printing Reports and using forms Chapter 8. Creating Reports Report Basics Printing, Previewing, and Exporting a Report Formatting a Report Filtering and Sorting a Report Chapter 9. Creating Simple Forms Form Basics Creating a Simple Form Using a Form Sorting and Filtering in a Form The Form Wizard Four:. Sharing access with the rest of the world Chapter 10. Importing and Exporting Data Case for Importing and Exporting Using the Clipboard Import and Export Operations Index