ACCESS TRAINING COURSES DEVON
About Enable Technology Devon Access Training Courses
Enable Technology specialise in succinct skills based Access training. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
We provide instructor led training coupled with hands on training. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Devon. The Access syllabus can be adjusted and additional topics incorporated if helpful.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Aston University, Capita Group PLC, TalkTalk Direct Limited, Fujistu PLC, Nuclear Engineering Services, National Power PLC, Cadbury PLC and GKN PLC.
Microsoft Access
- 2 day course
- Location: Devon
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Creating and Using Reports
- See Training Course Details...
Creating a Relational Database
Querying Techniques
Creating Queries
Navigation Pane Protection
Database Security
Creating a Lookup Database
Database Wellness
Macros on Forms
Relational Database Design
Setting Table Relationships
Data Validation
Creating and Using Forms
Multi Table Queries
DIY Forms
Aggregation Queries
Creating and Using Macros
An Introduction to VBA
Macro Techniques
Calculations in Queries
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Devon
- 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 ... Working with Inline Error Handling
- See Training Course Details...
Navigating the Access Object Hierarchy
Guidelines for use of Branching Structures
Using Break Mode during Run Mode
Calling Procedures
Understanding Errors
Understanding Data Types
Working with Boolean Expressions
Handling Errors
Stepping through Code
Organizing Code and Procedures
Creating a Function Procedure
Writing an Error-Handling Routine
Introduction to Programming in Access
Controlling Program Execution
Working with Procedures and Functions
Working with Variable Lifetime
Using the For...Next Structure
Specifying a Recordset Cursor Type
Understanding Procedures
Email us about this courses
Other Devon Enable Technology Training Courses
VBA Devon Training Courses
DAX - Devon Excel Training Courses
SSAS - Devon SQL Server Analysis Services Training Courses
SSAS Tabular - Devon SQL Server Analysis Services Training Courses
PL/SQL - Devon SQL Training Courses
Excel 365 Intermediate Devon Training Courses