In this video, review core exam objectives. Additionally, observe and dissect a sample exam question.
- [Instructor] Let's take a look at the exam format … and the time allotment. … The time allotment for the Microsoft Office Specialist exams … is 50 minutes. … Now you should be able to complete the actual … live exam in 40 minutes or less, and that'll give you … a few minutes to go back and review all the tasks … that you completed to make sure you did them correctly. … You'll also have time to revisit the tasks … that you may have skipped. … Because Microsoft believes that using multiple projects … throughout the exam will allow you to better show … your knowledge and skills of Access 2019, … you'll be working with six or seven projects, … each having three to five tasks. … The projects that you'll work on are real world examples … of documents similar to those … you're probably working on now. … On the 2019 exams, you're tested on your knowledge … of the objectives several times throughout the exam … instead of just once. … So you'll need to have a good understanding … of program functionality in order to complete the tasks …
Author
Jennifer McBee
Released
9/16/2019- Modifying the database structure
- Managing table relationships and keys
- Exporting data
- Managing records and fields
- Creating and running queries
- Configuring form controls
- Modifying form positioning
- Grouping report fields
- Formatting reports
- Taking the practice exam
Skill Level Intermediate
Duration
Views
-
Introduction
-
1. Microsoft Office Specialist (MOS) Exam Overview
-
2. Managing Databases
-
Modify database structure5m 30s
-
Print and export data6m 20s
-
-
3. Create and Modify Tables
-
Create tables5m 5s
-
Manage tables3m 24s
-
Manage table records3m 13s
-
Manage fields5m 13s
-
-
4. Create and Modify Queries
-
Create and run a query4m 44s
-
Create a crosstab query5m 1s
-
Create an action query5m 31s
-
Modify a query7m 52s
-
✓ Solution: Create queries8m 18s
-
-
5. Modify Forms in Layout View
-
Configure form controls5m 46s
-
Modify form positioning4m 39s
-
✓ Solution: Create forms5m 44s
-
-
6. Modify Reports in Layout View
-
Format reports6m 21s
-
✓ Solution: Create reports7m 27s
-
7. Final Practice Exam
-
Conclusion
-
Next steps27s
-
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: Overview of the Access Expert—Office 365 and Office 2019—exam format