Details
This advanced Microsoft Access training course will build on your existing skills to teach you advanced techniques for making the most of Access’s functionality.
Microsoft Access is a very popular and widely used database program enabling the user to manipulate data in a wide variety of ways. Data can be analysed and sorted, specific information can be searched for, and the results can be used to produce reports, lists and more.
Access is part of the Microsoft Office suite. We offer training on all versions of Microsoft Access – 2003, 2007, 2010 and 2013.
OBJECTIVES
- export records to and import records from a wide variety of sources and applications
- create queries based on one or more tables
- create calculated queries
- create and use parameter queries
- create and work with aggregation queries
- modify and adapt an existing form according to specific needs
- create and use macros in Access
- work with a number of macro techniques
- create and work with macros in forms
- create some simple programming code using VBA
- design a relational database project
A good working knowledge of Access is required; delegates should have an understanding of concepts covered in the Access Introduction/Intermediate course. These include creating and modifying table structures, creating a relational database, working with records, creating queries, forms and reports.
WHAT'S INCLUDED
- A full colour advanced MS Access manual or book.
- The exercises that you have worked on during your course to allow you to practice afterwards.
- USB stick to take the exercises away (where relevant).
- Freshly prepared lunch in our onsite cafeteria.
- Refreshments though out the day.
- Training in fully air conditioned facilities from an experienced Access instructor.
- Free parking at our Guildford training centre.
Founded in 2002, Acuity is focused on building long-term business relationships by offering high quality, interactive training that works.
Our trainers have years of experience working within commerce and industry, designing and delivering training programmes for all sorts of organisations. Most importantly, they really love what they do.
With class sizes limited to a maximum of 8 delegates (but typically running with between 2-6) our training courses are able to incorporate numerous hand’s on exercises to consolidate the learning and delegates are assured of detailed personal attention, with plenty of time to ask questions and tackle issues that are relevant to them. Each of our delegates receives a full colour manual and copies of the relevant course exercises to take away with them so that they can review the course material in their own time after the course.
Here are just a few reasons why our customers say they keep coming back to us:
•Easy booking procedure.
•Passionate, highly experienced trainers.
•Small, personal classes.
•Relaxed and highly supportive learning environment.
•Relevant and up-to-date training programmes.
•Proven track record, from SMEs to large government departments and multinationals ...
