ACCESS TRAINING COURSES LEIGH
About Enable Technology Leigh Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). We will issue each Access training participant with learning resources which they can refer to post training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
We provide instructor led training coupled with hands on training. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a socially distanced training location in Leigh. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Cadbury PLC, Lloyds TSB Bank PLC, TalkTalk Direct Limited, Canadian High Commission, Aston University, Capita Group PLC, EDF Energy PLC and Countrywide Homes Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leigh
- 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 Constants
- See Training Course Details...
Introduction to Programming in Access
Understanding Control-of-Flow Structures
Using the If...End If Decision Structures
Understanding Error Handling
Creating a Standard Module
Working with Boolean Expressions
Setting Breakpoints
Using the Select Case...End Select Structure
Specifying a Recordset Cursor Location - Optional
Understanding Recordset Cursor Properties - Optional
Declaring Variables
Using the With Statement
Working with the Application Object
Working with Properties
Using the For...Next Structure
Using Break Mode during Run Mode
Naming Procedures
Working with the ADODB Recordset Object
Stepping through Code
Microsoft Access
- 2 day course
- Location: Leigh
- 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 ... Creating a Relational Database
- See Training Course Details...
Creating Queries
DIY Forms
Creating and Using Macros
Action Queries
Importing and Exporting Records
An Introduction to VBA
Setting Table Relationships
Aggregation Queries
Formatting Tables
Modifying Forms
Sorting and Filtering
Using a Navigation Form
Adding Transactional Records
Navigation Pane Protection
Getting to Know Access
Macro Techniques
Database Wellness
Multi Table Queries
Macros on Forms
Data Validation
Email us about this courses
Other Leigh Enable Technology Training Courses
SQL - Leigh SQL Training Courses
Excel 365 Basic - Leigh Excel Training Courses
JQuery Mobile - Leigh JavaScript Training Courses
Excel 365 Intermediate - Leigh Excel Training Courses
SSRS - Leigh SQL Server Reporting Services Training Courses
Power Query Leigh Training Courses