Access 2016 Training & Certification Course

Overview

Successful candidates for the Access 2016 exam have a fundamental understanding of the application’s environment. They understand basic database design principles and are able to complete tasks independently. They know and demonstrate the correct application of the principle features of Access 2016, and they demonstrate the ability to create and maintain basic Access database objects, including tables, relationships, data entry forms, multi-level reports, and multi-table queries.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The MOS 2016 exam format incorporates multiple projects.

 

Prerequisite

While there is no formal prerequisite for this training, however candidates with basic computer knowledge can undergo this training.

Full Description

Module 1: Getting Started with Access

  •  Orientation to Microsoft Access
  •  Create a Simple Access Database
  • Get Help in Microsoft Access

 

Module 2: Working with Table Data

  •  Modify Table Data
  •  Sort and Filter Records
  •  Create Lookups

 

Module 3: Querying a Database

  •  Join Data from Different Tables in a Query
  •  Sort and Filter Data in a Query
  •  Perform Calculations in a Query

 

Module 4: Designing Forms

  • Create a Form
  •  Modify the Design of a Form
  •  View and Edit Data Using an Access Form

 

Module 5: Generating Reports

  •  Create a Report
  •  Add Controls to a Report
  •  Enhance the Appearance of a Report
  •  Prepare a Report for Print

 

Module 6: Designing a Relational Database

  •  Relational Database Design
  •  Create a Table
  • Create Table Relationships

 

Module 7: Creating Advanced Queries

  •  Create Parameter Queries
  •  Create Action Queries
  •  Create Unmatched and Duplicate Queries
  •  Summarize Data

 

Module 8: Organizing a Database for Efficiency

  •  Data Normalization
  •  Create a Junction Table
  •  Improve Table Structure

 

Module 9: Joining Tables

  •  Create Query Joins
  • Join Tables That Have No Common Fields
  •  Relate Data within a Table
  •  Work with Subdatasheets
  •  Create Subqueries

 

Module 10: Advanced Reporting

  •  Organize Report Information
  •  Format Reports
  • Include Control Formatting in a Report
  •  Add a Calculated Field to a Report
  •  Add a Subreport to an Existing Report

 

Module 11: Implementing Advanced Form Design

  •  Add Controls to Forms
  •  Create Subforms
  •  Organize Information with Tab Pages
  • Enhance Navigation of Forms
  •  Apply Conditional Formatting

 

Module 12: Using Data Validation

  •  Field and Record Validation
  •  Form Validation

Fees & Schedule

Delivery Mode Course Duration Fees
Live Virtual Training 2 Days Ask for Quote
Onsite Classroom Training 2 Days Ask for Quote
Customized Training 2 Days Ask for Quote

FAQ's

SpireTec solutions is the latest technology enabled I.Tmanagement training company specialized in offering 1500+ courses with the state of art training facilities backed by a team of industry experts in various domains with assuring best quality services.
Since SpireTec provides 24X7 training and support for your training needs is very adaptable to your time availabilities and offers customized training programs according to your availability and time zones of your contingent.
Because SpireTec aims for the personal & professional growth of you as individual & corporate as a whole, providing training on the latest and updated versions in the designated domains.
It is preferable but not mandatory to have domain experience in the area of your interest in which you want to opt training, supported by good English communication skills, a good Wi-Fi and computer or laptop system in case you want remote training
Spire Tec aims and ensure to offer finest and world-class training to the participants by giving them a proper counselling and a guided career path by our industry experts which leads guaranteed success for you in the corporate world
We offer online training (1-1, Group training), Classroom training, Onsite training with state of art facilities.
You can make payment online via PayPal with any of the debit & credit cards or via direct bank transfer.