ACCESS TRAINING COURSES NORTH WEST
About Enable Technology North West Access Training Courses
Enable Technology provides practical Access skills based technology training. All Enable Technology tutors are Microsoft certified experts. We will issue each Access training participant with learning resources which they can refer to post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We also offer the option of scheduling of Access course at a socially distanced venue near you in the North West. Every Access course can be modified to meet your bespoke 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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are West Bromwich Building Society, Carillion PLC, DHL Express, Wolverhampton City Council, South Staffordshire Water PLC, Dollond & Aitchison Limited, Fujistu PLC and TalkTalk Direct Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: North West
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Error Handling
- See Training Course Details...
Using the If...End If Decision Structures
Understanding the Order of Events
Declaring and Creating Object Variables
Working with Variable Lifetime
Working with Boolean Expressions
Using the Do...Loop Structure
Understanding VBA's Error Trapping Options
Using the For Each...Next Structure
Using Visual Basic Help
Using the For...Next Structure
Using the With Statement
Understanding Classes and Objects
Why Program in Access?
Working with the Application Object
Handling Errors
Introduction to Programming in Access
Microsoft Access
- 2 day course
- Location: North West
- 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 ... Understanding VBA
- See Training Course Details...
Creating a Relational Database
Database Wellness
Database Security
Designing a Lookup Database
Importing and Exporting Records
Data Validation
Creating and Using Forms
An Introduction to VBA
Formatting Tables
Adding Records to a Table
Using a Navigation Form
Relational Database Design
Creating and Using Reports
Navigation Pane Protection
Calculations in Queries
Working With Records
Querying Techniques
Getting to Know Access
Creating Queries
Parameter Queries
Email us about this courses
Other North West Enable Technology Training Courses
Excel 365 Advanced North West Training Courses
Data Warehouse - North West SQL Training Courses
Excel 365 Basic - North West Excel Training Courses
Excel Power Pivot - North West Excel Training Courses
PL/SQL North West Training Courses
Oracle SQL - North West SQL Training Courses