0%

Book Description

Advance your everyday proficiency with Access 2019. 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 2019 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

About MOS

A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.

Table of Contents

  1. Cover Page
  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. Adapt procedure steps
    5. Ebook edition
    6. Errata, updates, & book support
    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. About the Author
  8. Microsoft Office Specialist: Exam MO-500 Microsoft Access Expert (Access and Access 2019)
    1. Prerequisites
  9. Objective group 1. Manage databases
    1. Objective 1.1: Modify database structure
    2. Objective 1.2: Manage table relationships and keys
    3. Objective 1.3: Print and export data
  10. Objective group 2. Create and modify tables
    1. Objective 2.1: Create tables
    2. Objective 2.2: Manage tables
    3. Objective 2.3: Manage table records
    4. Objective 2.4: Create and modify fields
  11. Objective group 3. Create and modify queries
    1. Objective 3.1: Create and run queries
    2. Objective 3.2: Modify queries
  12. Objective group 4. Modify forms in Layout view
    1. Objective 4.1: Configure form controls
    2. Objective 4.2: Format forms
  13. Objective group 5. Modify reports in Layout view
    1. Objective 5.1: Configure report controls
    2. Objective 5.2: Format reports
  14. Index
3.134.90.44