Test your comprehension by completing a series of hands-on objectives and then review the instructor's solution video. Learn that time is a major factor in the Access 2019 Expert Exam, so the ability to solve objectives quickly is important. Practice creating and running a query, creating crosstab, action and parameter queries, and modifying a query by adding, hiding and removing fields, sorting data, filtering data, and formatting fields within queries.
(upbeat techno music) … - [Instructor] Welcome to the Chapter 4 Challenge. … For this challenge, you'll be using … the 04_06 challenge exercise file, … and I challenge you to complete all the tasks … in eight minutes or less. … If you find you're having difficulty … completing all the tasks within that timeframe, … go back and watch the videos again for Chapter 4, … and come and try the challenge one more 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.