ACCESS TRAINING COURSES STOURBRIDGE
About Enable Technology Stourbridge Access Training Courses
We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We provide every candidate with Access training materials which they keep after the course. 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.
Access courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver Access training courses onsite at your premises. We can also deliver the Access course at a socially distanced local training venue in Stourbridge. We are happy to discuss customising the course content should you have particular Access training requirements.
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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Halfords Group PLC, Norwich Union PLC, Homeserve PLC, Canadian High Commission, Lloyds TSB Bank PLC, Fujistu PLC, DHL Express and University of Birmingham.
Microsoft Access
- 2 day course
- Location: Stourbridge
- 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 ... Action Queries
- See Training Course Details...
Getting to Know Access
Macros on Forms
Working With Records
Adding Transactional Records
Querying Techniques
Sorting and Filtering
Importing and Exporting Records
Aggregation Queries
Creating a Relational Database
Creating Queries
Data Validation
Modifying Table Structures
Database Wellness
Database Security
An Introduction to VBA
Relational Database Design
Multi Table Queries
Macro Techniques
Modifying Forms
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stourbridge
- 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 ... Introduction to Programming in Access
- See Training Course Details...
Declaring Variables
Controlling Program Execution
Understanding Expressions and Statements
Determining the Value of Expressions
Organizing Code and Procedures
Using Input Boxes
Using the For...Next Structure
Understanding Modules
Stepping through Code
Creating a Function Procedure
Working with Recordsets
Locking Records for Updating
Considering Variable Scope and Lifetime Together
Using the CacheSize Property - Optional
Working with Events
Creating a Standard Module
Using Intrinsic Functions
Using the For Each...Next Structure
Email us about this courses
Other Stourbridge Enable Technology Training Courses
Excel Power Pivot - Stourbridge Excel Training Courses
Excel 365 Basic Stourbridge Training Courses
Data Warehouse Stourbridge Training Courses
SSIS Stourbridge Training Courses
JQuery Mobile - Stourbridge JavaScript Training Courses
SSAS Stourbridge Training Courses