Course Length: 2 days
Prerequisites: General knowledge of Windows.

See Dates for this class

This course targets individuals interested in learning the features of Microsoft Access 2003.

What’s in Access 2003: Module I?
Access 2003 Module I is a course that presents skills training and assessment for some of the skill sets that form the Microsoft Office Access 2003 Specialist exam. This course provides competency in database fundamentals, working with Access objects, creating databases and tables, working with table data and structure, locating information, working with related tables, using select queries and advanced query features, and creating advanced queries.

 

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