Note: There may be minor adjustments to the topics covered in class.

9920: MS-Access Intro

Topics

Lesson 1: Database Fundamentals
Introduction to Access
Identifying Database Components
Designing Data Tables
Relational Database Design

Lesson 2: Access Objects
Starting Access
Database Window Layout and Features
Examining Tables
Examining Queries
Examining Forms
Examining Reports
Quitting Access

Lesson 3: Creating Databases and Tables
Creating Databases
Using Database Wizards to Create
Databases
Creating Blank Databases
Choosing a File Format
Creating Tables and Assigning a Primary
Key using the Table Design Window
Creating Tables using the Table Wizard

Lesson 4: Working with Table Data
Overview of Working with Table Data
Modifying Datasheet Layouts
Changing Column Widths
Moving Columns
Hiding and Showing Columns
Working with Table Records
Adding Records
Editing Records
Deleting Records
Sorting Records
Navigating Through Records

Lesson 5: Working with Table Structure
Modifying Table Design
Adding, Deleting and Moving Fields
Changing Field Names
Modifying Field Properties
Limiting Field Size
Setting Field Formats
Using Input Masks
Setting Required Properties
Specifying Data Validation for Fields

Lesson 6: Locating Information
Finding Records
Overview of Filters
Using Comparison Operators
Using Filters
Filtering by Selection
Filtering by Excluding Selection
Filtering by Form
Filtering for Input

Lesson 7: Working with Related Tables
Overview of Table Relationships
Identifying Table Keys
Understanding Relationship Types
Establishing Relationships
Establishing One-to-Many Relationships
Establishing Many-to-Many Relationships
Enforcing Referential Integrity
Creating Lookup Fields
Using Lookup Fields to Add Data
Modifying Lookup Fields
Using Subdatasheets

Lesson 8: Using Select Queries
Overview of Queries
Creating Select Queries
Using the Query Design Window
Using the Simple Query Wizard
Refining Query Results
Using Criteria in Select Queries
Modifying Select Queries

Lesson 9: Using Advanced Query
Features
Performing Calculations in Queries
Using Aggregate Functions
Using Calculated Fields
Creating and Modifying Unmatched Queries
Creating and Modifying Duplicate Queries
Creating and Applying Advanced Filters

Lesson 10: Creating Advanced Queries
Creating and Modifying Crosstab Queries
Creating Parameter Queries
Creating Action Queries
Creating Update Queries
Creating Make-Table Queries
Creating Append Queries
Creating Delete Queries