ACCESS TRAINING COURSES YOEVIL
About Enable Technology Yoevil Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver Access training courses onsite at your premises. The Access course could also be scheduled at a socially distanced site near you in Yoevil. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Unipart Group, Homeserve PLC, Nuclear Engineering Services, Carillion PLC, Birmingham City Council, Birmingham City University, Norwich Union PLC and Cadbury PLC.
Microsoft Access
- 2 day course
- Location: Yoevil
- 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 ... DIY Forms
- See Training Course Details...
Modifying Forms
An Introduction to VBA
Creating a Lookup Database
Action Queries
Setting Table Relationships
Navigation Pane Protection
Data Validation
Sorting and Filtering
Creating a Relational Database
Designing a Lookup Database
Understanding VBA
Macro Techniques
Querying Techniques
Using a Navigation Form
Macros on Forms
Creating Queries
Creating and Using Forms
Aggregation Queries
Formatting Tables
Parameter Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Yoevil
- 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 ... Writing an Error-Handling Routine
- See Training Course Details...
Understanding VBA's Error Trapping Options
Declaring and Creating Object Variables
Specifying a Recordset Cursor Type
Understanding Objects
Working with Variable Scope
Using Input Boxes
Understanding the DoCmd Object
Using the If...End If Decision Structures
Working with Events
Using the For...Next Structure
Using the Select Case...End Select Structure
Working with the Code Editor
Understanding Constants
Using Intrinsic Functions
Using Break Mode during Run Mode
Using the For Each...Next Structure
Understanding Procedures
Working with Variable Lifetime
Email us about this courses
Other Yoevil Enable Technology Training Courses
JQuery - Yoevil JavaScript Training Courses
JQuery Mobile - Yoevil JavaScript Training Courses
Power Query - Yoevil Excel Training Courses
SSAS Yoevil Training Courses
JavaScript Yoevil Training Courses
SSRS - Yoevil SQL Server Reporting Services Training Courses