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 modifying database structure, gain an understanding of table relationships, set primary and foreign keys, enforce referential integrity, and print and export data.
(lively electronic music) … - [Instructor] Welcome to the chapter two challenge. … For this challenge, you'll be using the 02_05 … challenge access database. … I believe you should be able to complete … all of the tasks in seven minutes or less. … If you find it's taking you more than seven minutes, … go back and rewatch the videos in chapter two … and come and try the challenge again. … …
Author
Released
9/16/2019- 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
Duration
Views
Related Courses
-
Introduction
-
1. Microsoft Office Specialist (MOS) Exam Overview
-
2. Managing Databases
-
Modify database structure5m 30s
-
Print and export data6m 20s
-
-
3. Create and Modify Tables
-
Create tables5m 5s
-
Manage tables3m 24s
-
Manage table records3m 13s
-
Manage fields5m 13s
-
-
4. Create and Modify Queries
-
Create and run a query4m 44s
-
Create a crosstab query5m 1s
-
Create an action query5m 31s
-
Modify a query7m 52s
-
✓ Solution: Create queries8m 18s
-
-
5. Modify Forms in Layout View
-
Configure form controls5m 46s
-
Modify form positioning4m 39s
-
✓ Solution: Create forms5m 44s
-
-
6. Modify Reports in Layout View
-
Format reports6m 21s
-
✓ Solution: Create reports7m 27s
-
7. Final Practice Exam
-
Conclusion
-
Next steps27s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: ✓ Challenge: Create and manage a database