Click to view prices and options,
and book or buy your training
Need to know more? We're happy to help
- Training businesses & people since 1995
- Quality assured with ISO9001, ILM
and CPD accreditation
- Fiercely competitive pricing
- Small class sizes
- Friendly, attentive staff for flexible,
- Classes are never cancelled
Click for more information on
Microsoft Access training
The best solution for Advanced Access 2007 To 2016 Training CoursesA hands-on one-day course with free e-learning revision after your training and pre-course online skills testing. Free bespoke course design is also available for private classes if the content needs to be adjusted
Full details of modules and topics covered in this one-day course
This course covers 2007, 2010, 2013 and 2016 versions
Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) classes and standard on-site/private classes (not available for bespoke courses) .
This is a one-day training course structured into 6 modules
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.
Users with a solid understanding of MS Access 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Some 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.
- Referential Integrity
- Table Relationships
- An Introduction to SQL
- Modal Dialog Boxes
- Using Subforms
- Creating a Navigation Form
- Advanced Form Controls
- Exporting a Form
- Other Form Tasks
- Creating the Report Form
- Building Query Criteria
- Understanding SQL
- Using the SELECT Statement
- Using Subqueries
- Using SQL Joins
- Macro Basics
- More about Macros
- Access and VBA
- Building Advanced Procedures
- Using VBA in a Database
- Setting Start Up Options
- Sharing/Splitting the Database
- Creating an ACCDE
- Encrypting the Database with a Password
[Duration: one day]
- Getting Started with Access
- The New Ribbon Interface
- Creating a Simple Database
- Forms; Queries; Reports and Filters
[Duration: one day]
- Advanced File Tasks
- Working with Tables
- Working with Forms
- Working with Reports
- Working with Queries
AVERAGE REVIEW: 4.3 out of 5 BASED ON 24 REVIEWS
"Would recommend Activia to other employee's and friends, good course with good trainers. "
Carol Prior, Dec 20 2017
"Dallas was an excellent trainer"
Ash Dean , Aug 25 2017
"I thought John was great - very knowledgeable and accommodating to my many questions!"
Danielle Roseweir, Jun 29 2016
"Gareth was a good trainer, very informative and took the time to ensure understanding and go over practical examples"
Kay Sawbridge, Mar 9 2016
"Trainer was very good, lunch was nice."
TANJA THOMAS, Jan 29 2016
"Good structure and a wide range of topics covered. "
Joan Hibbert, Aug 19 2015
"very good trainer"
John O`Neill, Aug 19 2015
"Small class size was good. "
Tanya A'len, Jun 24 2015
"John was an amazing trainer and clearly a subject matter expert. Thank you John!"
Les Sayer, Apr 9 2015
"The course and tutor were excellent."
Miranda Loutet, Apr 1 2015
"This was a very useful day for me."
Shona Holmes, Feb 25 2015
"The trainer Mark was very patient and helpful with a barrage of questions and happy to deviate from the lesson planner when the questions went off on a tangent. I highly recommend the course and the trainer. "
Mark Burton, Feb 25 2015
"The trainer, Mark, was excellent and very helpful. "
Steve English, Feb 11 2015
"I have done 'a lot' of courses over the years with many teachers / trainers and Gareth is right up there as one of the best. I felt we could ask him anything and he answered all our questions very well. Me and the other student had quite specific projects to do and Gareth was able to help us with how we would transfer the skills into the 'real world' and he also set us challenges to complete after completing the material to test our newly found skills which simulated our project requirements."
Cliff Orme, Nov 28 2014
"The tutor Gareth was excellent to learn from."
With our latest Microsoft Access courses, you get free e-learning revision for a full 12 months after your class so you can reinforce the knowledge you have gained.
Access is simple: go to www.activia.co.uk/login/ and log in using your email address. This will give you free access to our e-learning revision modules.
Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the e-learning exactly to what you cover in class. We hope you have fun, on the day of the course and with honing your knowledge afterwards!
All Activia advanced access 2007 to 2016 training courses have been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Access training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.
Maximum class size for Microsoft Access courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates.
Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.
For training at your offices, we can deliver classes of up to 10 delegates, though with bigger class sizes you must understand that there is less time for questions from delegates, and this may affect the quality of their experience.
Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.
Also note: If you are a private individual you must pay by credit card at the time of booking.
Note: Please allow 1 - 2 working days for your confirmation and invoice.
If you are coming to our centre, dress code is smart casual. Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch. The timetable is as follows:
Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !
For training at your offices, this itenerary can be varied by prior arrangement.
With every Microsoft Access training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge. With all Access 2007 to 2016 courses, you are also given 12 months access to free e-learning revision which will further help you to reinforce the lessons you have learned.
Every delegate on a Microsoft Access course also gets an Activia Training Attendance Certificate.
MICROSOFT ACCESS 2007 TO 2016 TRAINING
We can enhance your skills with Microsoft Access 2007 to 2016 software training at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our advanced access 2007 to 2016 courses are 1 day, which keeps "out of office" periods for attendees to a minimum.
We have been delivering Microsoft access 2007 to 2016 training all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of training in Access 2007 to 2016 to ensure constantly improving standards of quality. So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Training in Access 2007 to 2016 from Activia.
Why not contact us today to see how we can help with providing your courses for Microsoft Access 2007 to 2016 ?