The author shows how to solve the practice challenge.
(lively chime)…- [Instructor] Welcome to the Chapter Four Challenge…Solution Video.…For this challenge,…we used the 04_08 Challenge exercise file…and I challenged you to complete all the tasks…in eight minutes or less.…Let's go ahead and get started.…Our first task is to save…the database as my 04_08 Challenge.…File, Save As, Save Database As.…
Just going to close everything, here we go.…We'll put My in front of the document title…and get rid of that one at the end and click save.…Perfect, let's mark that one as done.…Okay, let's resume.…Let's mark task number one as done.…Next, create a new Form based on the New Products Table.…Include all fields and save the Form as New Product.…Close the Form.…So, we can just use a quick Form.…I'll click on the New Products Table.…Go to create, quick Form.…
Perfect, it's named it for us.…Let's just close it.…We'll keep the default name.…Mark number two as done.…That was easy.…Number three, create a new Form…based on the Customers Table,…and we're going to include specific fields,…so we'll go ahead and use the Form Wizard.…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
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.