MOS Study Guide for Microsoft Access Expert Exam MO-500, 1st edition

Published by Microsoft Press (April 8, 2020) © 2020

  • Paul McFedries
£17.99
Instant access
  • Available for purchase from all major ebook resellers, including InformIT.com
Products list
£17.99
Instant access
  • Available for purchase from all major ebook resellers, including InformIT.com

Title overview

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

Table of contents

  • 1 Manage databases
  • Objective 1.1: Modify database structure
  • Objective 1.2: Manage table relationships and keys
  • Objective 1.3: Print and export data
  • 2 Create and modify tables
  • Objective 2.1: Create tables.
  • Objective 2.2: Manage tables
  • Objective 2.3: Manage table records
  • Objective 2.4: Create and modify fields
  • 3 Create and modify queries
  • Objective 3.1: Create and run queries
  • Objective 3.2: Modify queries
  • 4 Modify forms in Layout view
  • Objective 4.1: Configure form controls
  • Objective 4.2: Format forms
  • 5 Modify reports in Layout view
  • Objective 5.1: Configure report controls
  • Objective 5.2: Format reports

Need help?Get in touch