1 1

Microsoft Access Expert 2019 (MO-500) - Single Title Bundle + Retake

Microsoft Access Expert 2019 (MO-500) - Single Title Bundle + Retake

$320.00 NZD
$320.00 NZD
Sale Sold out

Overview of Microsoft Access Expert Certification Bundle

Microsoft Access is a database application software used to store, manage, and analyze large amounts of structured data. Microsoft Access Expert is designed for advanced users who need to build and manage complex databases. The Microsoft Office Specialist: Microsoft Access Expert (Office 2019) - MO-500 Certification assesses your ability to correctly apply Access's advanced features to create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries. This certification bundle for Microsoft Access includes everything needed to learn, practice, and certify.

Product Summary

This Bundle includes the Learning Materials, Practice Test, and Certification Exam Voucher with Retake providing everything needed to build proficiency and successfully achieve the Microsoft Access Expert (Office 2019) - MO-500 Certification.

Included Products

  • Learn: Microsoft Access Expert – Learning Material (LearnKey via GMetrix)
  • Practice: Microsoft Access Expert – Practice License (CertPREP via GMetrix)
  • Certify: Microsoft Access Expert – Certification Exam Voucher + Retake

Learn: Microsoft Access Expert – Learning Material

What you’ll learn

This course teaches students how to use Microsoft Access to manage databases, create and modify tables, create and modify queries, modify forms, and modify reports. Though not on the exam, special coverage is given to the concept of relational databases, as it is critical one understands this when working with Access. Learners will build relational database skills while preparing for the Microsoft Access Expert (Office 2019) - MO-500 Certification.

What’s included

  • Lessons with Video Training and Exercise Labs  
  • Post-Assessments  
  • 1-Year Access to Learning Platform 

Product Benefits 

  • Gain the skills to successfully obtain your Microsoft Access Expert (Office 2019) - MO-500 Certification
  • Develop advanced, job-ready skills in building and managing databases
  • Enjoy flexible, self-paced learning accessible online at any time  

Useful Information

  • Estimated Completion Time: 22.5 Hours
  • Self-paced format with no prior experience required
  • Online progress tracking
  • Recommended pathway for Microsoft Office Specialist Expert 2019

How your course will be delivered

LearnKey is a premier global provider of self-paced, expert-led training designed for both educational institutions and individual learners and is ACE Training’s preferred partner to host our self-paced courses. Delivered via the GMetrix platform, LearnKey courses are flexible, engaging, and easy to use - bringing the classroom experience directly to you, anytime and anywhere. Each course includes high-quality video instruction, interactive labs, and assessments that align with official exam objectives.

Practice: Microsoft Access Expert – Practice License

About this Practice Test  

CertPREP Practice Tests are designed to replicate the certification exam experience so you can prepare yourself for the actual exam. Practice tests use the same in-app exam format as the Certiport certification exam and are mapped to the certification objectives so you can be assured you'll be practicing skills to help you pass the certification exam. Practice tests are offered in two modes: Testing and Training Modes. You can either practice under timed conditions or learn at your own pace with step-by-step guidance. This license includes up to 30 attempts over one year for a selected title, ensuring targeted, effective exam preparation.  

What the Practice Test measures

  • Manage Databases
  • Create and Modify Tables
  • Create and Modify Queries
  • Modify Forms in Layout View
  • Modify Reports in Layout View

Topics covered

  • Modify database structure
  • Manage table relationships and keys
  • Print and export data
  • Create tables
  • Manage tables
  • Manage table records
  • Create and modify fields
  • Create and run queries
  • Modify queries
  • Configure form controls
  • Format forms
  • Configure report controls
  • Format reports

What’s included

  • 1-year access to GMetrix, and 30 Practice Test attempts
  • 1 Practice Exams, 2 Skill Reviews, 2 Concept Reviews and a Study Guide 
  • Testing Mode: Timed practice tests that provide accurate feedback on strengths and weaknesses after completion
  • Training Mode: Untimed practice tests that let you work at your own pace and receive feedback and step-by-step instructions for each question  

Certify: Microsoft Access Expert – Certification Exam Voucher + Retake

Overview of Microsoft Office Specialist Certification 

Microsoft Office Specialist (MOS) certification is one of the most widely recognised and taken certifications globally. Earning a Microsoft Office Specialist (MOS) certification in Microsoft Access Expert demonstrates your ability to work efficiently with Access's advanced features and tools in professional and real-world scenarios.

Why gain Certification?

Those who take and pass MOS certifications are empowered to stand out in the competitive job market, while simplifying daily tasks, boosting productivity and fostering career growth.  

Useful Information

  • Microsoft Access Expert (Office 2019) - MO-500 Exam is 50 minutes
  • Microsoft Access Expert (Office 2019) - MO-500 Exam has 30-35 questions 

Topics the exam tests you on

Manage Databases

  • Modify database structure
  • Manage table relationships and keys
  • Print and export data

Create and Modify Tables

  • Create tables
  • Manage tables
  • Manage table records
  • Create and modify fields

Create and Modify Queries

  • Create and run queries
  • Modify queries

Modify Forms in Layout View

  • Configure form controls
  • Format forms

Modify Reports in Layout View

  • Configure report controls
  • Format reports

Additional Information

View full details