I'm a student
I'm an educator
Request full copy

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

Published by Microsoft Press (May 14, 2020) © 2020

  • Paul McFedries

eTextbook

$23.99

  • Available for purchase from all major ebook resellers, including InformIT.com.
  • To request a review copy, click on the "Request a Review Copy" button.
$19.99

  • A print text (hardcover or paperback) 
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com
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
  • Full, objective-by-objective exam coverage
  • Easy-to-follow procedures and illustrations to review essential skills
  • Hands-on practice tasks with corresponding solutions files 
The MOS 2019 Study Guide for Microsoft Access now features solutions for every practice task -- so readers can easily check their work and improve exam readiness. 
  • 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

Paul McFedries is a Microsoft Access and database expert and full-time technical writer. Paul has been authoring computer books since 1991 and has nearly 100 books to his credit, which combined have sold more than 4 million copies worldwide. His titles include the Microsoft Press Publishing book Formulas and Functions for Microsoft Excel 2019, the Que Publishing books My Office 2016, My Office for iPad, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups, aswell as the Wiley Publishing books Teach Yourself VISUALLY Microsoft Access and Teach Yourself VISUALLY Excel Data Analysis. Please drop by Paul’s personal website at www.mcfedries.com or follow Paul on Twitter at twitter.com/paulmcf.

Need help? Get in touch

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 16KB) 

Pearson eTextbook: What’s on the inside just might surprise you

They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle. 

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars