Microsoft Access 2016

BITTS logo
Department
Business, Business Adminstration, Information Technology
Semester
Continuous
Method
Online
Duration
39 Hours

Prepare for the Microsoft MOS 77-730 exam with the Microsoft Access 2016 course and lab. The lab is cloud-based, device-enabled, and can be easily integrated with an LMS. Interactive chapters comprehensively cover the Microsoft MOS 77-730 exam objectives and provide knowledge in areas such as 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 MS Access 2016 course includes full-length practice tests provided with answers that emulate the Access 2016 exam.

students at BITTS

The Microsoft Access 2016 77-730 exam validates the candidates the basic knowledge of the Access 2016 application’s environment and fundamental database design principles.

Quick Application Form

Entry requirements

  • High School Diploma or Equivalent
  • Age must be 18 years or above
  • English Proficiency

Course structure and modules

  • An Introduction to Database Development
  • Getting Started with Access
  • Creating Access Tables
  • Understanding Table Relationships
  • Working with Access Tables
  • Importing and Exporting Data
  • Linking to External Data
  • Selecting Data with Queries
  • Using Operators and Expressions in Access
  • Going Beyond Select Queries
  • Working with Calculations and Dates
  • Performing Conditional Analyses
  • Fundamentals of Using Access SQL
  • Subqueries and Domain Aggregate Functions
  • Creating Basic Access Forms
  • Working with Data on Access Forms
  • Working with Form Controls
  • Presenting Data with Access Reports
  • Advanced Access Report Techniques
  • Advanced Data Access with VBA
  • Appendix A
  • Appendix B
  • Appendix C

Career opportunities

  • Editor
  • Data Analyst
  • Office Professional