ACCESS TRAINING COURSES WOLVERHAMPTON
About Enable Technology Wolverhampton Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Enable Technology offers instructor led training taught by technology specialists. 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 can also deliver the Access course at a socially distanced local training venue in Wolverhampton. 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.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Dollond & Aitchison Limited, Keele University, Total Telecommunications Limited, Yell Group PLC, Cadbury PLC, EDF Energy PLC, Barclays Bank PLC and TalkTalk Direct Limited.
Microsoft Access
- 2 day course
- Location: Wolverhampton
- 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 ... Macro Techniques
- See Training Course Details...
Modifying Table Structures
Importing and Exporting Records
Database Wellness
Creating Queries
An Introduction to VBA
Macros on Forms
Creating a Lookup Database
DIY Forms
Adding Records to a Table
Using a Navigation Form
Querying Techniques
Creating a Relational Database
Modifying Forms
Understanding VBA
Aggregation Queries
Adding Transactional Records
Parameter Queries
Multi Table Queries
Data Validation
Creating and Using Macros
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wolverhampton
- 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 ... Controlling Program Execution
- See Training Course Details...
Working with Variable Lifetime
Declaring and Creating Object Variables
Using the Select Case...End Select Structure
Understanding Expressions and Statements
Understanding Error Handling
Working with Boolean Expressions
Declaring Variables
Working with Events
Handling Errors
Understanding the DoCmd Object
Introduction to Programming in Access
Working with Recordsets
Understanding Recordset Cursor Properties - Optional
Creating a Standard Module
Using the Object Browser
Writing an Error-Handling Routine
Understanding VBA's Error Trapping Options
Using the Do...Loop Structure
Specifying a Recordset Cursor Location - Optional
Email us about this courses
Other Wolverhampton Enable Technology Training Courses
SSRS Wolverhampton Training Courses
VBA Wolverhampton Training Courses
Data Warehouse Wolverhampton Training Courses
TSQL Wolverhampton Training Courses
Oracle SQL Wolverhampton Training Courses
JQuery Mobile - Wolverhampton JavaScript Training Courses