This video reviews core exam objectives, observing a sample exam question.
- [Narrator] Let's talk about the exam format…and the time allotment.…The time allotted for the exam is 50 minutes.…You should be able to complete…the actual Access 2010 mos exam in 40 minutes or less.…And that'll give you 10 minutes to go back and review…all of the tasks that you've completed…and give you an opportunity to make any changes…before you submit it for grading.…There will be 20 to 25 tasks on the exams,…the Office 2010 mos exams are project based exams.…
For most of the task you'll have the opportunity…to work on a document that's already been created,…you'll be asked to show your proficiency in any…or all of the objectives that are listed…in your chapter one folder.…The Access 2010 mos exam is a pass fail exam,…to pass you must have a score of at least 700…and that's a 700 out of a possible 1000 points.…When you pass the exam you'll receive a special certificate…from Microsoft along with a welcome letter,…welcoming you to the mos community.…Frame that certificate, hang it on your wall,…or put it on your fridge, show the world…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
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.