ACCESS TRAINING COURSES STAFFORD
About Enable Technology Stafford Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All Enable Technology tutors are Microsoft certified experts. All course participants are issued Access training manuals they can refer to after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The Access course could also be scheduled at a socially distanced site near you in Stafford. We will work with you prior to the course to tailor the Access syllabus to match your 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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Birmingham City University, University of Birmingham, Vodafone Group Services, Lloyds TSB Bank PLC, Shell UK Oil Products Ltd, Dollond & Aitchison Limited, Yell Group PLC and Carillion PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stafford
- 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 the ADODB Recordset Object
- See Training Course Details...
Understanding Control-of-Flow Structures
Using the CacheSize Property - Optional
Trapping Errors with the On Error Statement
Organizing Code and Procedures
Setting Breakpoints
Understanding Error Handling
Debugging Code
Using the For Each...Next Structure
Using Visual Basic Help
Declaring Variables
Using the Immediate Window to Call Procedures
Understanding Procedures
Using Break Mode during Run Mode
Understanding Expressions and Statements
Working with Inline Error Handling
Handling Errors
Working with Boolean Expressions
Understanding Classes and Objects
Why Program in Access?
Microsoft Access
- 2 day course
- Location: Stafford
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Creating and Using Forms
- See Training Course Details...
Calculations in Queries
Data Validation
Setting Table Relationships
Database Security
Modifying Table Structures
Action Queries
Formatting Tables
Adding Records to a Table
Creating a Relational Database
Understanding VBA
Creating a Lookup Database
Modifying Forms
Getting to Know Access
Creating and Using Reports
Importing and Exporting Records
Using a Navigation Form
Creating Queries
Working With Records
Querying Techniques
Designing a Lookup Database
Email us about this courses
Other Stafford Enable Technology Training Courses
Excel Power Pivot - Stafford Excel Training Courses
VBA - Stafford Excel Training Courses
Data Warehouse Stafford Training Courses
JavaScript Stafford Training Courses
SSIS Stafford Training Courses
JQuery Mobile Stafford Training Courses