Author
Jennifer McBee
Released
1/27/2017The course begins with an overview of the certification program. Jennifer then walks you through all of the certification objectives. You can gain hands-on experience using the downloadable sample documents to practice as you follow along. The course concludes with a full-length practice test that emulates the Access 2016 MOS exam. Solutions are provided to each of the included challenges.
- Define a one-to-many relationship.
- Explain the purpose of using the Compact and Repair tool often.
- Summarize the steps to add a table description to a table.
- Recall the steps taken to rearrange the fields in a table.
- Identify the action taken to quickly add all fields in a table to a new query.
- Explain the purpose of a subform.
Skill Level Intermediate
Duration
Views
- [Jen] Hi, my name is Jen McBee, and I'm here to help you prepare for the Microsoft Office Specialist Exam for Access 2016. I'm a certified MOS Master Instructor, and I've been mentoring students in Microsoft Access since 2006. We'll start with an overview of the different MOS certifications and how to prepare for the exam. Next, we'll cover each of the objectives for the MOS exam, making sure to focus on the ones you may encounter. I will give you opportunities for hands-on practice throughout the course, and we'll finish with a full-length practice exam to test your skills and your speed.
All of the challenges and objectives culminate into the full-length practice exam, which is an excellent opportunity to test your skill level. We have a lot to cover, so let's dive in.
-
Introduction
-
Welcome43s
-
-
1. Microsoft Office Specialist (MOS) Exam Overview
-
Prepare for the test1m 58s
-
2. Create and Manage a Database
-
Create and modify databases4m 42s
-
Navigate through a database1m 35s
-
Maintain databases3m 50s
-
Print and export data4m 57s
-
-
3. Build Tables
-
Manage tables4m 48s
-
Manage records in tables4m 21s
-
Modify fields3m 21s
-
Validation and masks7m 55s
-
✓ Solution: Build tables5m 13s
-
-
4. Create Queries
-
Create and run a query6m 9s
-
Create a crosstab query3m 37s
-
Create an action query3m 6s
-
Create a parameter query4m 1s
-
Modify a query4m 43s
-
✓ Solution: Create queries8m 47s
-
-
5. Create Forms
-
Create a form4m 58s
-
Configure form controls3m 33s
-
Add subforms4m 9s
-
Format a form5m 13s
-
✓ Solution: Create forms7m 25s
-
-
6. Create Reports
-
Create a report4m 6s
-
Configure report controls5m 27s
-
Format a report5m 42s
-
Add a calculated field3m 37s
-
✓ Solution: Create reports5m 50s
-
-
7. Final Practice Exam
-
Conclusion
-
Next steps28s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome