ACCESS TRAINING COURSES BATH
About Enable Technology Bath Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Access course at a socially distanced venue near you in Bath. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Royal Air Force, Nationwide Building Society Limited, Wolverhampton City Council, Dollond & Aitchison Limited, Barclays Bank PLC, Loughborough University, Shell UK Oil Products Ltd and GKN PLC.
Microsoft Access
- 2 day course
- Location: Bath
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Using a Navigation Form
- See Training Course Details...
Modifying Table Structures
Adding Records to a Table
Getting to Know Access
Creating and Using Macros
Calculations in Queries
Importing and Exporting Records
Relational Database Design
Database Security
Creating a Relational Database
An Introduction to VBA
Understanding VBA
Database Wellness
Designing a Lookup Database
Macro Techniques
Navigation Pane Protection
Sorting and Filtering
Data Validation
Working With Records
Creating and Using Reports
Adding Transactional Records
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 ... Working with the Application Object
- See Training Course Details...
Understanding the Err Object
Why Program in Access?
Setting Break Expressions
Using the For Each...Next Structure
Understanding Error Handling
Working with Procedures and Functions
Understanding Classes and Objects
Using the Select Case...End Select Structure
Understanding Expressions and Statements
Controlling Program Execution
Using the If...End If Decision Structures
Working with Properties
Introduction to Programming in Access
Declaring Variables
Working with Variable Scope
Understanding Constants
Understanding Data Types
Email us about this courses
Other Bath Enable Technology Training Courses
Excel 365 Intermediate Bath Training Courses
Oracle SQL Bath Training Courses
Excel 365 Advanced - Bath Excel Training Courses
Power Query Bath Training Courses
VBA - Bath Excel Training Courses
Data Warehouse Bath Training Courses