Log On/Register  

855.838.5028

Access

Duration: 3 Days, 6 Modules
Module Price: $130

Access: Day 1

Module 1

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help and Configure Options in Microsoft Access

 

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

 

Lesson 3: Querying a Database

Topic A: Create Basic Queries

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

 

Module 2

Lesson 4: Using Forms

Topic A: Create Basic Access Forms

Topic B: Work with Data on Access Forms

 

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Topic E: Organize Report Information

Topic F: Format Reports

 

Access: Day 2

Module 3

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design

Topic B: Create a Table

Topic C: Create Table Relationships

 

Lesson 2: Joining Tables

Topic A: Create Query Joins

Topic B: Relate Data Within a Table

Topic C: Work with Subdatasheets

 

Lesson 3: Using Data Validation

Topic A: Use Field Validation

Topic B: Use Form and Record Validation

 

Module 4

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Summarize Data

Topic C: Create Subqueries

Topic D: Create Action Queries

Topic E: Create Unmatched and Duplicate Queries

 

Lesson 5: Organizing a Database for Efficiency

Topic A: Data Normalization

Topic B: Create a Junction Table

Topic C: Improve Table Structure

 

Lesson 6: Using Advanced Reporting Techniques

Topic A: Include Control Formatting in a Report

Topic B: Add a Calculated Field to a Report

Topic C: Add a Subreport to an Existing Report

 

Access: Day 3

Module 5

Lesson 1: Implementing Advanced Form Design

Topic A: Add Controls to Forms

Topic B: Enhance Navigation and Organization of Forms

Topic C: Apply Conditional Formatting

 

Lesson 2: Sharing Data Across Applications

Topic A: Import Data into Access

Topic B: Export Access Data

Topic C: Link Tables to External Data Sources

Topic D: Create a Mail Merge

 

Lesson 3: Using Macros to Improve User Interface Design

Topic A: Create a Macro

Topic B: Restrict Records Using a Condition

Topic C: Validate Data Using a Macro

Topic D: Automate Data Entry Using a Macro

 

Lesson 4: Using VBA

Topic A: Getting Started with VBA

Topic B: Enhance Access Using VBA

 

Module 6

Lesson 5: Using Advanced Database Management

Topic A: Manage a Database

Topic B: Determine Object Dependency

Topic C: Document a Database

 

Lesson 6: Distributing and Securing a Database

Topic A: Splitting a Database for Multiple User Access

Topic B: Implement Security

Topic C: Convert an Access Database to an ACCDE File

Topic D: Package a Database with a Digital Signature

 

Lesson 7: Managing Switchboards

Topic A: Create a Database Switchboard

Topic B: Modify a Database Switchboard

Topic C: Set Startup Options

Access: Day 1

Module 1

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help and Configure Options in Microsoft Access

 

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

 

Lesson 3: Querying a Database

Topic A: Create Basic Queries

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

 

Module 2

Lesson 4: Using Forms

Topic A: Create Basic Access Forms

Topic B: Work with Data on Access Forms

 

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Topic E: Organize Report Information

Topic F: Format Reports

 

Access: Day 2

Module 3

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design

Topic B: Create a Table

Topic C: Create Table Relationships

 

Lesson 2: Joining Tables

Topic A: Create Query Joins

Topic B: Relate Data Within a Table

Topic C: Work with Subdatasheets

 

Lesson 3: Using Data Validation

Topic A: Use Field Validation

Topic B: Use Form and Record Validation

 

Module 4

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Summarize Data

Topic C: Create Subqueries

Topic D: Create Action Queries

Topic E: Create Unmatched and Duplicate Queries

 

Lesson 5: Organizing a Database for Efficiency

Topic A: Data Normalization

Topic B: Create a Junction Table

Topic C: Improve Table Structure

 

Lesson 6: Using Advanced Reporting Techniques

Topic A: Include Control Formatting in a Report

Topic B: Add a Calculated Field to a Report

Topic C: Add a Subreport to an Existing Report

 

Access: Day 3

Module 5

Lesson 1: Implementing Advanced Form Design

Topic A: Add Controls to Forms

Topic B: Enhance Navigation and Organization of Forms

Topic C: Apply Conditional Formatting

 

Lesson 2: Sharing Data Across Applications

Topic A: Import Data into Access

Topic B: Export Access Data

Topic C: Link Tables to External Data Sources

Topic D: Create a Mail Merge

 

Lesson 3: Using Macros to Improve User Interface Design

Topic A: Create a Macro

Topic B: Restrict Records Using a Condition

Topic C: Validate Data Using a Macro

Topic D: Automate Data Entry Using a Macro

 

Lesson 4: Using VBA

Topic A: Getting Started with VBA

Topic B: Enhance Access Using VBA

 

Module 6

Lesson 5: Using Advanced Database Management

Topic A: Manage a Database

Topic B: Determine Object Dependency

Topic C: Document a Database

 

Lesson 6: Distributing and Securing a Database

Topic A: Splitting a Database for Multiple User Access

Topic B: Implement Security

Topic C: Convert an Access Database to an ACCDE File

Topic D: Package a Database with a Digital Signature

 

Lesson 7: Managing Switchboards

Topic A: Create a Database Switchboard

Topic B: Modify a Database Switchboard

Topic C: Set Startup Options

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):

The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.

ITIL® is a registered trade mark of AXELOS Limited, used under permission of AXELOS Limited. The Swirl logo is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.