ACCESS TRAINING COURSES CWMBRAN
About Enable Technology Cwmbran Access Training Courses
We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a socially distanced local training venue in Cwmbran. The Access syllabus can be adjusted and additional topics incorporated if helpful.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Homeserve PLC, TalkTalk Direct Limited, Norfolk Police Constabulary, Boots UK Limited, Queen's Medical Centre Nottingham, Keele University, Norwich Union PLC and EDF Energy PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cwmbran
- 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 ... Declaring Variables
- See Training Course Details...
Writing an Error-Handling Routine
Naming Procedures
Understanding Control-of-Flow Structures
Understanding Modules
Using Intrinsic Functions
Debugging Code
Considering Variable Scope and Lifetime Together
Working with Procedures and Functions
Determining the Value of Expressions
Understanding Constants
Using the Object Browser
Understanding Objects
Handling Errors
Working with Events
Specifying a Recordset Cursor Type
Understanding Data Types
Working with Inline Error Handling
Using the If...End If Decision Structures
Understanding Errors
Microsoft Access
- 2 day course
- Location: Cwmbran
- 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 ... Querying Techniques
- See Training Course Details...
Creating a Relational Database
Creating Queries
Macros on Forms
Creating and Using Macros
Designing a Lookup Database
Parameter Queries
Importing and Exporting Records
Database Security
Sorting and Filtering
Macro Techniques
Modifying Table Structures
Creating a Lookup Database
Using a Navigation Form
Aggregation Queries
Adding Records to a Table
Navigation Pane Protection
An Introduction to VBA
Modifying Forms
Calculations in Queries
Formatting Tables
Email us about this courses
Other Cwmbran Enable Technology Training Courses
VBA Cwmbran Training Courses
SSAS Tabular - Cwmbran SQL Server Analysis Services Training Courses
Excel 365 Intermediate Cwmbran Training Courses
Report Builder - Cwmbran SQL Server Reporting Services Training Courses
JavaScript Cwmbran Training Courses
Power Query - Cwmbran Excel Training Courses