Overview:

This course is designed for students who wish to learn the basic and intermediate-level operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

The first day addresses job responsibilities that include working with tables to create and maintain records, locate records and produce reports based on the information in the database.

It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

The second day addresses job responsibilities that include creating new databases, tables and relationships, as well as working with and revising intermediate-level queries, forms and reports.

It also introduces integrating Access data with other Microsoft applications.

Course Outline:

Lesson 1: An Overview of Microsoft Access

   Relational databases
   The Access environment
   The database environment
   Examine an Access table

Lesson 2: Managing Data

   Examine an Access form
   Add & delete records
   Sort records
   Display record sets
   Update records
   Run a report

Lesson 3: Establishing Table Relationships

   Identify table relationships
   Identify primary and foreign keys in the relationship
window
   Working with sub datasheets

Assessment:

Candidates will complete a short assesment. On completion, they will receive a Certificate of Training.