The instructor shows how to solve the practice challenge.
(upbeat music) … - [Instructor] Welcome to the solution video … for the chapter three challenge. … For this challenge we used the 03 06 Challenge exercise file … and I challenged you to complete all the tasks … in seven minutes or less, let's get started. … Task number one save the file as My Challenge … in the chapter three folder. … File, save as. … My Challenge, and save. … I'll enable content so we can keep on going. … Number two import the 2019 Internet Orders table … from the 03 06 Internet Orders database, … accept all defaults. … External data, new data source, from database, access. … Let's browse to the chapter three folder, … here's our database, click okay, … here's our table, click okay, and close. … Add the following description … to the 2019 Internet Orders table, … last import was two, one 2019. … Here's a tip for you, on the exam you're allowed … to copy paste in the task. … You can then right click on Internet Orders … go down to table properties, … and just paste it right in the description. …
- 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.