Description
Book SynopsisHelps you learn how to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for data entry.
Table of ContentsThe 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
