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 1 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
Course Classification:
Applications Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
| March 2010 | April 2010 | May 2010 | June 2010 | July 2010 |
| 15 | 12 | 10 | 14 | - |
View full schedule of Microsoft Access courses
View full schedule of Microsoft Access 2003 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Access Training and bespoke Microsoft Access courses
The Microsoft Access 2003 Level 1 course qualifies for the PTR Training Passport SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.