The author shows how to solve the practice challenge.
(chimes)…- [Narrator] Hi.…Welcome to the Chapter 6 challenge solution video.…For this challenge we are using the 06_07 Challenge…exercise file in the Chapter 6 folder.…I challenged you to complete all of the tasks…in 10 minutes or less.…Let's go ahead and get started.…Alright, task number one, save the database…as my 06_07 Challenge in the Chapter 6 folder.…Here we go.…Save database as.…Yes.…You can close all the objects.…
Chapter six.…Type the word "my" in front of the document title name…and click Save.…Now on my computer, I have to enable the content…before it'll let me make any changes.…You may or may not have to do that,…but if this yellow bar comes up,…go ahead and Enable Content.…If not, you don't have to do a thing.…Mark number one as Done though.…Number two, create a Quick Report…based on the Customers South Query.…Okay, here it is right here.…
Save the report as Customers - South.…Keep the report open for the next task.…This is a really easy one.…We just go to Create, Quick Report.…Right click on the tab and Save.…
- 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.