access 2002 XP, 2003 and 2007
basic introduction training course

Our Basic Introduction Microsoft Access course is for anyone who is new to databases creation or who is self-taught and wants to fill in gaps in their basic skills.

Training on database creation is essential if you have never attempted to make one before.

course duration

Two days on-site.

course prerequisites

Competence in the use of the mouse, keyboard and windows, toolbars and menus. Awareness of basic computer principles like files, folders and filing.

Some thought given to why you might want to use a database in the first place.

course content

Why use a database Why a database and not some other program, like a spreadsheet.

Terminology Understanding database terminology and jargon.

Planning How to plan for a successful database.

Database objects Components of a relational database.

Access database Examining how Access works as a relational database management system.

New database How to start a new database in Access.

Tables Understanding tables, fields and records; working with more than one table.

Table creation How to create an Access data table.

Fields Data types; properties; primary keys; indexing; validation.

Relationships Types of relationships; linking tables.

Queries Their part in a database.

Query design Creating single- and multi-table queries.

Sorting Using queries to sort data.

Filtering by query Using queries to list records that match your criteria; use of wildcards.

Forms Their part in a database.

Form design Creating a form using a Wizard; modifying the appearance and behaviour of a form.

Filtering by form Using forms to isolate records that match your criteria.

Reports Their part in a database.

Report design Creating a report using a Wizard; modifying the appearance of a report.

Conclusion Reflection on what you have learnt and how you might apply Access to your database.

london, kent, surrey and sussex

We regularly travel to clients in London and the South East. Based near Tonbridge, we are particularly well placed to visit clients throughout Kent, East and West Sussex, Surrey and London.

As we have done in Ashford, Aylesford, Brighton, Canterbury, Chatham, Chiddingstone, East Grinstead, Edenbridge, Heathfield, Lightwater, London, Maidstone, Maresfield, Orpington, Paddock Wood, Richmond, Rochester, Sevenoaks, Sittingbourne, Tadworth, Ticehurst, Tonbridge, Tunbridge Wells and Westerham.