Certifications

Microsoft
CompTIA
Cisco
CIW
LPI
Red Hat
IBM

Site Tools

Free Magazines
White Papers
Top Sites
Contributors
Site Map
FAQ

Practice Tests

Forum Stats

Users online
total users: 276

Last Post
Passed 70-294
by AdamV
Sep. 02, 2010 10:39

Board statistics
We have a total of 88587 posts!

Microsoft Office Specialist: Access 2002

Study Resources:
Practice Exam - Our free online practice exam
Forum - Get answers and help others
Find Training - CBT, testing software, online training, etc.

Links:
Official Exam Site
Microsoft Access Tutorials
Money Saving Tips
Intro to Microsoft Certifications

About This Exam:
This Microsoft Office Specialist exam is performance-based, requiring you to perform a series of tasks using Microsoft Access version 2002. Many of the questions in this Microsoft Office Specialist exam require you to complete a series of tasks to create or modify a typical business document.

This exam uses the actual Microsoft Access version 2002 program. All menu items, keyboard shortcuts and right-click options will be available to complete the tasks. The help menu, including use of the Office Assistant, is not available in any of the exams.

There is one to three points are possible per question, depending on the number of specified tasks. At the conclusion of an exam your final score is derived by converting the task score to a 1000-point scale. While some questions involve more tasks than others, each question is scored on a total-score basis (i.e.; number correct) rather than on a pass/fail basis. For example, a 20-question exam may have 34 possible points; one point for each task.

Cost: $75
Format: Performance-based
Passing Score: Unknown
Questions: 17020
Tasks: 38-45
Time Limit: 45-50
Launch Date: 9/16/02

Certification: MOS

Exam Vouchers:
Discount Vouchers

Exam Registration:
Certiport

Exam Objectives:

Creating and Using Databases

Create Access databases

Open database objects in multiple views

Move among records

Format datasheets

Creating and Modifying Tables

Create and modify tables

Add a predefined input mask to a field

Create Lookup fields

Modify field properties

Creating and Modifying Queries

Create and modify Select queries

Add calculated fields to Select queries

Creating and Modifying Forms

Create and display forms

Modify form properties

Viewing and Organizing Information

Enter, edit, and delete records

Create queries

Sort records

Filter records

Defining Relationships

Create one-to-many relationships

Enforce referential integrity

Producing Reports

Create and format reports

Add calculated controls to reports

Preview and print reports

Integrating with Other Applications

Import data to Access

Export data from Access

Create a simple data access page

Sponsor

Training Picks

CareerAcademy
Expert-led On-Demand Certification training courses with 7x24 LIVE Mentoring. Topics cover MCSE 2008 Training, A+ Certification, IT Security CEH Training, Cisco Training and many more.

Training Videos
We offer streaming or CD certification training videos for Microsoft, CompTIA, Cisco, Citrix, Oracle, CISSP, CET, CWNA, LPI, SCJP, CIW, MOS, PMP and other certifications. View our free videos!

EDULEARN
Certification Training on CD-ROMs & Videos: Microsoft MCSE Training, A+ Certification, Windows 2003, & Free demos. MCSE certification training includes videos and labs.

Online Computer Training by K Alliance. Certification training videos for MCTS, MCITP, Oracle OCA/OCP, A+, CCNA, RHCE and more. Our e-learning courses come with 24/7 online mentoring.

More Training

IT Showcase