Description

The MOS 2016 Study Guide for Microsoft Access covers Microsoft Access 2016, specifically the skills required to pass the Access 2016 Microsoft Office Specialist exam.

 

The Microsoft Office Specialist Study Guides provide concise descriptions of the tasks that certification candidates must demonstrate to pass the Microsoft Office Specialist exams, step-by-step procedures for performing those tasks, practice tasks based on the MOS exam approach, sample files for practicing the tasks, and solution files so you can check your work.

Features

• Full, objective-by-objective exam coverage
• Easy-to-follow procedures and illustrations to review essential skills
• Hands-on practice tasks

New to this Edition

The addition of solution files to help students better understand the tasks.

Table of Contents

Chapter 1 Create and Manage a Database
 1.1 Create and Modify Databases
 1.2 Manage Relationships and Keys
 1.3 Navigate through a Database
 1.4 Protect and Maintain Databases
 1.5 Print and Export Data
Chapter 2 Build Tables
 2.1 Create Tables
 2.2 Manage Tables
 2.3 Manage Records in Tables
 2.4 Create and Modify Fields
Chapter 3 Create Queries
 3.1 Create a Query
 3.2 Modify a Query
 3.3 Create Calculated Fields and Grouping within Queries
Chapter 4 Create Forms
 4.1 Create a Form
 4.2 Configure Form Controls
 4.3 Format a Form
Chapter 5 Create Reports
 5.1 Create a Report
 5.2 Configure Report Controls
 5.3 Format a Report

Author

John Pierce is a freelance editor and writer. He is the author of Team Collaboration: Using Microsoft Office for More Effective Teamwork and other books about Microsoft Office, including the MOS 2013 Study Guide for Microsoft Access.