Table of Contents -- Chapter 1 GETTING STARTED -- Introduction to Access -- Start Access -- Parts of a Database -- Plan a Database -- Create a Database Using the Database Wizard -- Create a Blank Database -- Open a Database -- Using the Database Window -- Rename a Database Object -- Delete a Database Object -- Minimize a Window -- Display or Hide a Toolbar -- Search for a Database -- Back Up a Database -- Getting Help -- Chapter 2 CREATE TABLES -- Create a Table in the Datasheet View -- Create a Table Using the Table Wizard -- Open a Table -- Change a Column Width -- Rename a Field -- Rearrange Fields -- Add a Field -- Delete a Field -- Change the Appearance of a Table -- Chapter 3 EDIT TABLES -- Move Through Data -- Select Data -- Edit Data -- Zoom Into a Cell -- Display a Subdatasheet -- Check Spelling -- Move or Copy Data -- Add a Record -- Delete a Record -- Change the Font of Data -- Hide a Field -- Freeze a Field -- Chapter 4 DESIGN TABLES -- Change the View of a Table -- Add a Field -- Delete a Field -- Rearrange Fields -- Display Field Properties -- Add a Field Description -- Change a Data Type -- Select a Format -- Change the Field Size -- Change the Number of Decimal Places -- Add a Caption -- Set a Default Value -- Data Entry Required -- Add a Validation Rule -- Create an Input Mask -- Create a Field to Store Pictures -- Create a Lookup Column -- Create a Yes/No Field -- Create a Hyperlink Field -- Using Smart Tags -- Chapter 5 ESTABLISH RELATIONSHIPS -- View Object Dependencies -- Set the Primary Key -- Create Relationships Between Tables -- Enforce Referential Integrity -- Chapter 6 CREATE FORMS -- Create a Form Using an AutoForm -- Create a Form Using the Form Wizard -- Open a Form -- Move Through Records -- Edit Data -- Add a Record -- Delete a Record -- Chapter 7 DESIGN FORMS -- Change the View of a Form.

Move or Resize a Control -- Delete a Control -- Change the Size of a Form -- Add a Field -- Add a Label -- Change Label Text -- Bold, Italicize or Underline Data -- Change the Font of Data -- Change the Size of Data -- Change the Color of a Control -- Change the Alignment of Data -- Undo Changes -- Add a Picture -- Apply Conditional Formatting -- Apply an AutoFormat -- Chapter 8 FIND DATA -- Sort Records -- Find Data -- Replace Data -- Filter by Selection -- Filter by Input -- Filter by Exclusion -- Filter by Form -- Chapter 9 CREATE QUERIES -- Create a Query in the Design View -- Create a Query Using the Simple Query Wizard -- Change the View of a Query -- Open a Query -- Rearrange Fields -- Add Fields -- Delete a Field -- Hide a Field -- Sort Query Results -- Using Criteria to Find Records -- Using Multiple Criteria to Find Records -- Examples of Criteria -- Display Highest or Lowest Values -- Perform Calculations -- Using Parameters -- Summarize Data -- Find Unmatched Records -- Chapter 10 USING THE PIVOTTABLE AND PIVOTCHART VIEWS -- Using the PivotTable View -- Using the PivotChart View -- Chapter 11 CREATE REPORTS -- Create a Report Using the Report Wizard -- Create a Report Using an AutoReport -- Open a Report -- Move Through Pages -- Change the View of a Report -- Zoom In or Out -- Apply an AutoFormat -- Add a Picture -- Chapter 12 PRINT INFORMATION -- Preview Before Printing -- Change Page Setup -- Print Information -- Create Mailing Labels -- Chapter 13 CREATE DATA ACCESS PAGES -- Create a Data Access Page -- Change the View of a Data Access Page -- Open a Data Access Page -- Add a Title -- Move Through Records -- Apply a Theme -- Rename a Data Access Page -- Delete a Data Access Page -- Index -- A -- B -- C -- D -- E -- F -- G -- H -- I -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- Y -- Z.