ACCESS TRAINING COURSES KIRKBY
About Enable Technology Kirkby Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a Access course will be provided with training materials and practice files to retain after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. We can also deliver the Access course at a local training venue in Kirkby. Every Access course can be modified to meet your bespoke requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are National Power PLC, Carillion PLC, Birmingham City Council, Keele University, Nuclear Engineering Services, Homeserve PLC, Lloyds TSB Bank PLC and Unipart Group.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Kirkby
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Working with Recordsets
- See Training Course Details...
Declaring and Creating Object Variables
Working with Variable Scope
Working with Variable Lifetime
Using the Do...Loop Structure
Understanding Recordset Cursor Properties - Optional
Using the Select Case...End Select Structure
Using the Object Browser
Using the For Each...Next Structure
Understanding the Form Object
Working with the Code Editor
Understanding Objects
Creating a Sub Procedure
Understanding Constants
Using Debugging Tools
Understanding Errors
Using the If...End If Decision Structures
Microsoft Access
- 2 day course
- Location: Kirkby
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Creating and Using Macros
- See Training Course Details...
Multi Table Queries
Using a Navigation Form
Calculations in Queries
Querying Techniques
Creating and Using Forms
Adding Records to a Table
Creating a Relational Database
Database Security
Parameter Queries
Action Queries
Sorting and Filtering
Setting Table Relationships
Creating and Using Reports
Navigation Pane Protection
Creating a Lookup Database
Designing a Lookup Database
An Introduction to VBA
Data Validation
Relational Database Design
DIY Forms
Email us about this courses
Other Kirkby Enable Technology Training Courses
Power BI Kirkby Training Courses
TSQL Kirkby Training Courses
JavaScript - Kirkby JavaScript Training Courses
Oracle SQL - Kirkby SQL Training Courses
Excel 365 Basic Kirkby Training Courses
Excel 365 Advanced - Kirkby Excel Training Courses