ACCESS TRAINING COURSES WREXHAM
About Enable Technology Wrexham Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training Access resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the Access course at a local training venue in Wrexham. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Homeserve PLC, Royal Air Force, Dollond & Aitchison Limited, Loughborough University, Boots UK Limited, Canadian High Commission, Nuclear Engineering Services and Shell UK Oil Products Ltd.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wrexham
- 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 ... Working with Properties
- See Training Course Details...
Understanding Error Handling
Working with Boolean Expressions
Understanding the Development Environment
Using Debugging Tools
Why Program in Access?
Understanding Control-of-Flow Structures
Calling Procedures
Using Expressions, Variables, and Intrinsic Functions
Working with Variable Lifetime
Understanding the Form Object
Creating a Sub Procedure
Specifying a Recordset Cursor Type
Using Visual Basic Help
Understanding Objects
Writing an Error-Handling Routine
Understanding Collections
Understanding Recordset Cursor Properties - Optional
Microsoft Access
- 2 day course
- Location: Wrexham
- 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 ... Setting Table Relationships
- See Training Course Details...
Designing a Lookup Database
Understanding VBA
Navigation Pane Protection
Creating and Using Forms
Parameter Queries
Creating a Relational Database
Calculations in Queries
Creating a Lookup Database
Database Wellness
Creating and Using Macros
Querying Techniques
Adding Transactional Records
Sorting and Filtering
Aggregation Queries
Working With Records
Modifying Table Structures
An Introduction to VBA
Getting to Know Access
Data Validation
Action Queries
Email us about this courses
Other Wrexham Enable Technology Training Courses
SSRS - Wrexham SQL Server Reporting Services Training Courses
JavaScript - Wrexham JavaScript Training Courses
PL/SQL Wrexham Training Courses
DAX Wrexham Training Courses
Excel 365 Advanced Wrexham Training Courses
Power BI - Wrexham Microsoft Power BI Training Courses