ACCESS TRAINING COURSES MOLD
About Enable Technology Mold Access Training Courses
We are company which specialises in short, two and three day intensive Access technology 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. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a Access course at an alternative training site in Mold. We are happy to discuss customising the course content should you have particular Access training requirements.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Vodafone Group Services, Shell UK Oil Products Ltd, Wolverhampton City Council, Countrywide Homes Limited, Yell Group PLC, EDF Energy PLC, GKN PLC and Royal & Sun Alliance Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Mold
- 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 ... Why Program in Access?
- See Training Course Details...
Using Input Boxes
Using the Immediate Window to Call Procedures
Setting Breakpoints
Understanding Collections
Writing an Error-Handling Routine
Naming Procedures
Creating a Function Procedure
Controlling Program Execution
Understanding Error Handling
Using Expressions, Variables, and Intrinsic Functions
Working with Procedures and Functions
Working with the Code Editor
Understanding Data Types
Working with Recordsets
Understanding Recordset Cursor Properties - Optional
Using Intrinsic Constants
Declaring and Creating Object Variables
Microsoft Access
- 2 day course
- Location: Mold
- 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 ... Creating a Lookup Database
- See Training Course Details...
Calculations in Queries
Navigation Pane Protection
Adding Records to a Table
Parameter Queries
Macro Techniques
Creating and Using Forms
Setting Table Relationships
Macros on Forms
Creating Queries
Multi Table Queries
Sorting and Filtering
Creating and Using Macros
Understanding VBA
Modifying Forms
Relational Database Design
Data Validation
Action Queries
Creating a Relational Database
Querying Techniques
Importing and Exporting Records
Email us about this courses
Other Mold Enable Technology Training Courses
JQuery - Mold JavaScript Training Courses
SQL - Mold SQL Training Courses
Excel 365 Advanced - Mold Excel Training Courses
SSIS - Mold SQL Server Integration Services Training Courses
Power BI Mold Training Courses
Excel 365 Intermediate Mold Training Courses