IT Training - Microsoft Office Specialist - Access 2000 (Core)
2 Day Course

Course Objectives

Microsoft Office Specialist is a world-wide recognised accreditation. This two-day course gives participants the knowledge to achieve proficiency in the use of databases.
· It is necessary that prior to enrolment on this course, participants have either attended the 1 day Introduction to Access 2000 course or similar, for example ECDL Module 6 (Databases)
· Participants need to understand the Windows interface, and how to manage files and folders.

Course Content

- Review of files & folders
- Planning and Designing a Database
- Working with Access
- Building and Modifying Tables
- Building and Modifying Forms
- Viewing and organising information
- Defining relationships
- Producing Reports
- Integrating with other Applications
- Using Access Tools

Learning Outcomes

After attending this course participants will be able to:-

- Understand the planning and designing of a database
- Understand flat-field and Relational databases
- Create databases tables and establish relationships
- Create databases and database objects using the built-in Office features
- Create modify and format forms
- Create modify and format reports
- View, sort and extract data in table and forms
- Construct queries to extract data
- Save databases to the Web
- Print databases
- Backup and repair databases

Accreditation
Participants who wish to undertake the Access 2000 (Core) examination need to attend a further one-day examination preparation course, unless they already have sufficient knowledge & experience in working with databases. This allows participants to put into practice the knowledge gained on the course and raise and practice any areas of difficulty.
A practice test will be taken during the preparation day and the result is known immediately after completion.
The examination may be taken on the day of the exam preparation or on a later pre-arranged date

- >> Back to main IT training page