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.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

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.

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
15

  • Appendix:

  • 3D Avatar-based Simulation

Audience

This course is for those looking to improve their Access skills.

Language

English

Prerequisites

While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training.

Length: 365.0 days ( hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...