Microsoft Office Access 2016

Start your prep for the Microsoft Access 2016 exam with Microsoft Office Access 2016 course. This course focuses on the objectives covered in the Microsoft 77-730 exam and provides knowledge of creating, modifying, navigating, printing, exporting, protecting databases; creating, managing and modifying tables; creating and modifying query; creating and formatting a form or report and so on. The course teaches all the basic and advanced technologies of the MS Access 2016 and helps you prepare for the MOS 2016 certification exam.

Here's what you will get

The MOS Access 2016 certification exam provides the candidates the basic knowledge of the application's environment and fundamental database design principles. The certified candidates of this exam have the knowledge of the correct application of the basic characteristics of Access 2016, and they have the ability to create and maintain basic Access database objects, which includes data entry forms, tables, relationships, multi-level reports, and multi-table queries.

Lessons
Lessons
27+
Quizzes
121+
Flashcards
120+
Glossary of terms
120+
Test prep
Pre-assessment Questions
33+
Full Length Tests
2+
Post-Assessment Questions
33+
Exam FAQs
What is the exam registration fee? USD 165
Where do I take the exam? Certiport
What is the format of the exam? Multiple choice, Best answer, Short answer, Case study and so on.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the exam's retake policy?

Microsoft Office Specialist (MOS) exam retake policy is as follows:

  • Retake vouchers can only be used to retake the same exam that was failed.
  • All vouchers must be used prior to their expiration dates, without exception.
  • Retake vouchers must be used within 30 days of the initial failed exam.
  • As of July 1, 2014, the retake policy changed to the following:
    • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
    • If a candidate does not achieve a passing score the second time, the candidate must wait 48 hours before retaking the exam.
    • A two-day waiting period is imposed for each subsequent exam retake.
    • If a candidate achieves a passing score on an exam, the candidate may take it again.
Where can I find more information about this exam? To know more about the LO-77-730, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Editor
  • Data Analyst
  • Office Professional

Here's what you will learn

  • TOPIC A: Orientation to Microsoft Access
  • TOPIC B: Create a Simple Access Database
  • TOPIC C: Get Help and Configure Options in Microsoft Access
  • Summary
  • TOPIC A: Modify Table Data
  • TOPIC B: Sort and Filter Records
  • Summary
  • TOPIC A: Create Basic Queries
  • TOPIC B: Sort and Filter Data in a Query
  • TOPIC C: Perform Calculations in a Query
  • Summary
  • TOPIC A: Create Basic Access Forms
  • TOPIC B: Work with Data on Access Forms
  • Summary
  • TOPIC A: Create a Report
  • TOPIC B: Add Controls to a Report
  • TOPIC C: Enhance the Appearance of a Report
  • TOPIC D: Prepare a Report for Print
  • TOPIC E: Organize Report Information
  • TOPIC F: Format Reports
  • Summary
  • MASTERY BUILDER 1-1: Creating an Access Database
  • MASTERY BUILDER 2-1: Working with Tables
  • MASTERY BUILDER 3-1: Queries
  • MASTERY BUILDER 4-1: Creating Forms
  • MASTERY BUILDER 5-1: Reports
  • TOPIC A: Relational Database Design
  • TOPIC B: Create a Table
  • TOPIC C: Create Table Relationships
  • Summary
  • TOPIC A: Create Query Joins
  • TOPIC B: Relate Data Within a Table
  • TOPIC C: Work with Subdatasheets
  • Summary
  • TOPIC A: Use Field Validation
  • TOPIC B: Use Form and Record Validation
  • Summary
  • TOPIC A: Create Parameter Queries
  • TOPIC B: Summarize Data
  • TOPIC C: Create Subqueries
  • TOPIC D: Create Action Queries
  • TOPIC E: Create Unmatched and Duplicate Queries
  • Summary
  • TOPIC A: Data Normalization
  • TOPIC B: Create a Junction Table
  • TOPIC C: Improve Table Structure
  • Summary
  • TOPIC A: Include Control Formatting in a Report
  • TOPIC B: Add a Calculated Field to a Report
  • TOPIC C: Add a Subreport to an Existing Report
  • Summary
  • Mastery Builder 1-1: Table Relationships
  • Mastery Builder 2-1: Join Tables
  • Mastery Builder 3-1: Using Data Validation
  • Mastery Builder 4-1: Creating Advanced Queries
  • Mastery Builder 5-1: Normalizing Data
  • Mastery Builder 6-1: Using Advanced Reporting Techniques
  • TOPIC A: Add Controls to Forms
  • TOPIC B: Enhance Navigation and Organization of Forms
  • TOPIC C: Apply Conditional Formatting
  • Summary
  • TOPIC A: Import Data into Access
  • TOPIC B: Export Access Data
  • TOPIC C: Link Tables to External Data Sources
  • TOPIC D: Create a Mail Merge
  • Summary
  • TOPIC A: Create a Macro
  • TOPIC B: Restrict Records by Using a Condition
  • TOPIC C: Validate Data by Using a Macro
  • TOPIC D: Automate Data Entry by Using a Macro
  • Summary
  • TOPIC A: Getting Started with VBA
  • TOPIC B: Enhance Access by Using VBA
  • Summary
  • TOPIC A: Manage a Database
  • TOPIC B: Determine Object Dependency
  • TOPIC C: Document a Database
  • Summary
  • TOPIC A: Splitting a Database for Multiple-User Access
  • TOPIC B: Implement Security
  • TOPIC C: Convert an Access Database to an ACCDE File
  • TOPIC D: Package a Database with a Digital Signature
  • Summary
  • TOPIC A: Create a Database Switchboard
  • TOPIC B: Modify a Database Switchboard
  • TOPIC C: Set Start-up Options
  • Summary
  • Mastery Builder 1-1: Creating a Close Form Command Button
  • Mastery Builder 2-1: Linking to an External Data Source
  • Mastery Builder 3-1: Using Macros for Data Validation
  • Mastery Builder 4-1: Using VBA to Emphasize When Records Need to Be Saved
  • Mastery Builder 5-1: Using Advanced Database Management
  • Mastery Builder 6-1: Splitting a Database
  • Mastery Builder 7-1: Configuring a Switchboard and Start-up Options
LO-77-730 LO-77-730
LO-77-730
Microsoft Office Access 2016
ISBN : 9781616911140
Rating :
(36)