ACCESS TRAINING COURSES LEAMINGTON SPA
About Enable Technology Leamington Spa Access Training Courses
We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Leamington Spa. All Access courses can be customised to meet your particular requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are West Bromwich Building Society, Birmingham Heartlands Hospital, Keele University, Cadbury PLC, Nuclear Engineering Services, Canadian High Commission, Carillion PLC and South Staffordshire Water PLC.
Microsoft Access
- 2 day course
- Location: Leamington Spa
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Adding Records to a Table
- See Training Course Details...
Navigation Pane Protection
Adding Transactional Records
Understanding VBA
Modifying Table Structures
Modifying Forms
Macros on Forms
Relational Database Design
Creating a Lookup Database
Sorting and Filtering
Creating and Using Forms
Creating and Using Macros
Getting to Know Access
Importing and Exporting Records
Formatting Tables
Database Wellness
Calculations in Queries
Using a Navigation Form
Creating Queries
Multi Table Queries
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leamington Spa
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding the DoCmd Object
- See Training Course Details...
Working with Boolean Expressions
Debugging Code
Understanding Errors
Understanding Modules
Working with the Code Editor
Setting Breakpoints
Creating a Function Procedure
Handling Errors
Introduction to Programming in Access
Working with Recordsets
Understanding Constants
Organizing Code and Procedures
Naming Procedures
Guidelines for use of Branching Structures
Understanding the Form Object
Using Visual Basic Help
Navigating the Access Object Hierarchy
Email us about this courses
Other Leamington Spa Enable Technology Training Courses
Data Warehouse Leamington Spa Training Courses
Excel 365 Advanced - Leamington Spa Excel Training Courses
Oracle SQL Leamington Spa Training Courses
Excel 365 Basic - Leamington Spa Excel Training Courses
Power BI - Leamington Spa Microsoft Power BI Training Courses
VBA - Leamington Spa Excel Training Courses