Due to the Coronavirus (COVID-19), the health and safety of our students, visitors, staff and the community at large is our first priority. Social distancing is a must, as such Microtrain will be delivering courses using a remote live solution for all courses until further notice.

Now is the time for us to come together to support each other and tackle the challenges we are facing. Please let us know what we can do for you during this time; we’re always here to assist and help however we can.

We invite you to share your insights, ideas, and strategies with us at requests@microtrain.net.

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

Microsoft Office Specialist  Access 2016: Core Database Management, Manipulation, and Query Skills

  1. Attend all classes to satisfy the required education requirement.
  2. Review the skills measured by the 77-730 certification exam 
  3. Read MicroTrain Access 2016 Courseware, Level 1,2 and 3 books
  4. Complete the classroom labs
  5. Watch Career Academy online training videos to reinforce and retain the knowledge presented in the classroom.
  6. Read GMetrix MOS Practice Tests Quick Start Guide and download GMetrix SMS client.
  7. Qualify for MicroTrain Exam Guarantee, within one (1) year from voucher start date, email two (2) practice exam results in the certification mode with a score of 90% or better to sts@microtrain.net,  and sit for certification exam within 30 days.  
  8. Read the  Microsoft Certification exam policies and FAQs
  9. Locate a Certiport testing center near you
  10. Create a Certiport Account and Schedule Your Exam
  11. Before exam day, save time and review the Microsoft Office Specialist 2016 certification exam tutorial/instructions
  12. Pass the Microsoft Office Specialist 2016 Access exam (77-730). The certification exam must be taken within 30 days of completing the course. The 77- 730 exam is 50 minutes long and consists of 31 performance-based questions conducted in a live or simulated environment. Upon completion of the exam, you will see the overall pass/fail test results. 
  13. Upload photocopy of certification results in your theprofessional.me account. Log in to your theprofessional.me account, click Get Certified in the navigation bar, then navigate to Exam 77-730: Microsoft Office 2016 Access and click the hyperlink next to Date, verify exam date, choose a file to upload, and record your results.

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!

Raves & Praise

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200