MOS Access

MICROSOFT Offcie Specialist 2010

Doncaster College is an appointed Microsoft IT Academy Programme Member

Duration

4 days (2days+2days).

Target Audience

This course is aimed at candidates who are structuring databases, creating and formatting database elements, entering and modifying data, creating and modifying queries, presenting and sharing data, and managing and maintaining the overall database.

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

Candidates should have the equivalent of six months to one year of hands-on experience with Microsoft Office Access 2010 or experience with previous versions of Microsoft Office Access.

Course Aims

The course provides delegates with the necessary skills to successfully achieve accredited certification in the chosen program.

Course Outline

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

Days 1/2

Structuring a Database

· Define data needs and types

· Define and print table relationships

· Add, set, change, or remove primary keys

· Split databases

Creating and Formatting Database Elements

· Create databases

· Create tables

· Modify tables

· Create fields and modify field properties

· Create forms

· Create reports

· Modify the design of reports and forms

Entering and Modifying Data

· Enter, edit, and delete records

· Navigate among records

· Find and replace data

· Attach documents to and detach from records

· Import data

Days 3/4

Creating and modifying queries

· Create queries

· Modify queries

Presenting and Sharing Data

· Sort data

· Filter data

· Create and modify charts

· Export data

· Save database objects as other file types

· Print database objects

Managing and Maintaining Databases

· Perform routine database operations

· Manage Databases

All instructors have undertaken the MOS programme, have several years teaching experience and have achieved MOS Instructor Certification.

For further information please contact:

Doncaster College, ICTAcademy, Doncaster Business Innovation Centre,

Ten Pound Walk, Doncaster, DN4 5QA, 01302 554958, info@ictacademy.co.uk www.ictacademy.co.uk

For further information visit http://www.microsoft.com/learning/mcp/msbc/mcas/default.mspx