Database Relationships

·          A Look at Relationships

·          Creating a One-to-One Relationship

·          Creating a One-to-Many Relationship

·          Creating a Many-to-Many Relationship

·          Enforcing Referential Integrity

·          Cascade Update Related Fields

·          Cascade Delete Related Records

·          Creating & Printing a Relationship Report

Working with Tables

·          Setting Validation Rules

·          Formatting Fields

·          Indexing Fields

·          Requiring Data Entry

·          Creating an Input Mask

·          Creating a Lookup Field

·          Creating a Value List

·          Modifying a Value List

·          Creating Multiple Primary Keys

·          Creating Multiple Field Values

Working with Queries

·          Creating Multi-table Queries

·          Using Calculations in Queries

·          Changing Query Properties

·          Working with Expression Builder

·          Creating a Totals Query

·          Creating a Parameter Query

·          Creating a Find Duplicates Query

·          Creating a Find Unmatched

·          Records Query

·          Modifying Query Joins

Working with Forms

·          Adding Headers and Footers

·          Adding Controls to a Form

·          Moving and Sizing Controls

·          Creating a Calculated Control

·          Changing Control Properties

·          Changing Form Properties

·          Changing the Tab Order

·          Adding a Lookup Control

·          Inserting Graphics

·          Creating a Subform

Working with Reports

·          Working with Report Sections

·          Adding Controls to a Report

·          Changing Control Properties

·          Creating a Calculated Control

·          Changing a Control’s Data Source

·          Changing a Report’s Data Source

·          Sorting and Grouping Data

·          Changing Report Section Properties

·          Inserting Graphics

·          AutoFormatting a Report