ACCESS TRAINING COURSES LEEDS
About Enable Technology Leeds Access Training Courses
Enable Technology offer short intensive skills based Access training courses. 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. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We are set up to deliver Access training courses onsite at your premises. We also offer the option of scheduling of Access course at a socially distanced venue near you in Leeds. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: GKN PLC, Boots UK Limited, Loughborough University, Cadbury PLC, Barclays Bank PLC, Homeserve PLC, TalkTalk Direct Limited and Dollond & Aitchison Limited.
Microsoft Access
- 2 day course
- Location: Leeds
- 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 ... Creating and Using Forms
- See Training Course Details...
Database Security
Calculations in Queries
Navigation Pane Protection
DIY Forms
Database Wellness
Importing and Exporting Records
Getting to Know Access
Creating a Relational Database
Macros on Forms
Modifying Table Structures
Formatting Tables
Understanding VBA
Adding Records to a Table
Relational Database Design
Modifying Forms
Working With Records
Multi Table Queries
An Introduction to VBA
Creating and Using Reports
Setting Table Relationships
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leeds
- 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 ... Using Break Mode during Run Mode
- See Training Course Details...
Working with Properties
Naming Procedures
Using the For Each...Next Structure
Understanding Classes and Objects
Locking Records for Updating
Specifying a Recordset Cursor Location - Optional
Working with Procedures and Functions
Setting Break Expressions
Specifying a Recordset Cursor Type
Using Visual Basic Help
Working with the ADODB Recordset Object
Calling Procedures
Guidelines for use of Branching Structures
Working with Recordsets
Trapping Errors with the On Error Statement
Stepping through Code
Using the For...Next Structure
Understanding Constants
Using Input Boxes
Creating a Standard Module
Email us about this courses
Other Leeds Enable Technology Training Courses
Data Warehouse Leeds Training Courses
Excel 365 Basic - Leeds Excel Training Courses
SSAS Leeds Training Courses
JQuery - Leeds JavaScript Training Courses
JQuery Mobile Leeds Training Courses
DAX Leeds Training Courses