ACCESS TRAINING COURSES LEEK
About Enable Technology Leek Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local training site in Leek. We are happy to modify the Access syllabus to match your teams training requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Nuclear Engineering Services, Aston University, Queen's Medical Centre Nottingham, Loughborough University, Total Telecommunications Limited, Royal Air Force, Boots UK Limited and Lloyds TSB Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leek
- 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 ... Debugging Code
- See Training Course Details...
Understanding Modules
Understanding the Form Object
Using Visual Basic Help
Using the CacheSize Property - Optional
Working with Variable Scope
Specifying a Recordset Cursor Type
Understanding Collections
Using Break Mode during Run Mode
Specifying a Recordset Cursor Location - Optional
Creating a Standard Module
Working with Properties
Using Expressions, Variables, and Intrinsic Functions
Understanding the DoCmd Object
Understanding Control-of-Flow Structures
Working with Inline Error Handling
Understanding the Order of Events
Locking Records for Updating
Microsoft Access
- 2 day course
- Location: Leek
- 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 ... Designing a Lookup Database
- See Training Course Details...
Querying Techniques
Calculations in Queries
Macro Techniques
An Introduction to VBA
Creating Queries
Aggregation Queries
Using a Navigation Form
Data Validation
Creating a Lookup Database
Action Queries
Understanding VBA
Creating and Using Reports
Sorting and Filtering
Importing and Exporting Records
Multi Table Queries
Getting to Know Access
Adding Records to a Table
Adding Transactional Records
Creating and Using Macros
Formatting Tables
Email us about this courses
Other Leek Enable Technology Training Courses
Report Builder - Leek SQL Server Reporting Services Training Courses
PL/SQL Leek Training Courses
Power BI - Leek Microsoft Power BI Training Courses
Oracle SQL - Leek SQL Training Courses
Power Query Leek Training Courses
Data Warehouse Leek Training Courses