Access 2000 Introduction training course - learn Access

Overview of Access 2000

Introduction to database concepts and terminology
An introduction to Access 2000
Database planning and design

Creating tables

Examining a table
Creating a table with the Table Wizard
Creating a table in Design View
Types of primary keys

Working with tables

Modifying a table using Design view
Finding and editing records
Filtering and sorting records

Creating and using select queries

Creating a Select query to view specific fields
Specifying criteria in a query to view specific records
Using queries to perform calculations
Joining tables in a query

Creating and using forms

Creating a form with the Form Wizard
Modifying the form design
Using a form to locate and organise information
Multiple-table forms

Creating and using reports

Creating a report with the Report Wizard
Creating a report that contains totals

Database maintenance

Creating a database
Managing a database and its objects
Database maintenance

Overview

Students will learn the basic skills necessary to begin using Access 2000. They will design and create databases, tables, queries, forms, and reports.

Prerequisites

Windows Introduction or equivalent knowledge.

Benefits

Students learn how to create and use database objects, including tables, queries, forms, and reports.

Target student

Students should already understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with terms such as computer memory, data files, and program files. No prior knowledge of databases or Access is assumed.

What's next

Access 2000 Introduction is the first course in this series. Access 2000 Intermediate, the next course in this series, teaches students how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Students who want to learn advanced features can take the third course in this series, Access 2000 Advanced. In that course, students learn to create advanced queries, create more efficient forms and reports, and work with macros. The final course in this series, Access 2000 VBA Programming, teaches students to create custom applications.

Private Training Courses

We offer private training courses which may be delivered at our training centre or at your premises on dates to suit you and your delegates. Course content can follow the standard course material as listed in the course outline, or can be tailored to your specific requirements at no extra cost.

For a single company private course we normally recommend that any class does not exceed 8 delegates in order to ensure that the learning objectives are met.

Total price per day (ex-Vat)
Number of delegates	1	2	3	4	5	6	Extra Person
At our Reading Training Centre	£495	£545	£595	£645	£695	£745	£50
On your premises	£445	£495	£545	£595	£645	£695	£50

For on-site courses only:

Notebook computer hire is £40 per computer per day. Savings can be made for block bookings of 2 or more days, please ask for details.
Trainer travel and accomodation is charged at cost and we can give you a fixed price quote for this prior to booking.

Course fees are payable in advance and are listed exclusive of VAT.