In this video, review core exam objectives and observe a sample exam question.
- [Instructor] Let's talk about how to prepare … for the MOS exam. … First, what to study. … We've inserted into your chapter one file folder … a list of objectives for the Access Expert exam. … Let's go ahead and take a look. … The numbers listed for each objective … correspond to the numbers in this video series. … So for example, starting with chapter two, … Manage Databases, you'll have a chance … to view videos where we modify database structures, … manage table relationships and keys, … enforce referential integrity, … and print and export data. … And that's just the first chapter. … Please refer back to this list of objectives frequently … to make sure you're comfortable with … and understand each objective that may be on the exam. … Next, how to study. … First of all, watch all the videos … and then complete the challenge exercises … at the end of each chapter. … We've created a challenge exercise … that reinforces all of the skills you learn … in each of the videos. … We've also allotted a specific amount of time …
- 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
1. Microsoft Office Specialist (MOS) Exam Overview
2. Managing Databases
3. Create and Modify Tables
4. Create and Modify Queries
5. Modify Forms in Layout View
6. Modify Reports in Layout View
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.