MOS 2016 Study Guide for Microsoft Access

Table of contents

1. Cover
2. Title Page
3. Copyright Page
4. Contents
5. Introduction
   1. Who this book is for
   2. How this book is organized
   3. Download the practice files
   4. Ebook edition
   5. Errata, updates, & book support
   6. We want to hear from you
   7. Stay in touch
6. Taking a Microsoft Office Specialist exam
   1. Microsoft Office Specialist certification
   2. Selecting a certification path
   3. Test-taking tips
   4. Certification benefits
   5. For more information
7. Exam 77-730. Access 2016: Core Database Management, Manipulation, and Query Skills
   1. Prerequisites
8. Objective group 1. Create and manage databases
   1. Objective 1.1: Create and modify databases
      1. Create databases
      2. Import database objects and data
      3. Delete database objects
   2. Objective 1.1 practice tasks
   3. Objective 1.2: Manage relationships and keys
      1. Create and modify relationships
      2. Set key fields
   4. Objective 1.2 practice tasks
   5. Objective 1.3: Navigate through a database
      1. Navigate specific records
      2. Create and modify navigation forms
      3. Set a form as the startup option
      4. Display objects in the Navigation Pane
      5. Change object views
   6. Objective 1.3 practice tasks
   7. Objective 1.4: Protect and maintain databases
      1. Compact and repair databases
      2. Back up and restore databases
      3. Split a database
      4. Encrypt database files
   8. Objective 1.4 practice tasks
   9. Objective 1.5: Print and export data
      1. Print reports and records
      2. Save a database as a template
      3. Export data
   10. Objective 1.5 practice tasks
9. Objective group 2. Build tables
   1. Objective 2.1: Create tables
      1. Create tables
      2. Create linked tables
      3. Create a table from a template by using application parts
   2. Objective 2.1 practice tasks
   3. Objective 2.2: Manage tables
      1. Hide fields in tables
      2. Add Total rows
      3. Add table descriptions
      4. Rename tables
   4. Objective 2.2 practice tasks
   5. Objective 2.3: Manage records in tables
      1. Add, update, and delete records
      2. Append records from external data
      3. Find, sort, and filter data
   6. Objective 2.3 practice tasks
   7. Objective 2.4: Create and modify fields
      1. Add and delete fields
      2. Add validation rules to fields
      3. Modify field properties
      4. Automate field values and formatting
   8. Objective 2.4 practice tasks
10. Objective group 3. Create queries
    1. Objective 3.1: Create queries
       1. Run queries
       2. Create select queries
       3. Create crosstab queries
       4. Create parameter queries
       5. Create action queries
       6. Create multiple-table queries
       7. Save queries
    2. Objective 3.1 practice tasks
    3. Objective 3.2: Modify queries
       1. Rename queries
       2. Change the fields in a query
       3. Show and hide query fields
       4. Specify the sort order for queries
       5. Format fields in a query
    4. Objective 3.2 practice tasks
    5. Objective 3.3: Create calculated fields and grouping within queries
       1. Use calculated fields
       2. Set filter criteria
       3. Group and summarize query records
       4. Group data by using operators
    6. Objective 3.3 practice tasks
11. Objective group 4. Create forms
    1. Objective 4.1: Create forms
       1. Create quick forms
       2. Create forms by using the Form Wizard
       3. Create forms from scratch
       4. Create forms from templates by using application parts
       5. Save forms
    2. Objective 4.1 practice tasks
    3. Objective 4.2: Configure form controls
       1. Move controls
       2. Add and remove controls
       3. Set control properties
       4. Modify data sources
       5. Manage labels
       6. Create subforms
    4. Objective 4.2 practice tasks
    5. Objective 4.3: Format forms
       1. Set tab order
       2. Configure print settings
       3. Sort records
       4. Apply themes to forms
       5. Control form positioning
       6. Modify the background of a form
       7. Insert form headers and footers
       8. Insert images
    6. Objective 4.3 practice tasks
12. Objective group 5. Create reports
    1. Objective 5.1: Create reports
       1. Use the Report Wizard
       2. Create reports from scratch
    2. Objective 5.1 practice tasks
    3. Objective 5.2: Configure report controls
       1. Group and sort records
       2. Modify data sources
       3. Add controls to a report
       4. Add and modify labels
    4. Objective 5.2 practice tasks
    5. Objective 5.3: Format reports
       1. Apply page setup options
       2. Add a calculated field
       3. Format report elements
       4. Add information to report headers and footers
    6. Objective 5.3 practice tasks
13. Index
14. About the author
15. Survey