This video is an introduction of the practice document, which, like the actual test, lists steps for the viewer to complete.
(swooshing)…- [Narrator] Hi, welcome to the Final Challenge…for this video series.…For your Final Challenge you'll use the 07_01 challenge…exercise file in the Chapter 7 file folder.…You should be able to complete all of the tasks…in 40 minutes or less.…If you find that you're unable to complete…all of the tasks in under 40 minutes,…go back and watch the videos for the chapters that…you're having a little difficulty with,…and then come back and try the Challenge again.…You can always watch my solution video…to see how I completed all of the tasks…in less than 40 minutes.…
There are going to be two tasks that you're going to be…asked to perform that will actually close…the Challenge instructions.…So what I've done is created a PDF copy…of the Challenge instructions so that you can have that…open while you're doing the Challenge.…You can also print the Challenge instructions form off…so you'll have that handy.…Good luck on the Challenge, and remember if you have…any challenges with the task, watch my solution video.…
- 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.