ACCESS TRAINING COURSES WREXHAM
About Enable Technology Wrexham Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We are also more than happy to organise a local course at a training location in Wrexham. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Royal & Sun Alliance Group PLC, Shell UK Oil Products Ltd, Keele University, University of Birmingham, Homeserve PLC, Canadian High Commission, Vodafone Group Services and Birmingham Heartlands Hospital.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wrexham
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Using the With Statement
- See Training Course Details...
Using Intrinsic Constants
Understanding Control-of-Flow Structures
Creating a Sub Procedure
Working with Recordsets
Navigating the Access Object Hierarchy
Controlling Program Execution
Understanding Expressions and Statements
Using the Do...Loop Structure
Using the If...End If Decision Structures
Declaring and Creating Object Variables
Trapping Errors with the On Error Statement
Setting Breakpoints
Debugging Code
Working with the Application Object
Naming Procedures
Using Input Boxes
Understanding the Development Environment
Understanding Classes and Objects
Understanding Data Types
Microsoft Access
- 2 day course
- Location: Wrexham
- 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 ... Using a Navigation Form
- See Training Course Details...
Getting to Know Access
Creating a Lookup Database
Sorting and Filtering
Creating and Using Forms
Creating Queries
Querying Techniques
Relational Database Design
Macro Techniques
Parameter Queries
Multi Table Queries
Importing and Exporting Records
An Introduction to VBA
Adding Records to a Table
Understanding VBA
Aggregation Queries
Data Validation
Modifying Table Structures
Navigation Pane Protection
Creating a Relational Database
Database Security
Email us about this courses
Other Wrexham Enable Technology Training Courses
SSAS Tabular - Wrexham SQL Server Analysis Services Training Courses
JavaScript Wrexham Training Courses
Power Query Wrexham Training Courses
SSIS - Wrexham SQL Server Integration Services Training Courses
DAX - Wrexham Excel Training Courses
JQuery Mobile Wrexham Training Courses