StudyITonline logoStudy Image
Products/Courses List

MS Office 2002/XP - Access

The Microsoft Office Specialist Certification, (MOS) recognizes clerical and office professionals who have demonstrated proficiency or expertise in Microsoft Office XP. Study IT Online's Access 2002 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 2002 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.

Our training supplier is a Microsoft IT Academy Program Member and they follow the approved Microsoft course curriculum, ensuring that you receive the training and knowledge needed to succeed. They are so certain that this course meets and exceeds the exam objectives, that they guarantee you will pass your exam!


 Course Duration: 3 Months
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
Credit cards we accept

Free Catalogue Download

Please fill in your details below and click the submit link.

Email Address: A value is required.Invalid format.
 

Free Career Path Download

Please fill in your details below and click the submit link.

Email Address: A value is required.Invalid format.