ACCESS TRAINING COURSES TAMWORTH
About Enable Technology Tamworth Access Training Courses
We are a company that provides short intensive Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the 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.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a venue near you in Tamworth. Every Access course can be modified to meet your bespoke 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 had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are TalkTalk Direct Limited, Royal & Sun Alliance Group PLC, Birmingham City University, Capita Group PLC, Norfolk Police Constabulary, South Staffordshire Water PLC, National Power PLC and West Bromwich Building Society.
Microsoft Access
- 2 day course
- Location: Tamworth
- 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 ... Database Security
- See Training Course Details...
Aggregation Queries
Importing and Exporting Records
DIY Forms
Working With Records
Creating and Using Forms
Getting to Know Access
Using a Navigation Form
Macro Techniques
An Introduction to VBA
Navigation Pane Protection
Querying Techniques
Multi Table Queries
Designing a Lookup Database
Formatting Tables
Setting Table Relationships
Creating and Using Reports
Adding Transactional Records
Parameter Queries
Creating and Using Macros
Modifying Table Structures
Microsoft Access Programming Using VBA
- 3 day course
- Location: Tamworth
- 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 Input Boxes
- See Training Course Details...
Declaring and Creating Object Variables
Using Intrinsic Constants
Introduction to Programming in Access
Understanding Classes and Objects
Using Debugging Tools
Understanding the Err Object
Creating a Function Procedure
Using Message Boxes
Guidelines for use of Branching Structures
Writing an Error-Handling Routine
Working with Variable Lifetime
Setting Break Expressions
Understanding Objects
Understanding Procedures
Understanding Constants
Locking Records for Updating
Understanding Recordset Cursor Properties - Optional
Working with the ADODB Recordset Object
Email us about this courses
Other Tamworth Enable Technology Training Courses
Excel 365 Advanced Tamworth Training Courses
Report Builder - Tamworth SQL Server Reporting Services Training Courses
Power Query Tamworth Training Courses
JavaScript - Tamworth JavaScript Training Courses
SSAS Tamworth Training Courses
SSRS Tamworth Training Courses