ACCESS TRAINING COURSES BLACKBURN
About Enable Technology Blackburn Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Blackburn. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Carillion PLC, DHL Express, Halfords Group PLC, Nationwide Building Society Limited, Keele University, Cadbury PLC, Boots UK Limited and EDF Energy PLC.
Microsoft Access
- 2 day course
- Location: Blackburn
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Adding Transactional Records
- See Training Course Details...
An Introduction to VBA
Creating Queries
Macro Techniques
Getting to Know Access
Parameter Queries
Navigation Pane Protection
Multi Table Queries
Data Validation
Creating a Relational Database
Macros on Forms
Understanding VBA
Database Wellness
Aggregation Queries
Designing a Lookup Database
Using a Navigation Form
Calculations in Queries
Modifying Table Structures
Creating and Using Reports
Adding Records to a Table
Database Security
Microsoft Access Programming Using VBA
- 3 day course
- Location: Blackburn
- 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 ... Using Visual Basic Help
- See Training Course Details...
Creating a Standard Module
Working with Variable Scope
Writing an Error-Handling Routine
Navigating the Access Object Hierarchy
Declaring Variables
Declaring and Creating Object Variables
Debugging Code
Working with Methods
Understanding the Err Object
Using Intrinsic Constants
Using the Object Browser
Using Input Boxes
Understanding Collections
Creating a Function Procedure
Setting Break Expressions
Using the CacheSize Property - Optional
Locking Records for Updating
Email us about this courses
Other Blackburn Enable Technology Training Courses
JQuery Mobile - Blackburn JavaScript Training Courses
Data Warehouse - Blackburn SQL Training Courses
Excel 365 Basic Blackburn Training Courses
Excel Power Pivot - Blackburn Excel Training Courses
Excel 365 Intermediate - Blackburn Excel Training Courses
SSRS - Blackburn SQL Server Reporting Services Training Courses