Chicago area career training

Microsoft Office 2016 Access Level 3

Summary

Instructor-led
250
On-site
Call
Duration
8 Hours
* Pricing and Logistics are subject to change without notice.
 

Welcome to Microsoft Office Access 2016 courseware. Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user.

This course is intended to help all users get up to speed on the different features of Access and to become familiar with its more advanced features. We will cover how to complete advanced form design tasks, add field and record validation, create and manage macros, conduct advanced database management, distribute and secure a database, and manage switchboards.

About This Course

By the end of this course, users should be comfortable working with forms, validating fields and records, creating and using macros, conducting advanced database management tasks, distributing databases, and managing switchboards. This course is divided into lessons. Each lesson focuses on several key topics, each of which outlines easy-to-follow concepts. At the end of each topic, you will be given an activity to complete. At the end of each lesson, we will summarize what has been covered and provide a few review questions. Supplemental learning for selected topics is provided in the form of Lesson Labs at the end of this book.

Outline

Lesson 1: Implementing Advanced Form Design

Lesson 2: Creating Form Validation and Macros

Lesson 3:  Sharing Data Across Applications

Lesson 4: Using Advanced Database Management

Lesson 5: Distributing and Securing a Database

Lesson 6: Managing Switchboards

Prerequisites

This class assumes that the user has completed or has an understanding of the materials covered in the first part of the Microsoft Office Access 2016 courseware, including:

§  Getting started with Access

§  Working with table data

§  Querying a database

§  Creating advanced queries

§  Generating reports and using advanced reporting tools

§  Customizing the Access environment

§  Designing a relational database

§  Joining tables

§  Organizing a database for efficiency

§  Sharing data across applications 

Exam Details

Exam 77-730: Microsoft Office 2016 Access

Course Schedule

Chicago
200 W Adams Suite 410 Chicago, IL 60606
08/30/2019 09:00 am - 05:00 pm
S M T W T F S
Lombard
720 E Butterfield Rd Suite 100 Lombard, IL 60148
08/30/2019 09:00 am - 05:00 pm
S M T W T F S
10/08/2019 - 10/10/2019 06:00 pm - 10:00 pm
S M T W T F S
Deerfield
770 Lake Cook Rd Suite 200 Deerfield, Il 60015
08/30/2019 09:00 am - 05:00 pm
S M T W T F S

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