Microsoft Access 2003 Level 1 Course
Course Description
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database and the Microsoft® Office Access 2003 relational database application and its information management tools.
Course pre-requisites:
To ensure the successful completion of Microsoft Access 2003: Level 1, we recommend completion of one of the following:
- Windows 2000: Introduction
- Windows XP: Introduction
- Windows XP: Level 1
- Windows XP: Level 2
This course is rated as a Fundamentals Course, suitable for accomplished computer users.
Topics covered on the 2 day Microsoft Access 2003 Level 1 course
An Overview of Access 2003
- Relational Databases
- The Access Environment
- The Database Environment
- Examine an Access Table
Managing Data
- Examine an Access Form
- Add and Delete Records
- Sort Records
- Display Record Sets
- Update Records
- Run a Report
Establishing Table Relationships
- Identify Table Relationships
- Identify Primary and Foreign Keys in the Relationships Window
- Working with Subdatasheets
Querying the Database
- The Select Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform a Calculation on a Record Grouping
Designing Forms
- Form Design Guidelines
- Create AutoForms
- Create a Form Using the Form Wizard
- Modify the Design of a Form
Producing Reports
- Create an AutoReport
- Create a Report by Using the Wizard
- Examine a Report in Design View
- Add a Calculated Field to a Report
- Modify the Format Properties of a Control
- AutoFormat a Report
- Adjust the Width of a Report
|
(click button to view / download course outline in printer friendly format)
(may take a few seconds to load)
|
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Applications Training Course
Course Fee = £410 (excl.VAT)
Scheduled course dates
| May 2008 |
June 2008 |
July 2008 |
August 2008 |
September 2008 |
| 19-20 | 16-17 | 21-22 | 18-19 | 22-23 |
|
|
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
The Microsoft Access 2003 Level 1 course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.
View SAVE IT Scheme Details
Access 2003 Training SAVE IT Scheme
PTR Associates Limited
21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
|
