ACCESS TRAINING COURSES TAUNTON
About Enable Technology Taunton Access Training Courses
We offer intensive two and three days Access courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local training site in Taunton. The Access syllabus can be modified to accommodate your specific training needs.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Birmingham Heartlands Hospital, Vodafone Group Services, Unipart Group, Yell Group PLC, TalkTalk Direct Limited, Queen's Medical Centre Nottingham, Barclays Bank PLC and Carillion PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Taunton
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Setting Breakpoints
- See Training Course Details...
Handling Errors
Using Intrinsic Functions
Using the Do...Loop Structure
Using the CacheSize Property - Optional
Working with the ADODB Recordset Object
Using the For...Next Structure
Working with Events
Understanding Classes and Objects
Working with Inline Error Handling
Using Input Boxes
Why Program in Access?
Creating a Function Procedure
Using the Object Browser
Navigating the Access Object Hierarchy
Debugging Code
Trapping Errors with the On Error Statement
Working with Boolean Expressions
Understanding Collections
Using the Select Case...End Select Structure
Microsoft Access
- 2 day course
- Location: Taunton
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Formatting Tables
- See Training Course Details...
Relational Database Design
Sorting and Filtering
DIY Forms
Modifying Table Structures
Data Validation
Creating and Using Macros
Modifying Forms
Getting to Know Access
Using a Navigation Form
Creating and Using Reports
Aggregation Queries
Multi Table Queries
Database Security
Setting Table Relationships
Working With Records
Adding Records to a Table
An Introduction to VBA
Creating a Relational Database
Adding Transactional Records
Creating Queries
Email us about this courses
Other Taunton Enable Technology Training Courses
SQL - Taunton SQL Training Courses
Power Query Taunton Training Courses
JavaScript Taunton Training Courses
PL/SQL - Taunton SQL Training Courses
Report Builder Taunton Training Courses
DAX - Taunton Excel Training Courses