Microsoft Office Specialist Exam Skill Standards: Access 2000
The Microsoft Office Specialist Certification, (MOS) recognizes clerical and office professionals who have demonstrated proficiency or expertise in Microsoft Office 2000. SmartCert's Access 2000 course provides students with the knowledge and skills that are needed to
use the advanced software features, and integrate the Office programs with other software. When you pass the
Access 2000 exam, you achieve Microsoft Office Specialist (MOS) status. You also earn elective credit towards the MOS Master Certification, which requires three exams and one elective.
As a Microsoft Certified Partner, SmartCert follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed. SmartCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!
Learning segments
Creating and Using Databases
Create Microsoft 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 |
|
