ACCESS TRAINING COURSES WIGAN
About Enable Technology Wigan Access Training Courses
Enable Technology specialise in succinct skills based Access training. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite socially distanced training location in Wigan. All Access courses can be customised to meet your particular requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: West Bromwich Building Society, Norwich Union PLC, Carillion PLC, Capita Group PLC, Fujistu PLC, Canadian High Commission, Shell UK Oil Products Ltd and Aston University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wigan
- 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 ... Understanding Modules
- See Training Course Details...
Writing an Error-Handling Routine
Working with Variable Lifetime
Trapping Errors with the On Error Statement
Setting Breakpoints
Understanding the Development Environment
Understanding Procedures
Using Debugging Tools
Using the For...Next Structure
Understanding VBA's Error Trapping Options
Declaring and Creating Object Variables
Working with Recordsets
Using the Do...Loop Structure
Working with Variable Scope
Using Expressions, Variables, and Intrinsic Functions
Specifying a Recordset Cursor Type
Understanding the DoCmd Object
Locking Records for Updating
Navigating the Access Object Hierarchy
Understanding the Order of Events
Microsoft Access
- 2 day course
- Location: Wigan
- 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 ... Creating and Using Macros
- See Training Course Details...
DIY Forms
Macros on Forms
Multi Table Queries
Modifying Table Structures
Querying Techniques
Creating and Using Forms
Adding Records to a Table
Importing and Exporting Records
Creating a Lookup Database
Setting Table Relationships
Getting to Know Access
Aggregation Queries
Action Queries
An Introduction to VBA
Parameter Queries
Creating and Using Reports
Database Security
Calculations in Queries
Creating Queries
Using a Navigation Form
Email us about this courses
Other Wigan Enable Technology Training Courses
Excel 365 Basic - Wigan Excel Training Courses
SSRS - Wigan SQL Server Reporting Services Training Courses
Oracle SQL - Wigan SQL Training Courses
Excel 365 Advanced - Wigan Excel Training Courses
SQL - Wigan SQL Training Courses
JavaScript - Wigan JavaScript Training Courses