Microsoft Access Database Training Course

Microsoft Access Database Training Course Outline for 6 hours of learning (Introduction)

Group or 1-on-1 Training in 2 x 3 hour units over 2 days

Training Course Content – Level 1

Lesson 1: Getting Started with Access Databases

Identify the Elements of the Access 2013/16 Interface
Compare with Excel
Identify the Components of a Database
Examine the Relational Database Design Process

Lesson 2: Building the Structure of a Database

Create a New Database
Create a Table Using the Design View
Manage Tables
Establish Table Relationships

Lesson 3: Managing Data in a Table

Modify Table Data
Sort and Filter Records
Work with Subdatasheets

Lesson 4: Querying a Database

Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping

Lesson 5: Designing Forms

Create a Form
Modify the Design of a Form
View and Edit Data Using an Access Form

Lesson 6: Generating Reports

Create a Report
Format the Controls in a Report
Enhance the Appearance of a Report
Prepare a Report for Print

Training Course Content – Level 2 (Additional 6 hours)

Lesson 1: Controlling Data Entry

Constrain Data Entry Using Field Properties
Establish Data Entry Formats for Entering Field Values
Create a List of Values for a Field

Lesson 2: Joining Tables

Create Query Joins
Join Tables with No Common Fields
Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries

Lesson 4: Improving Forms

Restrict Data Entry in Forms
Organize Information with Tab Pages
Add a Command Button to a Form
Create a Subform
Display a Summary of Data in a Form
Change the Display of Data Conditionally

Lesson 5: Customizing Reports

Organize Report Information
Format Reports
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge

Fast Track Computer Solutions helping 1000’s in WA since 1985. Call Ivor NOW on (08) 9275-9188.

Call us Now!