Copyright
The Missing Credits
Introduction
Part I: STORING INFORMATION IN TABLES
Chapter 1. Creating your First Database
Section 1.1. Understanding Access Databases
Section 1.2. Getting Started
Section 1.3. Saving and Opening Access Databases
Section 1.4. The Navigation Pane
Chapter 2. Building Smarter Tables
Section 2.1. Understanding Data Types
Section 2.2. Design View
Section 2.3. Access Data Types
Section 2.4. The Primary Key
Section 2.5. Six Principles of Database Design
Chapter 3. Mastering the Datasheet: Sorting, Searching, Filtering, and More
Section 3.1. Datasheet Customization
Section 3.2. Datasheet Navigation
Section 3.3. Printing the Datasheet
Chapter 4. Blocking Bad Data
Section 4.1. Data Integrity Basics
Section 4.2. Input Masks
Section 4.3. Validation Rules
Section 4.4. Lookups
Chapter 5. Linking Tables with Relationships
Section 5.1. Relationship Basics
Section 5.2. Using a Relationship
Section 5.3. More Exotic Relationships
Section 5.4. Relationship Practice
Part II: MANIPULATING DATA WITH QUERIES
Chapter 6. Queries that Select Records
Section 6.1. Query Basics
Section 6.2. Creating Queries
Section 6.3. Queries and Related Tables
Section 6.4. Query Power: Calculated Fields and Text Expressions
Section 6.5. Calculated Fields
Chapter 7. Queries that Update Records
Section 7.1. Understanding Action Queries
Section 7.2. Update Queries
Section 7.3. Append Queries
Section 7.4. Delete Queries
Part III: PRINTING REPORTS AND USING FORMS
Chapter 8. Creating Reports
Section 8.1. Report Basics
Section 8.2. Printing, Previewing, and Exporting a Report
Section 8.3. Formatting a Report
Section 8.4. Filtering and Sorting a Report
Chapter 9. Creating Simple Forms
Section 9.1. Form Basics
Section 9.2. Sorting and Filtering in a Form
Section 9.3. The Form Wizard
Part IV: SHARING ACCESS WITH THE REST OF THE WORLD
Chapter 10. Importing and Exporting Data
Section 10.1. Case for Importing and Exporting
Section 10.2. Using the Clipboard
Section 10.3. Import and Export Operations
Colophon
Index