Access 2003 Level 1
| Date |
Location |
Duration |
Cost |
20 Sep 2010 (Mon)
21 Sep 2010 (Tue) | Newcastle | 2 | £ 295 |
04 Oct 2010 (Mon)
05 Oct 2010 (Tue) | Washington | 2 | £ 295 |
03 Nov 2010 (Wed)
04 Nov 2010 (Thu) | Washington | 2 | £ 295 |
15 Dec 2010 (Wed)
16 Dec 2010 (Thu) | Newcastle | 2 | £ 295 |
17 Feb 2011 (Thu)
18 Feb 2011 (Fri) | Washington | 2 | £ 295 |
17 Mar 2011 (Thu)
18 Mar 2011 (Fri) | Washington | 2 | £ 295 |
05 May 2011 (Thu)
06 May 2011 (Fri) | Newcastle | 2 | £ 295 |
06 Jun 2011 (Mon)
07 Jun 2011 (Tue) | Washington | 2 | £ 295 |
Please contact us to discuss private course dates and locations |
Course Overview
This course is aimed at those who want to start making use of Access, to move from one level databases associated with holding data in Excel into the realms of multiple table relational databases. The course will cover all the basics of multiple table databases including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.
Prerequisites
- Delegates should have some working knowledge of Windows or should have completed the Introduction to Windows course.
- Delegates should feel at ease performing tasks such as arranging, sizing and switching between Windows.
- Previous use of a mouse is assumed on this course.
Objectives
Follow on Courses
Training Options
- Scheduled public courses at one of our training venues
- Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
- Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- For further information please contact us on 0191 377 8377
What's Included
- 1 delegate per computer
- Telephone and email support
- Relaxed refreshment area at our training venues
- Lunch and refreshments when training is delivered at our training venue
- Comprehensive course manual and exercises
Course Content
Database theory
Explanation of the components that make up a database e.g. Tables, records, fields
What is a relational database?
Creating a database using the Database Wizards
Tables
How to create a single table database.
Using data types, field properties, input masks using the wizard, validation rules, captions, default values, fields required, field size, zero length.
Primary keys.
How to create a multi-table database, (Relational database)
Creating links between tables.
Working with referential integrity. Prevent data in one table being deleted when it has links to data in another table.
Viewing and editing related data in a sub datasheet.
Queries
Theory on using Queries in a database.
How to extract information from your database using queries.
Creating a query from single and multiple tables
How to sort the results of a query.
How to hide fields in a query.
How to produce totals using a query.
How to produce calculations using queries.
Forms
Theory on using Forms in a database
How to view/change data in your database using forms.
How to create a form using the wizard.
How to modify a form, change the colours, move controls (change the layout).
How to create a form that refers to two or more tables.
Reports
How to extract information and present it in a readable format
Creating reports from your database using the report Wizard
Database normalisation
Designing tables in an efficient form to minimise data replication and ensure good database design. This section is not always covered due to time limitations. It is included as An introduction to the intermediate course. This section will be covered if time permits.
Print