Part time MOS - Access

MOS Access 2003
MICROSOFT OFFICE SPECIALIST 2003

Type of learning:
Instructor lead at DBIC

Duration:
2 day intensive

Times/dates:

Cost:

Target Audience
This course is aimed at employees whose responsibilities include the use of Microsoft Office Access to organize, structure, and manage data in organisations of every size.

Benefits to the Employer
Certification in the most commonly used desktop applications increases employee productivity, decreases the time needed to complete tasks and can also decrease demand on valuable IT support resources. Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business.

Pre-Course Requirements
Delegates should be familiar with the basics of Access 2003.

Course Aims
The course provides delegates with the necessary skills to successfully achieve accredited certification in Access 2003.

Course Outline
Academy instructors have undertaken the MOS programme, have several years teaching experience and have achieved MOS Master Instructor Certification.

To become a Microsoft Office Specialist (MOS) in Microsoft Access 2003 an individual has to demonstrate proficient use of the application during a performance-based on-line exam. The topics covered are as follows:

Structuring Databases

· Create Access databases

· Create and modify tables

· Define and modify field types

· Modify field properties

· Create and modify one-to-many relationships

· Enforce referential integrity

· Create and modify queries

· Create forms

· Add and modify form controls and properties

· Create reports

· Add and modify report control properties

· Create a data access page

Entering Data

· Enter, edit and delete records

· Find and move among records

· Import data to Access

Organising Data

· Create and modify calculated fields and aggregate functions

· Modify form layout

· Modify report layout and page setup

· Format datasheets

· Sort records

· Filter records

Managing Databases

· Identify object dependencies

· View objects and object data in other views

· Print database objects and data

· Export data from Access

· Back up a database

· Compact and repair databases