Access 2010

Creating Your First Database Understanding Access Databases First Database Understanding Tables Creating a Simple Table Editing a Table Saving Databases Making Backups Saving a Database Shrinking a Database Opening Databases Designating a Database as Trusted Opening Recent Databases Opening More Than One Database at Once The Navigation Pane Managing Database Objects Building Smarter Tables Data Types Design View Organizing and Describing Your Fields Datasheet Navigation Access Data Types Text Memo Number Currency Date/Time Yes/No Hyperlink Attachment AutoNumber Calculated The Primary Key Creating Your Own Primary Key Field Six Principles of Database Design Mastering the Datasheet Datasheet Customization Formatting the Datasheet Rearranging Columns Resizing Rows and Columns Hiding Columns Freezing Columns Advanced Editing The Spell Checker AutoCorrect Special Characters Printing the Datasheet Print Preview Fine-Tuning a Printout Blocking Bad Data Data Integrity Basics Lookups Input Masks Validation Rules Linking Tables with Relationships Relationship Basics Using a Relationship Manipulating Data with Queries Query Basics Queries and Related Tables Outer Joins Essential Query Tricks Calculated Fields Query Functions Testing Action Queries Pivot Tables Pivot Charts Report Basics Formatting a Report Printing Previewing Exporting a Report Filtering a Report Sorting a Report Formatting a Report Expression Programming Access Macro-Powered Forms