The instructor shows how to solve the practice challenge.
(upbeat music) … - [Instructor] Welcome to the solution video … for the Chapter 2 Challenge. … For this challenge, we use the 02_05 challenge database … and I challenged you to complete … all the tasks in under seven minutes. … Let's get started. … First we'll save the database as … my challenge in the Chapter 2 folder. … We'll go to File and Save As, … you'll get this message that you need to close … all your objects before you can save it, … and we'll say yes, Chapter 2 folder. … You can call this whatever you'd like. … I'm calling this My Challenge, … and we do this just so you won't overwrite your original … 02_05 Challenge file, just in case you want to try this again. … Let's enable the content and move on to task number two. … Create a One-to-Many relationship between the … Sales Team table and the Commission table. … We're going to enforce referential integrity … so that if a record on the primary key side of … the relationship is deleted Access will automatically … delete all records that reference the primary key. …
- 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.