Access 2003 Level 1
Course Type
Scheduled:
| Date |
Location |
Duration |
Cost |
03 Jul 2012 (Tue)
04 Jul 2012 (Wed) | Washington | 2 | £ 295 |
12 Sep 2012 (Wed)
13 Sep 2012 (Thu) | Newcastle | 2 | £ 295 |
01 Nov 2012 (Thu)
02 Nov 2012 (Fri) | Washington | 2 | £ 295 |
13 Dec 2012 (Thu)
14 Dec 2012 (Fri) | Newcastle | 2 | £ 295 |
| All prices exclude VAT |
|
Private
:
| This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice. |
Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.
You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.
We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.
Please contact us to discuss this further on 0191 377 8377.
Course Overview
This course is aimed at those who want to start making use of Microsoft Access, to move from one level databases associated with holding data in Microsoft 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 Microsoft Windows or should have completed the Introduction to Microsoft Windows course.
- Delegates should feel at ease performing tasks such as arranging, sizing and switching between Windows.
Objectives
Other courses in this series 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.
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
Microsoft and Microsoft Access are Registered Trademarks
Microsoft Access 2003 beginners training courses in North East England, Durham, Washington, Newcastle. Learn about relational databases and multiple table databases. Access courses Darlington, Access training Darlington, microsoft Access Courses Consett, Access training Consett, Bishop Auckland courses for Access, Access training Bishop Auckland, Access training courses Birmingham
Accessibility: 
Enquire Online 
Special Offers 
| Join us on Facebook or
| 
FAQs
