PreLaunch Special Only $325 / Pre-Launch Special Good Thru June 30, 2020

Access Certification Pre-Launch Starting June 30, 2020

This certification program contains 31 video courses. These videos contain the same information covered in our LIVE, online, 1-hour, instructor-led classes. You will also be able to download the training guide along with any class files that are used in the video course.

We realize that questions may occur while you are watching a video course. You can submit a question and we'll answer you with either a written answer, a video answer, or a phone call.

Certification Details

  • During the PreLaunch, each week, we'll add one to three new videos starting with Series 100.
  • At the end of each series, you'll have a review test requiring a score of 80% or higher before you can continue to the next series.
  • You'll receive a badge each time you complete a series and a final certificate badge when you complete the certification.
  • We'll also mail you a Certificate of Certification.

Once you've completed all the lessons in all five series, you'll have a final test that also requires a passing score of 80% or higher. You will also need to submit a final project that tests your knowledge of the various topics covered in the Access Certification program. You'll need a passing score of 80% or higher on the project as well in order to receive your Virtual Instructor Access Certification.

Click the series titles below to display video course outlines.

Access 101: Database Overview

Through both lecture and hands on, this overview introduces you to:

  • Basic database terminology
  • Components that make up Microsoft Access
  • Tables, queries, forms, and reports

Access 102: Creating Tables

In this hour, you'll learn:

  • Several ways to create a table in Microsoft Access
  • Different types of fields and field properties
  • Distinctions between Datasheet View and Design View

Access 103: Data Entry Tips and Tricks

This course has a lot of different data entry tips and tricks to teach you. You'll also learn how to:

  • Format a datasheet
  • Export that data into Microsoft Excel or Microsoft Word

Access 104: Create Tables for a Contacts Database

During this hour, you'll be creating a Contact Management database. You'll be:

  • Walking through the process of creating the necessary tables
  • Creating tables that track contact information, phone numbers, and email
  • Designing tables that let you to store files related to the contact and keep chronological notes

Access 105: Create Tables for a Customer Database

Spend this hour discovering how to:

  • Construct the tables necessary to create a Customer database
  • Create tables to track customer information, products, and order details
You'll be able to apply the concepts covered in this class to most database table designs.

Access 201: Importing Data Tips and Tricks

This course teaches you how to:

  • Import data into Access
  • Export data to other programs such as Excel and Word
  • Clean up data in an Excel workbook prior to importing it into Access

Access 202: Filters and Sorts

Learn tips and tricks for:

  • Applying filters and sorting data
  • Using these features in the Datasheet mode, Form View, and Report View

Access 203: Introduction to Queries

This course teaches you the basics for creating queries. You'll learn how to:

  • Link tables
  • Write custom formulas
  • Concatenate data
You'll also learn how to use the Query Wizard to create a query that finds duplicate or unmatched data.

Access 204: Action Queries

Learn how to use the Action queries:

  • Make Table
  • Append
  • Update
  • Delete
Also explore the difference between using the Datasheet View button and the Run button.

Access 205: Advanced Queries

Explore advanced queries using:

  • Calculations
  • IIF function and IsNull function
  • Concatenation to combine text within your queries

Access 206: Table Relationships

This course teaches you about table relationships and referential integrity. You'll learn about:

  • Table normalization
  • Defining relationships between tables
  • Primary Key
  • Applying referential integrity
  • The pros and cons of using referential integrity

Access 207: SQL Queries Part 1

In this segment, you'll be introduced to Structured Query Language (SQL).  You'll be:

  • Examining the structure of SQL queries
  • Learning how to view Access Queries, also known as Query By Example (QBE) as SQL queries
SQL is used by most database programs and Access is no exception.

Access 208: SQL Queries Part 2

In SQL Queries Part 2, you'll learn how to:

  • Recognize and edit SQL queries that are used as Record Sources for forms and reports
  • Write SQL for Action Queries

Access 301: Forms Overview

This is an overview of the types of forms you can create using Microsoft Access. You'll be introduced to:

  • Forms Ribbon
  • Forms Wizard
  • Different types of forms you can create
 You'll learn the pros and cons of each method.

Access 302: Form Layout View Part 1

This course illustrates the basics of working with forms in the Layout View. You'll learn about:

  • Forms are automatically created in the Layout view
  • Design and Arrange Ribbons
  • How to make simple editing and format changes

Access 303: Form Layout View Part 2

In Part 2 of Form Layout View, you'll discover:

  • Advanced ways to work with, edit, and modify Layout forms
  • How to use the Navigation Form to organize multiple forms within your database

Access 304: Form Design View Part 1

In Form Design View Part 1, you'll learn how to:

  • Create a form from scratch using the Design View
  • Add fields and labels to your form
  • Use the Design, Arrange, and Format Ribbons

Access 305: Form Design View Part 2

This hour continues with Form Design View. You'll find out how you can:

  • Add additional objects to a form such as Combo boxes, List boxes, Check boxes, and Option buttons (Radio buttons)
  • Use the Controls Wizard to create Combo boxes and Command buttons

Access 306: Form Design View Part 3

During this segment of Form Design View, we'll show you how to:

  • Create a main form and sub forms
  • Use queries and Text boxes to add formulas to your form
  • Add a Tab Control to the form

Access 307: Form Design View Part 4

Wrapping up Form Design View, in this hour you'll learn about advanced features found in the Property Sheet:

  • Record Source
  • Default View
  • Data Entry
  • Allow Additions,  Allow Deletions, Allow Edits
  • Options for the Detail Section, Text Boxes, Labels, and Buttons

Access 308: Create Forms for a Contacts Database

During this course, you'll create a:

  • Form for an individual contact that contains subforms displaying the contact's phone numbers and email addresses
  • List of contacts
  • Data entry form to add new contacts
The tables used in this class are the same tables that were created in Access 104: Create Tables for a Contacts Database.

Access 309: Create Forms for a Customer Database

During this hour, you'll be designing forms for a Customer database. You'll create:

  • A customer form that displays all the orders placed by the customer
  • An order form that allows the user to enter a new order for an existing customer
The tables used in this class are the same tables that were created in Access 105: Create Tables for a Customer Database.

Access 401: Adding Buttons to a Form

This course introduces you to the Controls Wizard. It demonstrates how to use it to add commonly used buttons to a form. You'll learn how to:

  • Add navigation buttons
  • Include a button to close a form
  • Create a Main Menu form that contains buttons to open several different forms
  • Display the Main Menu form when you open the database

Access 402: Editing Macros

This hour demonstrates how to edit macros you've created using the Control Wizard. It introduces you to the Macro Editor program within Microsoft Access.

You'll learn how to add folders containing Access database to the Access Trust Center so that when you open a trusted database you will no longer see the prompt asking you if the database is trusted.

Access 403: Use the Controls Wizard to Automate Forms

This course uses the techniques learned in the Access 401 and 402 classes to make a database more user-friendly. You'll use the Controls Wizard to add buttons to automate the use of the database by:

  • Improving navigation within forms
  • Opening and closing forms
  • Printing out form data

Access 501: Report Layout View Part 1

Part 1 of Report Layout View demonstrates report options. You'll see how to access the Report Options on the Create Ribbon and use:

  • Report to tabular reports automatically
  • Report Design to create reports from scratch
  • Blank Report not based on any table or query
  • Report Wizard to help you build your report

Access 502: Report Layout View Part 2

In Part 2 of Report Layout View, you'll learn additional formatting commands that allow you to customize the look of your reports created using the Layout View.

Access 503: Report Design View Part 1

This segment of Report Design View shows you how to add fields, groups, and sorts to a report.

Access 504: Report Design View Part 2

This hour of Report Design View shows you how to:

  • Create detailed and summary reports
  • Add calculated fields in group headers and footers
  • Add calculated fields in report headers and footers
You'll also learn why you cannot add calculated fields to page headers or footers.

Access 505: Report Design View Part 3

This course shows you several of the Report Properties, allowing you additional ways to format reports such as:

  • Keeping data together on a page
  • Forcing a new page based on a field change
  • Using the Build command to add commonly used fields to report headers and footers
You'll learn how to allow specific fields to grow or shrink based on the data contained in the fields.

Access 506: Report Design View Part 4

In Report Design View Part 4, you'll see how you can create a Main report that contains sub-report(s).

You'll learn how to display subtotals and totals within these reports.

  I Want This Certification