ACCESS TRAINING COURSES TAMWORTH
About Enable Technology Tamworth Access Training Courses
Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a socially distanced local training venue in Tamworth. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Nationwide Building Society Limited, University of Birmingham, Dollond & Aitchison Limited, Norwich Union PLC, Unipart Group, Cadbury PLC, Barclays Bank PLC and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Tamworth
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Creating and Using Forms
- See Training Course Details...
Setting Table Relationships
Data Validation
DIY Forms
Using a Navigation Form
Macros on Forms
Modifying Table Structures
Creating Queries
Understanding VBA
Relational Database Design
Multi Table Queries
An Introduction to VBA
Macro Techniques
Adding Transactional Records
Working With Records
Creating a Lookup Database
Sorting and Filtering
Database Wellness
Parameter Queries
Formatting Tables
Navigation Pane Protection
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 ... Understanding Classes and Objects
- See Training Course Details...
Working with Methods
Specifying a Recordset Cursor Type
Working with the Application Object
Using the Immediate Window to Call Procedures
Using Debugging Tools
Using the Object Browser
Using the With Statement
Navigating the Access Object Hierarchy
Understanding Expressions and Statements
Working with Boolean Expressions
Understanding VBA's Error Trapping Options
Writing an Error-Handling Routine
Understanding Constants
Understanding Procedures
Creating a Function Procedure
Using the CacheSize Property - Optional
Working with Recordsets
Email us about this courses
Other Tamworth Enable Technology Training Courses
Data Warehouse Tamworth Training Courses
JavaScript Tamworth Training Courses
Excel Power Pivot Tamworth Training Courses
VBA Tamworth Training Courses
Report Builder Tamworth Training Courses
Power BI Tamworth Training Courses