ACCESS TRAINING COURSES BATH
About Enable Technology Bath Access Training Courses
We have a twenty year history of providing skills based Access industry training. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training Access resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Bath. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Royal Air Force, Nationwide Building Society Limited, Queen's Medical Centre Nottingham, South Staffordshire Water PLC, Birmingham Heartlands Hospital, Nuclear Engineering Services, Barclays Bank PLC and Dollond & Aitchison Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bath
- 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 ... Organizing Code and Procedures
- See Training Course Details...
Declaring Variables
Using the CacheSize Property - Optional
Setting Break Expressions
Working with Inline Error Handling
Using Expressions, Variables, and Intrinsic Functions
Stepping through Code
Using the For...Next Structure
Understanding Errors
Considering Variable Scope and Lifetime Together
Trapping Errors with the On Error Statement
Understanding VBA's Error Trapping Options
Working with the Code Editor
Understanding the Development Environment
Using Intrinsic Constants
Using the Do...Loop Structure
Understanding Modules
Understanding Expressions and Statements
Working with Events
Microsoft Access
- 2 day course
- Location: Bath
- 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 ... Designing a Lookup Database
- See Training Course Details...
Adding Transactional Records
Data Validation
Sorting and Filtering
Action Queries
Modifying Forms
Aggregation Queries
Creating and Using Macros
Querying Techniques
Creating Queries
Relational Database Design
An Introduction to VBA
Setting Table Relationships
Using a Navigation Form
Modifying Table Structures
Macro Techniques
Calculations in Queries
Database Wellness
Creating a Lookup Database
DIY Forms
Working With Records
Email us about this courses
Other Bath Enable Technology Training Courses
SSAS Tabular Bath Training Courses
SSRS Bath Training Courses
Excel 365 Basic - Bath Excel Training Courses
Excel 365 Advanced Bath Training Courses
Report Builder Bath Training Courses
Excel Power Pivot Bath Training Courses