Join Jennifer McBee for an in-depth discussion in this video Using the challenges, part of Access 2010: Prepare for the Microsoft Office Specialist Certification Exam (77-885).
- [Narrator] This course includes two kinds of learning supports to help you deepen your comprehension. Knowledge checks are brief questions that ask you to reflect and then write a response using the integrated note taking tool. You'll then compare your response to the author's answer, and make revisions to your work if you want. Challenges are hands on practice activities where you can really hone your skills. During a challenge I'll lay out some objectives which you should complete on your own. Let's go ahead and look at one of the challenge files. I'll go to file and open, and I'm in my chapter three folder, here's the challenge document.
Every challenge document will begin the same. It will always act you to name the file with the word my in front of it, just so you don't overwrite the original file. You'll notice that you have check boxes so that you can mark each task done to keep track of where you are in the list. As you go down through each of the tasks and complete them, you will come to the very bottom which is the last task, and it will always be to save and close the database. If, by chance, you accidentally close your instructions form or it closes on its own, go ahead and close it, you can always open it right here in the navigation pane, just double click on the instructions form and it'll come right back.
Each challenge is followed by a solution video where I'll show you how I solved the objectives step by step. Each challenge will have a time allotment from five to eight minutes, and this is to get to used to working on a timed exam, which will really get you ready for the live MOS exam. Each one will be five to eight minutes and if you have trouble completing them within that allotted time, go back and view the videos again, and come back and try the challenge. You can spot learning supports by looking for the check mark symbols in the table of contents.
- 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.