Microsoft Access 2003 Level 1 Course
Course DescriptionMost 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.
|
£235 1 day course Scheduled Dates: 26 January 2012 13 February 2012 12 March 2012 10 April 2012 08 May 2012 11 June 2012 Location: PTR's Training Centre Wokingham, Berkshire. |
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
26 January 2012 to 26 January 2012
13 February 2012 to 13 February 2012
12 March 2012 to 12 March 2012
10 April 2012 to 10 April 2012
08 May 2012 to 08 May 2012
11 June 2012 to 11 June 2012
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