Instructor-led training - London Access training in Microsoft courses
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Microsoft Access Training Courses in London & UK wide

Microsoft Access 2002 XP Intermediate

Microsoft Access 1 day instructor-led. Courses never cancelled: Guaranteed. From £75 (list price £225)

Training formats available

Who is this training course suitable for?

Our Microsoft Access 2003 Itermediate course is suitable those with a basic working knowledge of Microsoft Access.

Prerequisites

A rudimentary knowledge of Microsoft Access is required, or completion of our Microsoft Access Introduction course.

Benefits

This course has been created for delegates needing to increase their knowledge of Access to take advantage of the more complex features. By the end of the course delegates will have created relational databases and have worked with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.

After completing this course you will be prepared to attend the Access Advanced training course.

Course Syllabus

Creating relational databases
Database normalising
Introducing relating tables
Adding referential integrity

Working with related tables
The lookup wizard
Changing lookup fields
Inputting data to related tables

Defining data entry rules
Using input masks
Setting a property
Setting a validation rule

Using advanced query features
How to join a table in queries
Creating a calculated field
Using an action query

Creating advanced queries
Summarise and group values
Create a crosstab query
Using a parameter query

Creating advanced form design
Working with graphics
Working with calculations
Working with combo boxes
Working with unbound controls

Using advanced report features
Create customized headers and footers
Add a calculated value
Work with sub-reports

Public Schedule - Pricing and Availability

Access Intermediate 1 day course
Version Date Location Places
available
Book Next place rate (£)
Pay by
Card
Pay by
Invoice
2007 Tue 23 Mar 2010 Bloomsbury 3 Book now £224 £225
2003 Tue 30 Mar 2010 Bloomsbury 5 Book now £199 £204
2003 Thu 22 Apr 2010 Southwark 5 Book now £195 £200
2007 Tue 27 Apr 2010 Bloomsbury 4 Book now £224 £225
2003 Fri 28 May 2010 Bloomsbury 9 Book now £156 £161
2003 Wed 16 Jun 2010 Bloomsbury 8 Book now £95 £100
2007 Fri 25 Jun 2010 Bloomsbury 8 Book now £85 £90
2003 Mon 5 Jul 2010 Southwark 10 Book now £85 £90
2003 Fri 23 Jul 2010 Bloomsbury 9 Book now £75 £80
2007 Tue 3 Aug 2010 Bloomsbury 10 Book now £75 £80
2003 Fri 20 Aug 2010 Bloomsbury 9 Book now £75 £80
2003 Thu 16 Sep 2010 Southwark 10 Book now £75 £80
2007 Wed 29 Sep 2010 Bloomsbury 10 Book now £75 £80
2003 Fri 8 Oct 2010 Bloomsbury 10 Book now £75 £80
2003 Fri 29 Oct 2010 Bloomsbury 10 Book now £75 £80
2007 Tue 9 Nov 2010 Southwark 9 Book now £75 £80
2003 Tue 16 Nov 2010 Southwark 10 Book now £75 £80
2003 Wed 1 + Thu 18 Dec 2010 Bloomsbury 10 Book now £75 £80
2007 Mon 13 Dec 2010 Bloomsbury 10 Book now £75 £80
2003 Fri 17 Dec 2010 Bloomsbury 10 Book now £75 £80

"What do I get on the day?"

What is Microsoft Access?

Microsoft Access is a desktop database application, packaged with Microsoft Office Professional. Unlike Excel, Access is able to work with millions of records, allowing large databases to be created, updated, searched and reported on by multiple users. From simple data capture to complex automation and user interfaces, Access brings all the powerful functionality of a complete database, without the need for expensive servers and administration.


Rate this page:
3.3/5 (6 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Association of Computer Trainers verified by visa, mastercard securecard