access 2002 (XP), 2003 and 2007
advanced training course

Our Advanced Microsoft Access course is for anyone wishing to further their ambition to set up a fully functional database, possibly for use by many people on a network.

It should also suit anyone who has inherited a database from someone else and needs to understand some of the techniques used by those in the know.

course duration

This course takes one day on-site, normally between 9:30am and 4:30pm.

course prerequisites

Completion of our Intermediate course or practical experience of applying the skills covered in that course to the creation of your own database.

course content

Referential integrity Relationship design; cascading updates; cascading deleletes.

Multi-user Setting up a database for multiple users; 'front' and 'back' ends.

Strategies For maintaining and updating databases.

Select queries Advanced techniques; managing query joins.

Functions Special functions for use in query expressions.

Sub-queries SQL technique for extending query design.

Nested queries Mining for data by basing one query upon another.

Action queries Further techiques for exploiting action queries.

Cross-tab queries Creating cross-tablulations for data analysis.

Union queries Combining sets of data using a single query.

Queries behind forms Using forms to initiate, filter and modify queries.

Query optimisation Techniques for improving performance of queries; application of indexes.

From design Advanced techniques for designing forms.

Report design Advanced techniques for designing reports.

Macros Creating and editing macros.

Menus Creating custom menus.

Toolbars Creating custom toolbars.

Maintenance Compacting and repairing databases.

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.