Basic

Lesson 1: Getting Started with Access

  • Topic A: Orientation to Microsoft Access
  • Topic B: Create a Simple Access Database
  • Topic C: Get Help in Microsoft Access

Lesson 2: Working with Table Data

  • Topic A: Modify Table Data
  • Topic B: Work with Records
  • Topic C: Sort and Filter Records
  • Topic D: Create Lookups

Lesson 3: Querying a Database

  • Topic A: Join Data from Different Tables in a Query
  • Topic B: Sort and Filter Data in a Query
  • Topic C: Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

  • Topic A: Create Parameter Queries
  • Topic B: Create Action Queries
  • Topic C: Create Find Duplicate and Find Unmatched Queries
  • Topic D: Summarize Data

Lesson 5: Generating Reports

  • Topic A: Create a Report
  • Topic B: Add Controls to a Report
  • Topic C: Enhance the Appearance of a Report
  • Topic D: Prepare a Report for Print

Lesson 6: Customizing the Access Environment

  • Topic A: The Access Options Dialog Box

Lesson 7: Designing a Relational Database

  • Topic A: Relational Database Design
  • Topic B: Create a Table
  • Topic C: Modify a Table and Fields
  • Topic D: Create Table Relationships

Lesson 8: Joining Tables

  • Topic A: Create Query Joins
  • Topic B: Join Tables That Have No Common Fields
  • Topic C: Relate Data within a Table
  • Topic D: Work with Subdatasheets
  • Topic E: Create Subqueries

Lesson 9: Organizing a Database for Efficiency

  • Topic A: Data Normalization
  • Topic B: Create a Junction Table

Lesson 10: Sharing Data Across Applications

  • Topic A: Import Data into Access
  • Topic B: Export Data to Text File Formats
  • Topic C: Export Access Data to Excel
  • Topic D: Create a Mail Merge

Lesson 11: Advanced Reporting

  • Topic A: Organize Report Information
  • Topic B: Format Reports
  • Topic C: Include Charts in a Report
  • Topic D: Add a Calculated Field to a Report
  • Topic E: Add a Subreport to an Existing Report

Lesson 12: Additional Reporting Options

  • Topic A: Create a Mailing Label Report
  • Topic B: Publish a Report as PDF

Intermediate

Lesson 1: Implementing Advanced Form Design

  • Topic A: Add Controls to Forms
  • Topic B: Set Form Controls
  • Topic C: Create Subforms
  • Topic D: Organize Information with Tab Pages
  • Topic E: Enhance Navigation with Forms
  • Topic F: Format a Form
  • Topic G: Apply Conditional Formatting

Lesson 2: Using Data Validation

  • Topic A: Field Validation
  • Topic B: Form and Record Validation

Lesson 3: Using Macros to Improve User Interface Design

  • Topic A: Create a Macro
  • Topic B: Restrict Records Using a Condition
  • Topic C: Validate Data Using a Macro
  • Topic D: Automate Data Entry Using a Macro
  • Topic E: Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

  • Topic A: Link Tables to External Data Sources
  • Topic B: Manage a Database
  • Topic C: Determine Object Dependency
  • Topic D: Document a Database
  • Topic E: Analyze the Performance of a Database

Lesson 5: Distributing and Securing a Database

  • Topic A: Split a Database for Multiple User Access
  • Topic B: Implement Security
  • Topic C: Set Passwords
  • Topic D: Convert an Access Database to an ACCDE File
  • Topic E: Package a Database with a Digital Signature

Lesson 6: Managing Switchboards

  • Topic A: Create a Database Switchboard
  • Topic B: Modify a Database Switchboard
  • Topic C: Set Startup Options