This final challenge emulates the length and scope of the full Access 2019 Expert exam. It includes all of the topics covered earlier in the course, which you should complete in 50 minutes or less. Successful completion of this practice exam in under 50 minutes is an indicator that you're probably ready to take the official Access 2019 Expert exam.
(lively electronic music) … - [Instructor] Welcome to the final challenge. … For this challenge, you'll be using the 07_01 … challenge exercise file. … You should be able to complete all of the tasks … in 40 minutes or less. … Remember, if you're not able to complete … all of the tasks in under 40 minutes, … go back and watch the videos for the chapters … for which you have questions and then come and try … the challenge again. … …
- 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.