Chicago area career training

Microsoft Office 2013 Access Level 3


8 Hours
* Pricing and Logistics are subject to change without notice.

This course is the expert level for Access and expands on topics covered in Levels 1 and 2. It introduces complex concepts such as complex forms, calculated controls, complex reports, subreports, database customization, splitting databases, and customizing the user interface.

About This Course

Upon successful completion of this course, students will be able to:

  • Use the advanced reports feature on understanding report sections.
  • Change the designs of the report to better organize and summarize information and to improve the appearance.
  • Change the format of forms and report through special effects.
  • Create and revise basic Access macros.
  • Generate calculated control within the design of the report.
  • Run macros that require automatic data entry in certain fields.
  • Create macros using keystroke commands and edit basic macros to perform different types of results.
  • Import and export data from other applications as it relates to Access.
  • Understand and use hyperlink fields within Access.

WIOA Approved Training Course


Working with Forms

  • Form Controls
  • Formatting Your Form
  • Creating a Form from a Query
  • Using Subforms
  • Creating a Navigation Form

Using Macros in Access

  • Program Control with If-Then-Else Statements
  • Using Macros in Tables

Database Management

  • Database Management
  • Setting Navigation Options
  • Splitting a Database

Exporting, Importing, and Linking Tables

  • Exporting Files
  • Importing Data
  • Linking Data

Exam Details

Exam 77-424: Microsoft Office Access

After completing Access Levels 1, 2 and 3, students will take the Access exam.

The Logistics of Your Exam

  1. The cost of the exam is an additional $96
  2. Locate a Certiport testing center near you

  3. Create a Certiport Account and Schedule Your Exam

  4. Review Certiport and Microsoft Exam Policies prior to taking your exam

Exam Code 77-424
Number of Questions 40-60
Passing Score N/A
Types of Questions Performance-based live in application testing
Length of Test 50 minutes
Exam Results Provided immediately after exam

Course Schedule

Exam Pass Guarantee

At Microtrain we are committed to your success!
Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!

Learn More