Microsoft Access 2016 (77-730)

(77-730) / ISBN : 978-1-64459-154-3
This course includes
Lessons
TestPrep
Hands-On Labs
AI Tutor (Add-on)
56 Reviews
Get A Free Trial

About This Course

Get certified for the MOS 77-730 exam with the Microsoft Access 2016 course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The Microsoft Access training course and lab cover the 77-730 exam objectives and impart the skills required for creating and managing a database, building tables, creating queries, creating forms, and creating reports.

Skills You’ll Get

The Microsoft Access 2016 77-730 exam validates a candidate's knowledge of the Access 2016 application's environment and fundamental database design principles. The certified candidates of this exam know the correct application of the basic characteristics of Access 2016 and they can create and maintain basic Access database objects, including data entry forms, tables, relationships, multi-level reports, and multi-table queries.

Interactive Lessons

15+ Interactive Lessons | 142+ Quizzes | 82+ Flashcards | 82+ Glossary of terms

Gamified TestPrep

17+ Pre Assessment Questions | 17+ Post Assessment Questions |

Hands-On Labs

36+ LiveLab | 40+ Video tutorials | 02:20+ Hours

Video Lessons

124+ Videos | 07:14+ Hours

1

Introduction to Access 2016

  • Getting Started
  • Working in the Access Interface
  • Summary
2

Creating Database Tables

  • Introducing Tables
  • Creating a Table
  • Saving and Modifying a Table
  • Summary
3

Working with Tables and Database Records

  • Navigating Specific Records
  • Adding, Updating, and Deleting Records
  • Working with Primary Keys
  • Finding and Replacing Data
  • Sorting and Filtering Data and Setting Field Viewing Options Within a Table
  • Understanding Table Relationships
  • Summary
4

Modifying Tables and Fields

  • Creating Fields and Modifying Field Properties
  • Modifying Database Tables and Fields
  • Summary
5

Creating Forms

  • Creating a Form
  • Sorting and Filtering Data in a Form
  • Summary
6

Creating Reports

  • Creating a Report
  • Working With Reports
  • Summary
7

Creating and Modifying Queries

  • Creating a Query
  • Modifying a Query
  • Sorting and Filtering Data in a Query
  • Format Fields Within Queries
  • Summary
8

Using Controls in Forms and Reports

  • Controls
  • Defining Control Tab Order
  • Formatting Controls
  • Arranging Control Alignment, Size, and Position
  • Adjusting Page Margins and Changing Page Orientations for Forms and Reports
  • Summary
9

Understanding Advanced Forms

  • Creating Advanced Forms
  • Using Application Parts to Create Blank Forms
  • Creating and Modifying a Navigation Form
  • Summary
10

Creating Advanced Reports

  • Defining Groups
  • Creating Aggregate Fields
  • Creating a Subform on a Report
  • Creating the Print Layout
  • Using the Label Wizard
  • Summary
11

Creating Advanced Queries

  • Creating Crosstab Queries
  • Creating a Subquery
  • Filtering and Saving a Filter as a Query
  • Creating Action Queries
  • Understanding Advanced Query Modification
  • Summary
12

Displaying and Sharing Data

  • Creating a Chart Using the Chart Wizard
  • Formatting a Chart
  • Changing Chart Types
  • Saving a Database Object as Another File Type and Printing
  • Summary
13

Importing and Exporting Data

  • Importing Data
  • Exporting Data
  • Saving and Running Import/Export Specifications
  • Summary
14

Understanding Database Tools

  • Maintaining a Database
  • Using Database Tools
  • Encrypting and Decrypting a Database
  • Navigating in Access Database
  • Improving User Interface Design by Using Macros
  • Summary
D

Appendix: 3D Avatar-based Simulation

1

Introduction to Access 2016

  • Creating a Blank Database
  • Creating a Database from a Template
2

Creating Database Tables

  • Creating a New Table and Changing its Font Style and Size
  • Changing Gridlines to Vertical
3

Working with Tables and Database Records

  • Deleting a Record
  • Adding Records to a Database Table
  • Finding and Replacing a Specific Value
  • Calculating Average and Exporting a Table in Text Format
  • Hiding the Fields
  • Creating a Relationship Between Tables
4

Modifying Tables and Fields

  • Opening a Table in Design View and Editing its Field Properties
  • Renaming a Table
  • Deleting a Table from a Database
  • Changing the Title Bar Text with the Caption Property
  • Creating Multivalued Lookup Fields
5

Creating Forms

  • Creating and Viewing a Form in Form View
  • Using the Filter By Form Option
6

Creating Reports

  • Creating a New Report and Binding it to a Query
  • Sorting a Field of Reports
7

Creating and Modifying Queries

  • Using a Find Duplicates Query Wizard
  • Finding Unmatched Records
8

Using Controls in Forms and Reports

  • Changing Date/Time Controls
  • Changing the Width of a Form
  • Creating a Basic Form and Applying Themes
  • Inserting a Background Image in a Form
9

Understanding Advanced Forms

  • Creating a Split Form
10

Creating Advanced Reports

  • Creating Labels Using the Label Wizard
11

Creating Advanced Queries

  • Creating Crosstab Queries
  • Saving a Filter as a Query
  • Creating an Append Query
12

Displaying and Sharing Data

  • Printing a Database Object
13

Importing and Exporting Data

  • Importing a Table from Another Access Database
  • Exporting Objects to Other Access Databases
14

Understanding Database Tools

  • Compacting and Repairing a Database
  • Backing Up a Database
  • Splitting a Database

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

There are no technical prerequisites for the certification exam.

USD 100

The exam consists of performance based questions and is conducted in a live or simulated environment. 

The exam contains 40-60 questions.

90 minutes

The passing score varies from exam to exam and is provided on the score report.

Microsoft Office Specialist (MOS) exam retake policy

  1. 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.
  2. If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
  3. A two-day waiting period will be imposed between each subsequent exam retake.
  4. There is no annual limit on the number of attempts on the same exam.
  5. If a candidate achieves a passing score on an Office exam, the candidate may take it again.

For life

scroll to top