O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

MOS 2016 Study Guide for Microsoft Access

Book Description

Advance your everyday proficiency with Access 2016. And earn the credential that proves it!

Demonstrate your expertise with Microsoft Access! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Access 2016 certification, this official Study Guide delivers:
• In-depth preparation for each MOS objective
• Detailed procedures to help build the skills measured by the exam
• Hands-on tasks to practice what you’ve learned
• Practice files and sample solutions

Sharpen the skills measured by these objectives:
• Create and manage databases
• Build tables
• Create queries
• Create forms
• Create reports

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