Section A: Introduction
· Relational Databases
· Flat System
· Relational System
· Database Components

Section B: Database Objects
· Tables
· Queries
· Forms
· Reports
· Macros
· Modules
· Data Access Page

Section C: Database Planning
· Naming Conventions
· Convention Examples
· Database Design
· Plan Purpose
· Plan Tables
· Plan Fields
· Field Names
· Plan Relationships

Section D: Examining Access
· Starting Access
· Table View
· Switching Views
· Query View
· Forms View
· Report View
· Create New Database
· Database Wizard

Section E: Creating Tables
· File Format Considerations
· Create Table
· Data Type
· Description
· Assign Primary Key
· Saving
· Using the Table Wizard

Section F: Text Field Properties
· Field Size
· Format
· Caption
· Default Value
· Required
· Allow Zero Length
· Numbered Text Fields
· Input Mask

Section G: Number Field Properties
· Number Field Size
· Format Date
· Validation Rule
· Validation Text
· Validation Data
· End Date Validation Rule

Section A: Working with Data
· Moving Through Datasheets
· Adding Records
· Editing Records
· Deleting Records
· Keyboard Shortcuts

Section B: Working with Datasheets
· Modifying Datasheet Format
· Modifying Datasheet Font
· Modifying Column Widths
· Hiding/Showing Columns
· Moving Columns

Section C: Manipulating Data
· Sorting Data
· Finding Data
· Filtering Data
· Filter Excluding Selection
· Filter for Input
· Filter by Form
· Saving As Query

Section D: Working with Table Structure
· Manipulating Fields
· Changing Data Types
· Deleting Fields
· Moving Fields
· Using Name AutoCorrect
· Property Update Options
· Creating Lookup Fields
· Using Lookup Wizard

Section E: Dependencies & Datasheets
· Checking Object Dependencies
· Subdatasheets
· Manipulating Subdatasheets

Section F: Shaping Up Tables
· Copying
· Renaming
· Deleting
· Printing Tables

Section G: Importing & Exporting
· Importing
· Import Spreadsheet Wizard
· Exporting

Section H: Relationships
· Understanding Relationships
· Referential Integrity
· Join Types
· Understanding Join Types
· Relationship Types

Section I: Creating Relationships
· Relationship Setup
· Adding Tables
· Arranging Tables
· Create Permanent Relationship
· Printing Relationships

Section A: Select Queries
· Creating in Design View
· Sorting
· Adding Additional Tables
· Changing Relationship Type
· The Show Box

Section B: Filtering with Criteria
· Exact Entries
· Comparison Operators
· Filter Range
· Null/Not Null
· Using "And" Statements
· Either "Or" Statements
· Unique Values

Section C: Calculations
· Formulas
· Group By
· Concatenation

Section D: Intro to Forms
· Creating Auto Forms
· Form Components
· Working with Controls
· Aligning Controls
· Removing Controls
· Adding Controls
· Using the Forms Wizard

Section E: Working in Forms
· Formatting Forms
· Control Properties
· Navigating a Form

Section F: Data Access Pages
· Save Form As
· Using the Page Wizard
· Apply Themes
· Preview in Browser

Section G: Working with Reports
· Creating Auto Reports
· Using the Reports Wizard
· Report Controls & Sections
· Modifying Controls
· Changing Sorting & Grouping
· Controlling Page Breaks
· Report Output Options
· Exporting to Word

Section H: Maintaining Database
· Using Compact & Repair
· Backing up Data
· Convert Database