ACCESS TRAINING COURSES BARGOED
About Enable Technology Bargoed Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Access courses are taught by a Microsoft Certified Solutions 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. We also offer the option of scheduling of Access course at a venue near you in Bargoed. All Access courses can be customised to meet your particular 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Norfolk Police Constabulary, Homeserve PLC, Countrywide Homes Limited, Wolverhampton City Council, Halfords Group PLC, GKN PLC, Barclays Bank PLC and Total Telecommunications Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bargoed
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Using the Select Case...End Select Structure
- See Training Course Details...
Using Input Boxes
Using Visual Basic Help
Understanding the Form Object
Using the If...End If Decision Structures
Creating a Function Procedure
Working with Inline Error Handling
Using the CacheSize Property - Optional
Using Intrinsic Functions
Understanding the DoCmd Object
Creating a Standard Module
Guidelines for use of Branching Structures
Handling Errors
Understanding Recordset Cursor Properties - Optional
Working with Variable Lifetime
Working with Events
Working with the Code Editor
Working with Recordsets
Considering Variable Scope and Lifetime Together
Why Program in Access?
Microsoft Access
- 2 day course
- Location: Bargoed
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Formatting Tables
- See Training Course Details...
Creating and Using Macros
Importing and Exporting Records
Relational Database Design
Working With Records
Creating a Lookup Database
Action Queries
Using a Navigation Form
Calculations in Queries
Designing a Lookup Database
Querying Techniques
Multi Table Queries
Macros on Forms
Parameter Queries
Adding Transactional Records
Understanding VBA
Creating and Using Reports
Setting Table Relationships
Macro Techniques
Modifying Forms
Database Wellness
Email us about this courses
Other Bargoed Enable Technology Training Courses
VBA - Bargoed Excel Training Courses
Excel 365 Basic - Bargoed Excel Training Courses
SQL Bargoed Training Courses
TSQL - Bargoed SQL Training Courses
Excel 365 Advanced - Bargoed Excel Training Courses
Report Builder - Bargoed SQL Server Reporting Services Training Courses