Advanced Access Training
Steve understood exactly what I was trying to do. the course was personalised and progressive - excellent step by step method.
Andie Davidson - Mecmesin Ltd
See More Reviews
To discuss this, or any other course, please contacts us at +44 (0)1273 622272 or use the form below.
Many organisations have large databases in Access that have built up over the years; staff have learned enough to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports.
However, when databases get big making your queries and forms effective can become more complex and it is worth investing in advanced Access training to get the most from your data and save time.
Building upon skills covered on our beginners Microsoft Access Training Course our Advanced Microsoft Access course teaches delegates how to analyse data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros.
If you are a looking for training specific to your business, we can provide private and in-company Microsoft Access Courses. Call us on +44 (0)1273 622272 to discuss your needs.
Before attending this course you must have attended our Beginners Microsoft Access Course or have equivalent experience.
By the end of this Advanced MS Access training course, delegates will be able to:
- Demonstrate an advanced understanding of Microsoft Access
- Design advanced queries, forms and reports
- Use macros to increase productivity and perform advanced functions
Great teaching - very enjoyable & helpful.
Claire Thackway, Brighton College
Feel I have had a rounded introduction to Access, which is exactly what I required from the course. Very friendly and patient trainer who ran the course at a flexible pace
Paul Clarke - Hampshire Probation Trust
Advanced Access Training Course Content
- Review of basic concepts:
- Design concepts
- Relationships between tables
- Using And and Or statements
- Totals Queries
- Creating calculations in queries
- Parameter Queries
- Autolookup Queries
- Adding controls
- Working with combo boxes
- Working with calculated controls
- Control properties
- Working with subforms
- Creating a report using the Wizard
- Designing grouped reports
- Adding sub-totals to reports
- Creating simple macros
- Creating grouped macros
- Creating conditional macros
- Assigning macros to command buttons
- Creating a Switchboard
- Using macros to pass conditions between forms
- Using macros to pass conditions to run reports
- Course Title
- Advanced Access Training
- 1 day
- Brighton, UK
- £225.00 + VAT
- 6 May 2014
This course can be run in-company anywhere in the world & we can tailor the content to focus on your requirements.
We regularly provide training in London, Manchester, Bristol and Europe.
Who is this course for?
This course is aimed at Microsoft Access users who want to expand their knowledge to include advanced techniques and macros. We recommend that you attend our Beginners MS Access course or have equivalent experience.
To request a quote or book a course fill in the form below and one of our training managers will be in contact as soon as possible to confirm your details and answer any questions.
Office hours are Monday-Friday 8.30-5.30pm.