ACCESS TRAINING COURSES EXETER
About Enable Technology Exeter Access Training Courses
Enable Technology provides practical Access skills based technology training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We are also more than happy to organise a local course at a socially distanced training location in Exeter. 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.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Canadian High Commission, Cadbury PLC, Halfords Group PLC, Keele University, TalkTalk Direct Limited, Barclays Bank PLC, Royal & Sun Alliance Group PLC and EDF Energy PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Exeter
- 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 ... Declaring and Creating Object Variables
- See Training Course Details...
Creating a Sub Procedure
Understanding Procedures
Setting Break Expressions
Writing an Error-Handling Routine
Using the Select Case...End Select Structure
Using Message Boxes
Understanding the DoCmd Object
Stepping through Code
Understanding Data Types
Why Program in Access?
Specifying a Recordset Cursor Type
Understanding Control-of-Flow Structures
Using the Object Browser
Using the Immediate Window to Call Procedures
Using the CacheSize Property - Optional
Trapping Errors with the On Error Statement
Understanding Constants
Microsoft Access
- 2 day course
- Location: Exeter
- 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...
Creating Queries
Setting Table Relationships
Creating a Relational Database
Creating a Lookup Database
Using a Navigation Form
Macros on Forms
Getting to Know Access
Creating and Using Macros
Adding Records to a Table
Multi Table Queries
Action Queries
DIY Forms
Data Validation
Creating and Using Reports
Adding Transactional Records
Sorting and Filtering
Navigation Pane Protection
Aggregation Queries
Designing a Lookup Database
Creating and Using Forms
Email us about this courses
Other Exeter Enable Technology Training Courses
SSRS Exeter Training Courses
Excel 365 Advanced Exeter Training Courses
DAX - Exeter Excel Training Courses
PL/SQL - Exeter SQL Training Courses
Data Warehouse Exeter Training Courses
Excel 365 Intermediate Exeter Training Courses