YoVDO

Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365

Offered By: LinkedIn Learning

Tags

Microsoft Certification Courses Microsoft Access Courses Database Management Courses Data Validation Courses

Course Description

Overview

Demonstrate your mastery of Access by becoming a Microsoft Office Specialist (MOS). Get training for the Access Expert certification exams for Office 365 and Office 2019.

Syllabus

Introduction
  • Prove your Access skills with a MOS certification
  • Who should take this course?
  • About the exercise files
  • About the challenges
1. Microsoft Office Specialist (MOS) Exam Overview
  • The different kinds of Microsoft Office Specialist certifications
  • Prepare for the test and review learning objectives
  • Overview of the Access Expert—Office 365 and Office 2019—exam format
2. Managing Databases
  • Modify database structure
  • Manage table relationships and keys
  • Enforce referential integrity
  • Print and export data
  • ✓ Challenge: Create and manage a database
  • ✓ Solution: Create and manage a database
3. Create and Modify Tables
  • Create tables
  • Manage tables
  • Manage table records
  • Manage fields
  • Add validation rules and input masks
  • ✓ Challenge: Create and modify tables
  • ✓ Solution: Create and modify tables
4. Create and Modify Queries
  • Create and run a query
  • Create a crosstab query
  • Create an action query
  • Create a basic parameter query
  • Modify a query
  • ✓ Challenge: Create queries
  • ✓ Solution: Create queries
5. Modify Forms in Layout View
  • Configure form controls
  • Modify tab order on forms and sort by field
  • Modify form positioning
  • Insert information in form headers and footers
  • ✓ Challenge: Create forms
  • ✓ Solution: Create forms
6. Modify Reports in Layout View
  • Group and sort fields on reports
  • Format reports
  • Add and modify labels on reports
  • Format a report into multiple columns
  • ✓ Challenge: Create reports
  • ✓ Solution: Create reports
7. Final Practice Exam
  • ✓ Challenge: Full-length practice exam
  • ✓ Solution: Full-length practice exam
Conclusion
  • Next steps

Taught by

Jennifer McBee

Related Courses

Datenmanagement mit SQL
openHPI
Programming Cloud Services for Android Handheld Systems
Vanderbilt University via Coursera
Getting and Cleaning Data
Johns Hopkins University via Coursera
Ruby مدخل إلى برمجة مواقع الإنترنت باستخدام لغة
Rwaq (رواق)
MongoDB for .NET Developers
MongoDB University