Introduction | |
What You Can Do with Access | |
The New Face of Access 2007 | |
About This Book One | |
Storing Information in Tables | |
Creating Your First Database | |
Understanding Access Databases | |
Getting Started | |
Creating a New Database | |
Understanding Tables | |
Creating a Simple Table | |
Editing a Table | |
Saving and Opening Access Databases | |
Making Backups | |
Saving a Database with a Different Name or Format | |
Opening a Database | |
Opening More Than One Database at Once | |
Opening a Database Created in an Older Version of Access | |
Creating Another Database | |
The Navigation Pane | |
Browsing Tables with the Navigation Pane | |
Managing Database Objects | |
Building Smarter Tables | |
Understanding Data Types | |
Design View | |
Organizing and Describing Your Fields | |
How Updates Work in Design View | |
Access Data Types | |
Text | |
Memo | |
Number | |
Currency | |
Date/TimeYes/NoHyperlink | |
Attachment | |
AutoNumber | |
The Primary Key | |
Creating Your Own Primary Key Field | |
Six Principles of Database Design | |
Choose Good Field Names | |
Break Down Your Information | |
Include All the Details in One Place | |
Avoid Duplicating Information | |
Avoid Redundant Information | |
Include an ID Field | |
Mastering the Datasheet: Sorting, Searching, Filtering, and More | |
Datasheet Customization | |
Formatting the Datasheet | |
Rearranging Columns | |
Resizing Rows and Columns | |
Hiding Columns | |
Freezing Columns | |
Datasheet Navigation | |
Sorting | |
Filtering | |
Searching | |
Printing the Datasheet | |
Print Preview | |
Fine-Tuning a Print out | |
Blocking Bad DataData Integrity Basics | |
Preventing Blank Fields | |
Setting Default Values | |
Preventing Duplicate Values with Indexes | |
Input MasksUsing a Ready-Made Mask | |
Validation RulesApplying a Field Validation Rule | |
Writing a Field Validation Rule | |
Creating a Table Validation RuleLookups | |
Creating a Simple Lookup with Fixed Values | |
Adding New Values to Your Lookup List | |
Linking Tables with Relationships | |
Relationship Basics | |
Redundant Data vs. Related Data | |
Matching Fields: The Relationship Link | |
Linking with the ID Column | |
The Parent-Child Relationship | |
Using a Relationship | |
Defining a Relationship | |
Editing Relationships | |
Referential Integrity | |
Navigating a Relationship | |
Lookups with Related Tables | |
More Exotic Relationships | |
One-to-One Relationship | |
Many-to-Many Relationship | |
Relationship Practice | |
The Music School | |
The Chocolate Store Two | |
Manipulating Data with Queries | |
Queries That Select RecordsQuery Basics | |
Creating Queries | |
Creating a Query in Design View | |
Creating a Simple Query with the Query Wizard | |
Queries and Related Tables | |
Joining Tables in a Query | |
Outer Joins | |
Multiple Joins | |
Query Power: Calculated Fields and Text Expressions | |
Calculated Fields | |
Defining a Calculated Field | |
Simple Math with Numeric Fields | |
Expressions with Text | |
Queries That Update Records | |
Understanding Action Queries | |
Testing Action Queries (Carefully) | |
The Action Query Family | |
Update Queries | |
Append Queries | |
Creating an Append (or Make-Table) Query | |
Delete Queries Three | |
Printing Reports and using forms | |
Creating Reports | |
Report Basics | |
Creating a Simple Report | |
Arranging a Report | |
Adding and Removing Fields | |
The Many Views of a Report | |
Creating a Report from Scratch | |
Printing, Previewing, and Exporting a Report | |
Previewing a Report | |
Exporting a Report | |
Getting the Save As PDF Add-inFormatting a Report | |
Formatting Columns and Column Headers | |
Filtering and Sorting a Report | |
Filtering a Report | |
Sorting a Report | |
Creating Simple Forms | |
Form Basics | |
Creating a Simple Form | |
Using a Form | |
Sorting and Filtering in a Form | |
Sorting a Form | |
Filtering a Form | |
Using the Filter by Form Feature | |
Saving Filters for the Future | |
The Form Wizard Four | |
Sharing access with the rest of the world | |
Importing and Exporting Data | |
Case for Importing and Exporting | |
Understanding Exports | |
Understanding Imports | |
Using the Clipboard | |
Copying a Table from Access to Somewhere Else | |
Copying Cells from Excel into Access | |
Import and Export Operations | |
Importable File Types | |
Importing Data | |
Importing from an Excel File | |
Importing from a Text File | |
Exportable File Types | |
Exporting Data | |
Index | |
Table of Contents provided by Publisher. All Rights Reserved. |