Microsoft Access 2000: Introduction for Beginners (2 day)

Course Overview

Microsoft Access provides powerful yet easy to use database tools facilitating the sharing of information and building of faster solutions. Access 2000 provides a number of enhancements to optimise the productivity of end users, power users and developers.

A business requires its people to be capable of driving the design and improvement of their databases. Our Fundamentals course is designed to fulfil this need.

By the end of this course you will be able to create 1:1 and 1:many relational databases. You will be able to construct tables, implement forms, design and use simple and complex queries, and produce reports based on your data.

Audience

The course is aimed at those who will be designing, supporting and creating databases. Delegates will learn how to use the more advanced and powerful features of Access 2000 in order to be more efficient in data management including complex forms, reports with charts and action queries for bulk data processing.

Skills Gained

This course will enable delegates to:

• Design a relational database.
• Create tables and relationships.
• Create complex forms.
• Produce advanced reports.

Prerequisites

This course requires that you have a good working knowledge of Microsoft Windows and should also be able to use a mouse and keyboard.

Course Outline

• Database concepts
• Access basics
• Creating databases
• Working with fields and records
• Querying tables
• Creating and using forms
• Creating and using reports
• Importing and exporting objects
• Creating Relational Databases
• Working with Related Tables
• Defining Data Entry Rules

Follow On Courses

• Microsoft Access 2000 Specialised

Microsoft Access 2000: Introduction for Beginners (2 day) / MAC2K-12