Database Normalisation:
• The Rules of Normalization 

Relating Tables:
• One-to-One Relationships 
• One-to-Many Relationships 
• Many-to-Many Relationships 

Referential Integrity:
• Planning Relationships Between Tables 
• Orphan Records 
• Cascading Deletes 
• Cascading Updates 

Database Management:
• Repairing a Database 
• Compacting a Database 
• Backing up Your Database 
• Editing Database Properties 

Saving Your Files:
• Save As Dialogue 
• Object Properties 
• AutoRecover 

Exporting Files:
• Exporting to Word 
• Exporting to Excel 
• Exporting to Older Versions of Access 
• Exporting vs. Save As 

Linking Files:
• Linking to an Excel Spreadsheet 
• Linking to Another Database 
• Creating a Hyperlink 

Customizing Tables:
• Understanding Field Properties 
• Adding a Primary Key to a Table 
• Indexing a Field 
• Inserting, Deleting, and Moving Fields 
• Importing a Table from Another Source 

Formatting Tables:
• Formatting Number Fields 
• Formatting Text Fields 
• Adding Field Descriptions 
• Changing Field Data Types 
• Adding Captions 

Controlling Table Data Entry:
• Setting a Default Value 
• Setting a Required Value 
• Creating and Using Input Masks 
• Creating and Removing Table Relationships 

Managing Table Data Entry:
• How to Validate Data 
• Creating a Lookup Field 
• Modifying a Lookup Field 
• Creating a Value List 
• Modifying a Value List 

Basic Form Controls:
• Adding a Control 
• The Control Wizard 
• Cutting, Copying, Pasting, and Moving a Control 
• Formatting a Control 

Advanced Form Controls:
• Modifying a Control’s Properties 
• Changing a Control’s Data Source 
• Changing a Control’s Default Value 
• Creating a Calculated Control 
• Using Form Properties 

Formatting a Form:
• Formatting Gridlines 
• Modifying the Font 
• Adding Images 
• Using AutoFormat 

Organizing Report Data:
• Adding and Removing Fields 
• Using Report Sections 
• Changing Section Properties 
• Grouping and Sorting in a Report 
• Changing Group Properties 
• Using Calculated Controls in a Report 

Formatting Reports:
• Formatting Gridlines 
• Modifying the Font 
• Adjusting the Layout of your Report 
• Using AutoFormat 

Common Report Tasks:
• Adding a Photo 
• Adjusting Page Properties 
• Adding Headers and Footers 
• Adding Page Numbers 
• The Label Wizard 

Basic Queries:
• Review of Queries 
• Creating a Query 
• Sorting a Query 
• Filtering a Query 
• Hiding Fields 
• AND/OR Operators 
• IIF Functions 

Multiple Table Queries:
• Creating a Multiple Table Query 
• Creating a Calculated Field 
• The Expression Builder 
• Using Queries to Summarize 
• Make-Table Queries 

Management (Action) Queries:
• Append Queries 
• Delete Queries 
• Update Queries 
• Exporting Queries