Table of Contents

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

About the Author

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.