SimNet TestPrep Course – Microsoft Office Access 2007
Master the skills necessary to be proficient in Access 2007 and pass Microsoft Certification Exam 77-605
to become a Microsoft Certified Application Specialist.
No previous experience required.
System requirements: High-speed Internet, Adobe Flash Player 9 or higher, either IE 6.0 or higher or Firefox 2.0 or higher.
Microsoft Office is not needed.
This lesson plan has been designed to thoroughly teach Microsoft Access 2007 from top to bottom, for all skill levels.
The lesson plan should take approximately 9 hours, and can be taken at your own pace. LEAP in today.
| LESSON # |
LESSON TITLE |
# TASKS |
| 01 |
Introduction to Access 2007 |
11 |
| 02 |
Creating and Modifying Tables |
13 |
| 03 |
Creating and Modifying Forms
|
8 |
| 04 |
Creating and Modifying Queries
|
11 |
| 05 |
Working with Reports
|
5 |
| 06 |
Organizing Information
|
5 |
| 07 |
Importing and exporting Data
|
2 |
The pre-tests directly correlate to the lesson plan and can be taken at anytime throughout your course.
The TestPrep pre-test covers a random subset of all skills taught in the entire lesson plan.
The TestPrep pre-test should be taken and passed multiple times before attempting the Microsoft Certification Exam.
LEAP in today.
| EXAM # |
EXAM TITLE |
# QUESTIONS |
| 01 |
Introduction to Access 2007
|
11 |
| 02 |
Creating and Modifying Tables
|
13 |
| 03 |
Creating and Modifying Forms
|
8 |
| 04 |
Creating and Modifying Queries
|
11 |
| 05 |
Working with Reports
|
5 |
| 06 |
Organizing Information
|
5 |
| 07 |
Importing and Exporting Data
|
2 |
| TestPrep |
Access 2007 TestPrep
|
49 |
Listed below are the Microsoft Certification Exam objectives and where they can be found in the SimNet TestPrep lessons and exams.
LEAP in today.
| OBJECTIVE |
SKILL NAME |
LESSON |
PRE-TEST |
| 1 |
Structuring a Database |
| 1.1 |
Define data needs and types |
02 |
02, TestPrep |
| 1.2 |
Define and print table relationships
|
01 |
01, TestPrep |
| 1.3 |
Add, set, change or remove
primary keys |
02 |
02, TestPrep |
| 1.4 |
Split databases
|
n/a |
|
| 2 |
Creating and Formatting Database Elements |
| 2.1 |
Create databases
|
01 |
01, TestPrep |
| 2.2 |
Create tables |
02 |
02, TestPrep |
| 2.3 |
Modify tables
|
02 |
02, TestPrep |
| 2.4 |
Create fields and modify field properties |
01, 02 |
01, 02, TestPrep |
| 2.5 |
Create forms
|
03 |
03, TestPrep |
| 2.6 |
Create reports |
05 |
05, TestPrep |
| 2.7 |
Modify the design of reports and forms
|
03, 05 |
03, 05, TestPrep |
| 3 |
Entering and Modifying Data |
| 3.1 |
Enter, edit, and delete records
|
n/a |
|
| 3.2 |
Navigate among records |
n/a |
|
| 3.3 |
Find and replace data
|
n/a |
|
| 3.4 |
Attach documents to and detach from records |
01 |
01, TestPrep |
| 3.5 |
Import data
|
07 |
07, TestPrep |
| 4 |
Creating and modifying queries |
| 4.1 |
Create queries
|
04, 06 |
04, 06, TestPrep |
4.2 |
Modify queries |
04 |
04, TestPrep |
| 5 |
Presenting and Sharing Data
|
| 5.1 |
Sort data |
06 |
06, TestPrep |
| 5.2 |
Filter data
|
06 |
06, TestPrep |
| 5.3 |
Create and modify charts |
n/a |
|
| 5.4 |
Export data
|
07 |
07, TestPrep |
| 5.5 |
Save database objects as other
file types |
n/a |
|
| 5.6 |
Print database objects
|
n/a |
|
| 6 |
Managing and Maintaining Databases |
| 6.1 |
Perform routine database operations
|
01 |
01, TestPrep |
| 6.2 |
Manage Databases |
06 |
06, TestPrep |
Business Certification Courseware
SimNet TestPrep for Microsoft Office 2007 is an e-learning system (no download or installation required!) designed to prepare candidates for Microsoft Business Certification exams. TestPrep provides three years of access to comprehensive, self-paced courses in each of the Microsoft Office 2007 applications and Windows Vista. All TestPrep courses include multiple lessons, practice exams, and a TestPrep exam covering all topics.
|