Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

Microsoft Access 2016 (77-730)

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.
NameBuy
Microsoft Access 2016 (77-730)
Test Prep
17+ Pre Assessment Questions | 17+ Post Assessment Questions |
Features
36+ LiveLab | 40+ Video tutorials | 02:20+ Hours
124+ Videos | 07:14+ Hours

Why choose TOPTALENT?

Outline

Lessons 1:
Introduction to Access 2016

  • Getting Started
  • Working in the Access Interface
  • Summary

Lessons 2:
Creating Database Tables

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

Lessons 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

Lessons 4:
Modifying Tables and Fields

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

Lessons 5:
Creating Forms

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

Lessons 6:
Creating Reports

  • Creating a Report
  • Working With Reports
  • Summary

Lessons 7:
Creating and Modifying Queries

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

Lessons 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

Lessons 9:
Understanding Advanced Forms

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

Lessons 10:
Creating Advanced Reports

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

Lessons 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

Lessons 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

Lessons 13:
Importing and Exporting Data

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

Lessons 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

Appendix: 3D Avatar-based Simulation