Book your training online... 1000's of courses, 100's of locations, 1 website!

Less

COURSE FINDER

or

Booking Enquiry

Microsoft Access Advanced

£395 per delegate

Duration: 1 day

Trainer: WC315P

Course Aims:

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access in order to increase their knowledge and productivity.

Who Should Attend?

Users with a good understanding of Microsoft Office Access who want to expand on their capabilities in a short space of time. TSome of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Course Outline:

Advanced Data Management

- Referential Integrity
- Table Relationships
- An Introduction to SQL
- Modal Dialog Boxes

Advanced Form Tasks

- Using Subforms
- Creating a Navigation Form
- Advanced Form Controls
- Exporting a Form
- Other Form Tasks

Pivoting Data

- Creating a PivotTable
- Using PivotTables
- Advanced PivotTable Tasks
- Creating a PivotChart
- More on PivotCharts

SQL and Microsoft Access

- Understanding SQL
- Using the SELECT Statement
- Using Subqueries
- Using SQL Joins

Additional Information:

Please note that this training can focus on either Microsoft versions 2007, 2010 or 2013 - please state at the time of enquiry which version you would like this training to be held on.

Delegates can also bring their own device to take the training on - please state that you wish to do this at the time of booking so that we can inform the training provider.

This course can be offered both as an open course and as a one-to-one private session with the trainer.

Your Enquiry

Please select expected number of delegates

VCode

I am interested in...

In-Company/Own Venue Open Course All Course Types

Enquiry

Please enter your enquiry details below and leave the rest to us. Need different dates or venue? No problem! Please remember to include:
- Preferred dates
- Preferred location(s)

Your Details

Name

Company Name

Email

Telephone

Mobile

Postcode

Address

City

County

Country

What happens next?
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

Email Enquiries

enquiries@bookmycourse.co.uk

GET A QUOTE