ACCESS TRAINING COURSES NEWTOWN
About Enable Technology Newtown Access Training Courses
Enable Technology provides practical Access skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in Newtown. All Access courses can be customised to meet your particular requirements.
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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Keele University, Canadian High Commission, University of Birmingham, Loughborough University, Countrywide Homes Limited, GKN PLC, Total Telecommunications Limited and Capita Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newtown
- 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 ... Understanding Collections
- See Training Course Details...
Understanding Error Handling
Controlling Program Execution
Creating a Standard Module
Naming Procedures
Using the For...Next Structure
Using the Select Case...End Select Structure
Handling Errors
Using Debugging Tools
Using the Object Browser
Working with Procedures and Functions
Specifying a Recordset Cursor Location - Optional
Using the With Statement
Using Intrinsic Constants
Using the Immediate Window to Call Procedures
Specifying a Recordset Cursor Type
Setting Breakpoints
Guidelines for use of Branching Structures
Working with the Application Object
Microsoft Access
- 2 day course
- Location: Newtown
- 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 Reports
- See Training Course Details...
Getting to Know Access
An Introduction to VBA
Querying Techniques
Relational Database Design
Calculations in Queries
Designing a Lookup Database
Adding Records to a Table
Creating Queries
Setting Table Relationships
Importing and Exporting Records
Modifying Table Structures
Multi Table Queries
Modifying Forms
DIY Forms
Working With Records
Database Wellness
Understanding VBA
Creating and Using Macros
Macros on Forms
Sorting and Filtering
Email us about this courses
Other Newtown Enable Technology Training Courses
SSRS Newtown Training Courses
JQuery Newtown Training Courses
TSQL Newtown Training Courses
Data Warehouse Newtown Training Courses
JQuery Mobile - Newtown JavaScript Training Courses
Excel 365 Basic - Newtown Excel Training Courses