Course Outline

Module One: Getting Started

• Workshop Objectives

Module Two: Create and Manage a Database

• Create and Modify Databases
• Create a Blank Desktop Database
• Create a Database from a Template
• Create a Database by Using Import Objects or Data From Other Sources
• Delete Database Objects
• Manage Relationships and Keys
• Set the Primary Key
• View Relationships
• Create and Modify Relationships
• Set Foreign Keys
• Enforce Referential Integrity
• Navigate Through a Database
• Display Objects in the Navigation Pane
• Navigate Specific Records
• Create and Modify a Navigation Form
• Set a Form as the Startup Option
• Change Views of Objects
• Protect and Maintain Databases
• Compact and Repair a Database
• Back Up a Database
• Recover Data from Backup
• Split a Database
• Encrypt a Database with a Password
• Print and Export Data
• Print Reports
• Print Records
• Save a Database as a Template
• Export Objects to Alternative Formats
• Module Two: Review Questions

Module Three: Build Tables

• Create Tables
• Create a Table
• Import Data into Tables
• Create Linked Tables From External Sources
• Import Tables from Other Databases
• Create a Table from a Template with Application Parts
• Manage Tables
• Hide Fields in Tables
• Add Total Rows
• Rename Tables
• Add Table Descriptions
• Manage Records in Tables
• Update Records
• Add Records
• Delete Records
• Append Records from External Data
• Find and Replace Data
• Sort Records
• Filter Records
• Create and Modify Fields
• Add Fields to Tables
• Add Validation Rules to Fields
• Change Field Captions
• Change Field Sizes
• Change Field Data Types
• Configure Fields to Auto Increment
• Set Default Values
• Using Input Masks
• Delete Fields
• Review Questions: Module Three

Module Four: Create Queries

• Create a Query
• Run a Query
• Create a Crosstab Query
• Add Parameter to a Query
• Create an Action Query
• Create a Multi-Table Query
• Save a Query
• Modify a Query
• Rename a Query
• Add Fields
• Remove Fields
• Hide Fields
• Sort Data Within Queries
• Format Fields Within Queries
• Create Calculated Fields and Grouping Within Queries
• Add Calculated Fields
• Set Filtering Criteria
• Use Comparison Operators
• Use Arithmetic Operators
• Use Logical Operators
• Group and Summarize Data
• Module Four Review Questions

Module Five: Create Forms

• Create a Form
• Create a Form
• Change Form View
• Create a Form from a Template with Application Parts
• Save a Form
• Configure Form Controls
• Move Form Controls
• Add Form Controls
• Remove Form Controls
• Set Form Control Properties
• Modify Data Sources
• Manage Labels
• Add Sub-Forms
• Format a Form
• Modify Tab Order
• Configure Print Settings
• Sort Records by Form Field
• Apply a Theme
• Control Form Positioning
• Insert Backgrounds
• Insert Headers and Footers
• Insert Images
• Module Five Review Questions

Module Six: Create Reports

• Create a Report
• Create a Report Based on the Query or Table
• Create a Report by Using a Wizard
• Create a Report in Design View
• Configure Report Controls
• Add Report Controls
• Add and Modify Labels
• Modify Data Sources
• Add Calculated Fields
• Group and Sort Fields
• Format a Report
• Format a Report into Multiple Columns
• Change Report Orientation
• Control Report Positioning
• Format Report Elements
• Insert Header and Footer Information
• Insert Images
• Apply a Theme
• Module Six Review Questions

Module Seven: Wrapping Up

• Words from the Wise
• Lessons Learned