Microsoft Access 2016 Beginner to Advanced

COURSE CURRICULUM

Module - 1

Orientation to Microsoft Access

Create a Simple Access Database

Get Help in Microsoft Access

Modify Table Data

Work with Records

Sort and Filter Records

Create Lookups

Join Data from Different Tables in a Query

Sort and Filter Data in a Query

Perform Calculations in a Query

Create Parameter Queries

Create Action Queries

Create Find Duplicate and Find Unmatched Queries

Summarize Data

Create a Report

Add Controls to a Report

Enhance the Appearance of a Report

Prepare a Report for Print

The Access Options Dialog Box

Relational Database Design

Create a Table

Modify a Table and Fields

Create Table Relationships

Create Query Joins

Join Tables That Have No Common Fields

Relate Data within a Table

Work with Subdatasheets

Create Subqueries

Data Normalization

Create a Junction Table

Import Data into Access

Export Data to Text File Formats

Export Access Data to Excel

Create a Mail Merge

Organize Report Information

Format Reports

Include Charts in a Report

Add a Calculated Field to a Report

Add a Subreport to an Existing Report

Create a Mailing Label Report

Publish a Report as PDF

Module - 2

Add Controls to Forms

Set Form Controls

Create Subforms

Organize Information with Tab Pages

Enhance Navigation with Forms

Format a Form

Apply Conditional Formatting

Field Validation

Form and Record Validation

Create a Macro

Restrict Records Using a Condition

Validate Data Using a Macro

Automate Data Entry Using a Macro

Convert a Macro to VBA

Link Tables to External Data Sources

Manage a Database

Determine Object Dependency

Document a Database

Analyze the Performance of a Database

Split a Database for Multiple User Access

Implement Security

Set Passwords

Convert an Access Database to an ACCDE File

Package a Database with a Digital Signature

Create a Database Switchboard

Modify a Database Switchboard

Set Startup Options