Microsoft Access 2003 Intermediate

Perhaps you have already mastered the basics of Microsoft Access and are convinced of its benefits. Are you ready to take your skills to the next level? If so, by attending our Intermediate course you will boost your understanding of this powerful technology and learn how to:

• Link tables by creating and editing relationships to produce complex forms and reports
• Discover more efficient techniques for entering data
• Analyse table relationships and use referential integrity and cascade functions
• Create and use advanced query techniques
• Perform calculations and summaries using the databases
• Apply advanced techniques to form and report design
• Employ indexing techniques, the input mask and field values
• Work with calculations and create advanced select queries
• Understand the purpose of the form, bound and unbound controls, memo fields in form design and specialist bound control objects
• Customise a report created by the report wizard

Details

• Our trainers are experts in their topic and deliver courses in a practical, interactive style
• The maximum number of people on a training course is 12 so that the trainer can accommodate the learning needs of each delegate
• Each delegate is provided with a laptop and we use the most up to date technology
• A two course buffet lunch and unlimited tea and coffee are included in the price

Timing
Courses start at 9.30 and end at 4.30 p.m. with half an hour for lunch

Is this the right course for me?
Yes, if you have some previous experience of Microsoft Access and can already create tables, queries, forms and reports (covered in our Microsoft Access Introductory course)

Level
Introductory

About the Facilitator

Your Trainer
Bob is an expert IT trainer and is a Microsoft Office Specialist Master Instructor. He has worked across a range of businesses and has helped people at all levels improve their IT skills. Bob is comfortable supporting people to learn at introductory level and enjoys the challenge of helping people develop their skills at advanced level.

 

Support available
If your business is located in the West of Scotland you may be eligible for a grant of up to 50% of the cost of participating in these courses. There are a number of places available which are reserved for businesses with less than 250 employees and companies must meet certain eligibility criteria.

Click here to see location map

Options

• We can customise this course for you if you have a particular challenge in your company.  One of our specialist advisers will be happy to work on a solution with you.  If you have a group of 12 people who need the same training customised learning is a cost effective way to develop them and costs can be as little as £100 per person. Click here for more information.
• We can also provide one to one coaching in this subject area. Click here for more information