The instructor shows how to solve the practice challenge.
(upbeat music) … - [Instructor] Welcome to the solution video … for the chapter four challenge. … For this challenge we used the 04 06 challenge exercise file … and I challenged you to complete all the tasks … in eight minutes or less, let's jump right in. … First we'll save the database as my challenge … in the chapter four folder, … file, save as, navigate to the desktop … where my files are saved, change the name, and save. … We'll enable that content and move on to task number two. … Query the 2018 Orders table to display customer, … order ID, order amount and order date, … accept all defaults and run the query. … Let's go to create query design, … double click on the 2018 Orders table … to add it to the query grid. … We are bringing in customer, order ID, … order amount, order date. … We're going to run the query, and we will save the information … change the order amount field format field … to currency with two decimal places. … Let's go into design view, click in order amount …
- 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.