Microsoft Access Training

Learning Outcomes:      At the completion of this course, students will be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

Course Pre-Requisites:  Microsoft Access Level 1 assumes students have little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

 

COURSE OUTLINE

Getting to Know Access

Understanding Microsoft Access

Starting Access From the Desktop

Understanding the Start Screen

Creating a New Blank Database

Understanding the Backstage View

Opening an Existing Database File

Understanding the Access Screen

Using the Ribbon

Working With the Navigation Pane

Adding Commands to the QAT

Working With Touch Mode

Working With a Table

Working With Other Database Objects

Closing a Database File

Exiting From Access

 

Designing a Lookup Database

Understanding How Access Stores Data

Understanding Access Data Types

Scoping Your New Database

Identifying Table Problems

Refining Table Structures

Finalising the Design

 

Creating a Lookup Database

Creating a New Database File

Creating the Lookup Table

Defining the Primary Key

Saving and Closing a Table

Creating the Transaction Table

Understanding Lookup Table Relationships

Connecting to a Lookup Table

Viewing Table Relationships

 

Modifying Table Structures

Opening an Existing Table

Adding Fields to an Existing Table

Understanding Field Properties

Changing Field Size & Field Names

Changing Decimal Places

Changing Date Formats

Indexing Fields

Deleting Fields From a Table

 

Copying a Table Within a Database

Deleting a Table From a Database File

 

Adding Records to a Table

Typing Records in a Table

Adding Records Using a Form

Saving a Form Layout for Reuse

Adding Records Using an Existing Form

Adding Additional Records

Importing From Microsoft Excel

 

Adding Transactional Records

Typing Transactional Records

Adding Transactional Records Using a Form

Adding Additional Transactional Records

Adding Records Using a Subdatasheet

Removing a Subdatasheet

Inserting a Subdatasheet

 

Working With Records

Table Navigation

Navigating to a Specific Record

Editing a Record

Deleting Record Data

Undoing a Change

Deleting a Record

Deleting Several Records

Searching in a Table

Searching in a Field

Finding and Replacing

Printing Records From a Table

Compacting a Database

 

Sorting and Filtering

Simple Sorting

Sorting on Several Fields

Simple Filtering

Working With Filters

Filtering Between Dates

 

Creating Queries

Understanding Queries

Creating a Query Design

Working With a Query

Changing a Query Design

Applying Record Criteria

Clearing Selection Criteria

Saving a Query

Running Queries From the Navigation Pane

Creating Additional Queries

 

Creating and Using Reports

Understanding Reporting in Access

Creating a Basic Report

Working With Existing Reports

Previewing and Printing a Report

Changing the Report Layout

Using the Report Wizard

Creating a Grouped Report

Creating a Statistical Report

Working With Grouped Reports

 

Creating and Using Forms

Understanding Forms

Creating a Basic Form

Creating a Split Form

Binding a Form to a Query

Using the Form Wizard

Working With Existing Forms

Editing Records in a Form

Deleting Records Through a Form

Deleting an Unwanted Form