Introduction
Welcome
()
What you should know before watching this course
()
Using the exercise files
()
Using the challenges
()
1. Microsoft Office Specialist Exam Overview
Compare the Microsoft Office Specialist certifications
()
Prepare for the exam
()
Review the exam objectives and format
()
2. Managing the Access Environment
Create a new database
()
Manage a database
()
Configure the Navigation pane and access options
()
Apply application parts
()
Backup a database
()
Challenge: Create databases
()
Solution: Create databases
()
3. Building Tables
Create a new table
()
Create and modify fields
()
Sort and filter records
()
Primary key
()
Set table relationships
()
Manage records
()
Import data
()
Challenge: Build tables
()
Solution: Build tables
()
4. Create Forms
Create basic forms
()
Create navigation forms and split forms
()
Set form controls
()
Apply headers, footers, themes, and add images
()
Arrange objects on forms
()
Apply backgrounds, alternate row color, and control formatting groups
()
Format form controls
()
Challenge: Create forms
()
Solution: Create forms
()
5. Create and Manage Queries
Work with simple select queries
()
Create multi-table queries
()
Create crosstab queries
()
Append query
()
Create Make Table queries
()
Use Total and Group By
()
Use calculated fields in a query
()
Challenge: Create queries
()
Solution: Create queries
()
6. Create Reports
Create a report
()
Apply Report Design tab options
()
Control report margins and padding
()
Apply Format tab options
()
Apply Report Page Setup tab options
()
Sort and filter records for reporting
()
Challenge: Design Reports
()
Solution: Design Reports
()
7. Final Practice Exam
Challenge: Full-length practice exam
()
Solution: Full-length practice exam
()
Ex_Files_Access2010_MOS_Cert.zip
(75.3 MB)