MOS Study Guide for Microsoft Access Expert Exam MO-500

by Paul McFedries

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

The full text downloaded to your computer

With eBooks you can:

• search for key concepts, words and phrases
• make highlights and notes as you study
• share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you will receive via email the code and instructions on how to access this product.

Time limit

The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.

Product Details

ISBN-13:	9780136628217
Publisher:	Pearson Education
Publication date:	04/08/2020
Series:	MOS Study Guide
Sold by:	Barnes & Noble
Format:	eBook
Pages:	192
File size:	14 MB
Note:	This product may take a few minutes to download.
Age Range:	18 Years

About the Author

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.

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