ACCESS TRAINING COURSES BOLTON
About Enable Technology Bolton Access Training Courses
We are a company that provides short intensive Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each course participant will be issued with training Access resources which they can continue to use 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.
Enable Technology training courses are delivered as instructor led courses. We are set up to deliver Access training courses onsite at your premises. Another way we could deliver the Access course is at a local socially distanced training site. All Access courses can be customised to meet your particular 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Royal Air Force, Queen's Medical Centre Nottingham, DHL Express, TalkTalk Direct Limited, Nationwide Building Society Limited, GKN PLC, Boots UK Limited and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Bolton
- 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 ... Multi Table Queries
- See Training Course Details...
Setting Table Relationships
Querying Techniques
Parameter Queries
Designing a Lookup Database
An Introduction to VBA
Working With Records
Creating Queries
Data Validation
Aggregation Queries
Database Wellness
Creating and Using Macros
Macro Techniques
Adding Transactional Records
Macros on Forms
Importing and Exporting Records
Calculations in Queries
Creating a Lookup Database
Adding Records to a Table
Navigation Pane Protection
Sorting and Filtering
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bolton
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Setting Breakpoints
- See Training Course Details...
Why Program in Access?
Using the Object Browser
Understanding Expressions and Statements
Understanding the DoCmd Object
Naming Procedures
Understanding the Order of Events
Working with Procedures and Functions
Working with Variable Lifetime
Using Input Boxes
Handling Errors
Calling Procedures
Setting Break Expressions
Understanding Procedures
Using Break Mode during Run Mode
Considering Variable Scope and Lifetime Together
Working with Inline Error Handling
Understanding Modules
Understanding the Err Object
Email us about this courses
Other Bolton Enable Technology Training Courses
DAX - Bolton Excel Training Courses
SSAS Bolton Training Courses
PL/SQL Bolton Training Courses
SSAS Tabular - Bolton SQL Server Analysis Services Training Courses
VBA Bolton Training Courses
Data Warehouse - Bolton SQL Training Courses