ACCESS TRAINING COURSES RISCA
About Enable Technology Risca Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued Access training manuals they can 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. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite socially distanced training location in Risca. 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.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are GKN PLC, Dollond & Aitchison Limited, Carillion PLC, Birmingham City Council, Birmingham City University, Countrywide Homes Limited, Keele University and Barclays Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Risca
- 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 ... Using Visual Basic Help
- See Training Course Details...
Handling Errors
Understanding Error Handling
Using the Do...Loop Structure
Stepping through Code
Understanding the DoCmd Object
Using the Immediate Window to Call Procedures
Working with the Code Editor
Determining the Value of Expressions
Trapping Errors with the On Error Statement
Calling Procedures
Understanding the Form Object
Understanding Collections
Understanding Modules
Setting Break Expressions
Guidelines for use of Branching Structures
Using the For...Next Structure
Using the CacheSize Property - Optional
Naming Procedures
Microsoft Access
- 2 day course
- Location: Risca
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... An Introduction to VBA
- See Training Course Details...
Importing and Exporting Records
Action Queries
Multi Table Queries
Working With Records
Setting Table Relationships
Navigation Pane Protection
Creating and Using Macros
Adding Records to a Table
Data Validation
Creating and Using Reports
Sorting and Filtering
Aggregation Queries
Macro Techniques
Understanding VBA
Calculations in Queries
Database Security
Creating Queries
Creating a Lookup Database
Relational Database Design
Macros on Forms
Email us about this courses
Other Risca Enable Technology Training Courses
Power BI Risca Training Courses
Data Warehouse - Risca SQL Training Courses
Excel 365 Intermediate Risca Training Courses
Excel 365 Advanced Risca Training Courses
SSAS - Risca SQL Server Analysis Services Training Courses
TSQL Risca Training Courses