ACCESS TRAINING COURSES LLANTRISANT
About Enable Technology Llantrisant Access Training Courses
We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training Access resources which they can continue to use after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If you prefer we can offer an offsite socially distanced training location in Llantrisant. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Capita Group PLC, Lloyds TSB Bank PLC, Shell UK Oil Products Ltd, Yell Group PLC, Nuclear Engineering Services, Unipart Group, Birmingham Heartlands Hospital and Canadian High Commission.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llantrisant
- 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 ... Calling Procedures
- See Training Course Details...
Understanding Classes and Objects
Using Intrinsic Functions
Locking Records for Updating
Organizing Code and Procedures
Understanding Expressions and Statements
Understanding Data Types
Using the If...End If Decision Structures
Using the Object Browser
Using the With Statement
Working with Methods
Specifying a Recordset Cursor Type
Using Message Boxes
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Using the Select Case...End Select Structure
Controlling Program Execution
Understanding the Err Object
Using Debugging Tools
Understanding Recordset Cursor Properties - Optional
Microsoft Access
- 2 day course
- Location: Llantrisant
- 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 ... Database Wellness
- See Training Course Details...
Adding Transactional Records
Macro Techniques
Creating a Relational Database
Adding Records to a Table
Querying Techniques
Importing and Exporting Records
Calculations in Queries
Parameter Queries
Getting to Know Access
Creating Queries
DIY Forms
Data Validation
Modifying Forms
Aggregation Queries
Working With Records
Multi Table Queries
Modifying Table Structures
Creating and Using Macros
Sorting and Filtering
Creating and Using Forms
Email us about this courses
Other Llantrisant Enable Technology Training Courses
JQuery - Llantrisant JavaScript Training Courses
Excel Power Pivot - Llantrisant Excel Training Courses
SSRS - Llantrisant SQL Server Reporting Services Training Courses
TSQL - Llantrisant SQL Training Courses
SQL Llantrisant Training Courses
Excel 365 Basic - Llantrisant Excel Training Courses