ACCESS TRAINING COURSES TAUNTON
About Enable Technology Taunton Access Training Courses
Enable Technology provides practical Access skills based technology training. The tutor delivering the course will be a Microsoft certified expert. We will issue each Access training participant with learning resources which they can refer to post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
We provide instructor led training coupled with hands on training. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We also offer the option of scheduling of Access course at a socially distanced venue near you in Taunton. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Capita Group PLC, Unipart Group, Birmingham City University, Shell UK Oil Products Ltd, Royal & Sun Alliance Group PLC, Norfolk Police Constabulary, South Staffordshire Water PLC and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Taunton
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Designing a Lookup Database
- See Training Course Details...
Getting to Know Access
Creating and Using Reports
Working With Records
Macro Techniques
DIY Forms
Using a Navigation Form
Calculations in Queries
Adding Records to a Table
Creating a Relational Database
Understanding VBA
Querying Techniques
Creating a Lookup Database
Data Validation
Adding Transactional Records
Creating Queries
Multi Table Queries
Setting Table Relationships
Modifying Forms
Formatting Tables
Creating and Using Macros
Microsoft Access Programming Using VBA
- 3 day course
- Location: Taunton
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Working with Recordsets
- See Training Course Details...
Understanding Constants
Specifying a Recordset Cursor Location - Optional
Understanding the DoCmd Object
Using the If...End If Decision Structures
Using the Immediate Window to Call Procedures
Handling Errors
Using the Object Browser
Naming Procedures
Organizing Code and Procedures
Setting Break Expressions
Creating a Function Procedure
Using the For...Next Structure
Using Message Boxes
Understanding Classes and Objects
Understanding VBA's Error Trapping Options
Working with Events
Guidelines for use of Branching Structures
Using Intrinsic Constants
Email us about this courses
Other Taunton Enable Technology Training Courses
PL/SQL - Taunton SQL Training Courses
JavaScript - Taunton JavaScript Training Courses
SQL Taunton Training Courses
Power BI Taunton Training Courses
Excel 365 Intermediate Taunton Training Courses
VBA - Taunton Excel Training Courses