Access.png
Microsoft Access 2016 Basic (Level I)

 

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Access® can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

 

Course Content: Part I                                                     

 

Lesson 1: Working with an Access Database

Topic A: Launch Access and Open a Database

Topic B: Use Tables to Store Data

Topic C: Use Queries to Combine, Find, Filter, and Sort Data

Topic D: Use Forms to View, Add, and Update Data

Topic E: Use Reports to Present Data

Topic F: Get Help and Configure Options in Microsoft Access


Lesson 2: Creating Tables

Topic A: Plan an Access Database

Topic B: Start a New Access Database

Topic C: Create a New Table

Topic D: Establish Table Relationships


Lesson 3: Creating Queries

Topic A: Create Basic Queries

Topic B: Add Calculated Columns in a Query

Topic C: Sort and Filter Data in a Query


 
Lesson 3: Continued
 
Lesson 4: Creating Forms

Topic A: Start a New Form

Topic B: Enhance a Form


Lesson 5: Creating Reports

Topic A: Start a New Report

Topic B: Enhance Report Layout

 
Course Content: Part II
Microsoft Access 2016 Intermediate (Level II)

 

Your training and experience using Microsoft® Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.

 

Course Content: Part I                                                       

 

Lesson 1: Promoting Quality Data Input

Topic A: Restrict Data Input through Field Validation

Topic B: Restrict Data Input through Forms and Record Validation


Lesson 2: Improving Efficiency and Data Integrity

Topic A: Data Normalization

Topic B: Associate Unrelated Tables

Topic C: Enforce Referential Integrity


Lesson 3: Improving Table Usability

Topic A: Create Lookups within a Table

Topic B: Work with Subdatasheets


Lesson 4: Creating Advanced Queries

Topic A: Create Query Joins

Topic B: Create Subqueries

Topic C: Summarize Data


Lesson 5: Improving Form Presentation

Topic A: Apply Conditional Formatting

Topic B: Create Tab Pages with Subforms and Other Controls


Lesson 6: Creating Advanced Reports

Topic A: Apply Advanced Formatting to a Report

Topic B: Add a Calculated Field to a Report

Topic C: Control Pagination and Print Quality

Topic D: Add a Chart to a Report

 
Course Content: Part II
Microsoft Access 2016 Advanced (Level III)

You have learned many of the basic functions of Microsoft® Access®, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

 

Course Content: Part I                                                         

 

Lesson 1: Importing and Exporting Table Data

Topic A: Import and Link Data

Topic B: Export Data

Topic C: Create a Mail Merge


Lesson 2: Using Queries to Manage Data

Topic A: Create Action Queries

Topic B: Create Unmatched and Duplicate Queries


Lesson 3: Creating Complex Reports and Forms

Topic A: Create Subreports

Topic B: Create a Navigation Form

Topic C: Show Details in Subforms and Popup Forms

 

Lesson 4: Creating Access Macros

Topic A: Create a Standalone Macro to Automate Repetitive Tasks

Topic B: Create a Macro to Program a User Interface Component

Topic C: Filter Records by Using a Condition

Topic D: Create a Data Macro

Lesson 5: Using VBA to Extend Database Capabilities

Topic A: Introduction to VBA

Topic B: Use VBA with Form Controls


Lesson 6: Managing a Database

Topic A: Back Up a Database

Topic B: Manage Performance Issues

Topic C: Document a Database


Lesson 7: Distributing and Securing a Database

Topic A: Split 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

 
Course Content: Part II