ACCESS TRAINING COURSES BURTON ON TRENT
About Enable Technology Burton On Trent Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The training will be delivered by a Microsoft professional with development experience. We provide every candidate with Access training materials which they keep after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local venue in Burton On Trent. Every Access course can be modified to meet your bespoke requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
Our teaching team have over twenty years continuous technical training experience. Our clients include: University of Birmingham, Halfords Group PLC, National Power PLC, Dollond & Aitchison Limited, EDF Energy PLC, GKN PLC, Norwich Union PLC and Carillion PLC.
Microsoft Access
- 2 day course
- Location: Burton On Trent
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Modifying Table Structures
- See Training Course Details...
Creating a Lookup Database
Creating a Relational Database
Multi Table Queries
Sorting and Filtering
DIY Forms
Adding Transactional Records
Creating and Using Macros
Calculations in Queries
Querying Techniques
Adding Records to a Table
Data Validation
Working With Records
Creating and Using Forms
Creating Queries
Database Security
Database Wellness
Formatting Tables
Using a Navigation Form
Parameter Queries
Getting to Know Access
Microsoft Access Programming Using VBA
- 3 day course
- Location: Burton On Trent
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding Data Types
- See Training Course Details...
Specifying a Recordset Cursor Type
Working with the Application Object
Understanding the Order of Events
Working with Variable Scope
Understanding the DoCmd Object
Declaring Variables
Organizing Code and Procedures
Using the Immediate Window to Call Procedures
Using Break Mode during Run Mode
Understanding Expressions and Statements
Working with the Code Editor
Using Intrinsic Functions
Working with the ADODB Recordset Object
Using the Object Browser
Navigating the Access Object Hierarchy
Creating a Function Procedure
Naming Procedures
Declaring and Creating Object Variables
Email us about this courses
Other Burton On Trent Enable Technology Training Courses
JQuery Mobile Burton On Trent Training Courses
JavaScript - Burton On Trent JavaScript Training Courses
DAX - Burton On Trent Excel Training Courses
Excel 365 Intermediate - Burton On Trent Excel Training Courses
PL/SQL - Burton On Trent SQL Training Courses
Excel 365 Advanced Burton On Trent Training Courses