ACCESS TRAINING COURSES HEREFORDSHIRE
About Enable Technology Herefordshire Access Training Courses
We offer intensive two and three days Access courses. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We provide instructor led training coupled with hands on training. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another option is we can organise a local training site in Herefordshire. 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.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time 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: GKN PLC, Vodafone Group Services, South Staffordshire Water PLC, West Bromwich Building Society, Lloyds TSB Bank PLC, Aston University, Birmingham Heartlands Hospital and Royal Air Force.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Herefordshire
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding the Form Object
- See Training Course Details...
Declaring Variables
Using Intrinsic Constants
Using the If...End If Decision Structures
Understanding Errors
Understanding Collections
Using Debugging Tools
Locking Records for Updating
Understanding Data Types
Understanding VBA's Error Trapping Options
Using the Immediate Window to Call Procedures
Calling Procedures
Understanding Classes and Objects
Why Program in Access?
Working with Inline Error Handling
Introduction to Programming in Access
Using the CacheSize Property - Optional
Considering Variable Scope and Lifetime Together
Creating a Function Procedure
Working with the ADODB Recordset Object
Setting Breakpoints
Microsoft Access
- 2 day course
- Location: Herefordshire
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Creating a Lookup Database
- See Training Course Details...
Importing and Exporting Records
Understanding VBA
Action Queries
Modifying Table Structures
Navigation Pane Protection
Data Validation
Working With Records
Creating and Using Macros
Adding Records to a Table
Macros on Forms
Setting Table Relationships
Calculations in Queries
Relational Database Design
Formatting Tables
Designing a Lookup Database
Querying Techniques
Sorting and Filtering
Parameter Queries
Creating and Using Reports
Getting to Know Access
Email us about this courses
Other Herefordshire Enable Technology Training Courses
Excel 365 Basic Herefordshire Training Courses
JQuery Mobile - Herefordshire JavaScript Training Courses
SSAS Tabular - Herefordshire SQL Server Analysis Services Training Courses
Excel 365 Advanced Herefordshire Training Courses
PL/SQL Herefordshire Training Courses
Report Builder Herefordshire Training Courses