Access 2007 Advanced

Access

Course outline -

1 Day

Who is it for?

This course is designed for users who have previously attended an Access Intermediate course or posses an equivalent level of knowledge.

What will they learn?

By the end of this course delegates will have an understanding of the principles of good database design. They will be able to restrict the type of data that is added to the database by adding validation and make data entry easier with well designed forms. They will be able to add calculations and page numbers to forms and reports, as well as adding graphic objects.

Database Design Concepts
Data Validation
Creating Relationships Between Tables
Customising Forms
List And Combo Boxes
Check Boxes, Option & Toggle Buttons.
Command Buttons
Calculated Fields
Adding Page Numbers
Adding the Date And Time
Create A Form With Multiple Pages Or Tabs
Tab Order
Inserting Graphics in Forms or Reports

Dates

30 Apr 2012

Dates

24 Sep 2012

Price

£99 +VAT

Location

Hatfield

Creative

Choose your course

Microsoft

Printable 2012 Training Schedule

How to book

Call 0845 372 1924 when
you have chosen your course

What people say....

We contracted Clearwater Training last year to deliver a number of introductory courses on Microsoft SharePoint 2007 to our staff. Annie Ghanmi proved to be an enthusiastic, reliable and skilled trainer bringing to life training sessions that could have been tedious in other hands. Look forward to working with Clearwater Training again soon.

Robin Bourne - Shaw Trust.
A great course (Excel Intermediate). Easy to learn from. Any questions were answered clearly. I can now go away and use what I have learnt to great effect in the future. I am very keen to expand my Excel knowledge and to do the next course.

Michelle Smith - Showcard Print
A very good and informative course (Excel Introduction)

Simon Protheroe - Anixter Adhesives
It was a good idea to do all three courses [Excel 2010 Introduction, Intermediate & Advanced] in quick succession. The Advanced course isn't so much more advanced but complements the Intermediate course and offers different things.

Sam Howard
Very good, enjoyed the day and learnt a lot.

Kayleigh - First Call Contract Services
Excellent, approachable trainer. All course content contained within the training manual provided. Advanced topics explained in plain English and at a comfortable pace.

Richard Game
Excellent & Informative [Word 2007 Intermediate], thanks Annie!

Joanne Dunne
Clearwater has provided the perfect trainer for our requirements every time we have used them - Annie was especially attentive to our needs and clear in her training. We continue to use Clearwater for all our IT training needs.

Simon from theatre breaks.com
Annie made me feel at home and made Excel fun - thank you.

Nick Marzec - Showcard Print
Great course (Photoshop), great trainer. Perfectly priced.

Alex at Saros
The training I received from Clearwater Training was excellent. It covered all the key areas I needed and was trained at the right speed to allow everyone in the group to learn the skills they needed. The training was an even mix of information and practical work. I would definitely recommend using Clearwater training.

Zoe M