ACCESS TRAINING COURSES REDDITCH
About Enable Technology Redditch Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. 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.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We are set up to deliver Access training courses onsite at your premises. If you prefer we can offer an offsite training location in Redditch. 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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are West Bromwich Building Society, GKN PLC, Cadbury PLC, Capita Group PLC, Fujistu PLC, Boots UK Limited, Queen's Medical Centre Nottingham and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Redditch
- 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 Debugging Tools
- See Training Course Details...
Understanding the DoCmd Object
Understanding the Form Object
Using Message Boxes
Specifying a Recordset Cursor Type
Calling Procedures
Working with Inline Error Handling
Declaring and Creating Object Variables
Understanding the Err Object
Understanding Objects
Creating a Function Procedure
Working with Procedures and Functions
Locking Records for Updating
Working with the Code Editor
Writing an Error-Handling Routine
Using the Do...Loop Structure
Using the With Statement
Setting Breakpoints
Working with Recordsets
Microsoft Access
- 2 day course
- Location: Redditch
- 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 ... Designing a Lookup Database
- See Training Course Details...
Calculations in Queries
Working With Records
Getting to Know Access
Creating a Lookup Database
Adding Transactional Records
An Introduction to VBA
Formatting Tables
Using a Navigation Form
Database Security
Querying Techniques
Creating and Using Reports
Navigation Pane Protection
Modifying Forms
Adding Records to a Table
DIY Forms
Parameter Queries
Creating and Using Forms
Relational Database Design
Creating a Relational Database
Action Queries
Email us about this courses
Other Redditch Enable Technology Training Courses
SSRS Redditch Training Courses
Excel Power Pivot Redditch Training Courses
PL/SQL Redditch Training Courses
VBA Redditch Training Courses
DAX - Redditch Excel Training Courses
Report Builder Redditch Training Courses