ACCESS TRAINING COURSES SHREWSBURY
About Enable Technology Shrewsbury Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver Access courses at your site. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to discuss customising the course content should you have particular Access training requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Lloyds TSB Bank PLC, Halfords Group PLC, Nuclear Engineering Services, Birmingham City University, GKN PLC, Queen's Medical Centre Nottingham, Homeserve PLC and Unipart Group.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Shrewsbury
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Using Visual Basic Help
- See Training Course Details...
Working with the Code Editor
Why Program in Access?
Writing an Error-Handling Routine
Understanding VBA's Error Trapping Options
Understanding the Err Object
Working with the ADODB Recordset Object
Working with Boolean Expressions
Using the Object Browser
Controlling Program Execution
Understanding the Order of Events
Using Debugging Tools
Using Expressions, Variables, and Intrinsic Functions
Introduction to Programming in Access
Declaring and Creating Object Variables
Using the Select Case...End Select Structure
Guidelines for use of Branching Structures
Using Intrinsic Functions
Using the With Statement
Understanding Modules
Microsoft Access
- 2 day course
- Location: Shrewsbury
- 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 ... Navigation Pane Protection
- See Training Course Details...
Creating a Lookup Database
Understanding VBA
Aggregation Queries
Creating a Relational Database
Using a Navigation Form
Relational Database Design
Parameter Queries
Creating and Using Reports
Designing a Lookup Database
Macro Techniques
Importing and Exporting Records
Macros on Forms
Calculations in Queries
Adding Transactional Records
Formatting Tables
Creating and Using Macros
Modifying Table Structures
Database Wellness
DIY Forms
Querying Techniques
Email us about this courses
Other Shrewsbury Enable Technology Training Courses
Excel 365 Basic Shrewsbury Training Courses
JavaScript - Shrewsbury JavaScript Training Courses
JQuery Shrewsbury Training Courses
TSQL - Shrewsbury SQL Training Courses
Power BI Shrewsbury Training Courses
SSRS Shrewsbury Training Courses