ACCESS TRAINING COURSES DORSET
About Enable Technology Dorset Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor delivering the course will be a Microsoft certified 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. We are also more than happy to organise a local course at a socially distanced training location in Dorset. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Royal Air Force, South Staffordshire Water PLC, Halfords Group PLC, Cadbury PLC, Countrywide Homes Limited, National Power PLC, Canadian High Commission and Barclays Bank PLC.
Microsoft Access
- 2 day course
- Location: Dorset
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Formatting Tables
- See Training Course Details...
Creating Queries
Parameter Queries
Setting Table Relationships
Creating and Using Macros
Multi Table Queries
Adding Transactional Records
Relational Database Design
Getting to Know Access
Querying Techniques
Understanding VBA
Modifying Table Structures
Sorting and Filtering
Macros on Forms
Navigation Pane Protection
Calculations in Queries
Creating a Lookup Database
Creating a Relational Database
Aggregation Queries
Working With Records
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dorset
- 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 ... Considering Variable Scope and Lifetime Together
- See Training Course Details...
Using the CacheSize Property - Optional
Using Intrinsic Functions
Using Break Mode during Run Mode
Using the Select Case...End Select Structure
Understanding Classes and Objects
Understanding Control-of-Flow Structures
Working with Events
Understanding the Order of Events
Understanding Constants
Working with the Application Object
Understanding the Err Object
Using Message Boxes
Setting Breakpoints
Calling Procedures
Setting Break Expressions
Using the Do...Loop Structure
Working with the ADODB Recordset Object
Using Visual Basic Help
Email us about this courses
Other Dorset Enable Technology Training Courses
TSQL - Dorset SQL Training Courses
Excel 365 Basic - Dorset Excel Training Courses
SSAS Tabular - Dorset SQL Server Analysis Services Training Courses
Power BI Dorset Training Courses
PL/SQL - Dorset SQL Training Courses
JQuery Mobile - Dorset JavaScript Training Courses