ACCESS TRAINING COURSES NATIONAL
About Enable Technology National Access Training Courses
Enable Technology provides practical Access skills based technology training. All Enable Technology tutors are Microsoft certified experts. All course participants are issued Access training manuals they can refer to after the course. 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.
Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local venue in National. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have over twenty years continuous technical training experience. Our clients include: Carillion PLC, EDF Energy PLC, Aston University, Halfords Group PLC, Lloyds TSB Bank PLC, Countrywide Homes Limited, Shell UK Oil Products Ltd and Cadbury PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: National
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Locking Records for Updating
- See Training Course Details...
Using Intrinsic Constants
Working with Properties
Using Debugging Tools
Using the Object Browser
Understanding Collections
Using the Select Case...End Select Structure
Working with the Code Editor
Debugging Code
Setting Break Expressions
Considering Variable Scope and Lifetime Together
Navigating the Access Object Hierarchy
Calling Procedures
Declaring Variables
Understanding Recordset Cursor Properties - Optional
Working with the ADODB Recordset Object
Understanding the Order of Events
Understanding Procedures
Understanding Expressions and Statements
Understanding Error Handling
Controlling Program Execution
Microsoft Access
- 2 day course
- Location: National
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Creating and Using Reports
- See Training Course Details...
Creating and Using Macros
Creating a Lookup Database
Creating a Relational Database
Modifying Table Structures
Using a Navigation Form
An Introduction to VBA
Data Validation
Aggregation Queries
Multi Table Queries
Adding Transactional Records
Database Security
Getting to Know Access
Database Wellness
Macro Techniques
Importing and Exporting Records
DIY Forms
Relational Database Design
Action Queries
Parameter Queries
Calculations in Queries
Email us about this courses
Other National Enable Technology Training Courses
JavaScript National Training Courses
SSAS Tabular - National SQL Server Analysis Services Training Courses
Excel 365 Advanced National Training Courses
PL/SQL National Training Courses
SSIS National Training Courses
Power Query - National Excel Training Courses