Instructor-led training - London Course Access
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Access Course London & UK wide

Microsoft Access 97 Intermediate

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

Training formats available

Who is this training course suitable for?

Our Microsoft Access 2003 Intermediate 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 with a basic knowledge 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, learning how to troubleshoot along the way. After studying advanced table design factors, 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 Onsite/Closed Quote
Version Date Location Places
available
Book Next place rate (£) List
price
Pay by
Card
Pay by
Invoice
2010 Thu 30 May 2013 Southwark 8 Book now £285 £295£299
2003 Wed 10 Jul 2013 Southwark 9 Book now £207 £217£235
2010 Tue 6 Aug 2013 Bloomsbury 9 Book now £160 £170£299
2007 Tue 6 Aug 2013 Limehouse 9 Book now £204 £214£235
2010 Tue 10 Sep 2013 Southwark 10 Book now £299 £299£299
2007 Mon 23 Sep 2013 Southwark 9 Book now £189 £199£235
2010 Wed 16 Oct 2013 Bloomsbury 10 Book now £150 £160£299
2007 Wed 16 Oct 2013 Limehouse 9 Book now £75 £85£235
2010 Thu 28 Nov 2013 Bloomsbury 10 Book now £299 £299£299
2007 Tue 3 Dec 2013 Limehouse 10 Book now £235 £235£235
2007 Thu 9 Jan 2014 Southwark 10 Book now £75 £85£235
2010 Fri 17 Jan 2014 Southwark 10 Book now £150 £160£299
2007 Tue 4 Mar 2014 Bloomsbury 10 Book now £235 £235£235
2010 Mon 17 Mar 2014 Limehouse 10 Book now £150 £160£299
2007 Thu 15 May 2014 Limehouse 10 Book now £75 £85£235
2010 Thu 29 May 2014 Southwark 10 Book now £150 £160£299
2007 Wed 16 Jul 2014 Bloomsbury 10 Book now £75 £85£235

"What do I get on the day?"

  • Microsoft qualified trainers with industry relevant experience
  • Modern air conditioned training suite, flat screen PC's, 1 per delegate
  • Lunch provided in a comfortable and relaxed setting
  • Comprehensive course material and files to take away
  • What do I get on the day? - More information

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.



Access courses
Course rating:
4.8 stars - based on 4042 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest