ACCESS TRAINING COURSES UTTOXETER
About Enable Technology Uttoxeter Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and Access course resources that can be referenced 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 specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another way we could deliver the Access course is at a local socially distanced training site. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
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. Our clients include: Keele University, Birmingham City University, Countrywide Homes Limited, Queen's Medical Centre Nottingham, South Staffordshire Water PLC, Norfolk Police Constabulary, Dollond & Aitchison Limited and Halfords Group PLC.
Microsoft Access
- 2 day course
- Location: Uttoxeter
- 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 ... Creating Queries
- See Training Course Details...
Database Security
An Introduction to VBA
Adding Records to a Table
Creating and Using Macros
Database Wellness
Parameter Queries
Setting Table Relationships
Navigation Pane Protection
Getting to Know Access
Understanding VBA
Macro Techniques
Data Validation
Querying Techniques
Creating a Lookup Database
DIY Forms
Multi Table Queries
Adding Transactional Records
Creating and Using Reports
Working With Records
Formatting Tables
Microsoft Access Programming Using VBA
- 3 day course
- Location: Uttoxeter
- 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 ... Using Visual Basic Help
- See Training Course Details...
Naming Procedures
Understanding the DoCmd Object
Using the For...Next Structure
Working with Methods
Working with the Code Editor
Using Intrinsic Functions
Introduction to Programming in Access
Understanding Error Handling
Using the If...End If Decision Structures
Understanding Objects
Understanding the Form Object
Understanding Data Types
Using the For Each...Next Structure
Understanding Classes and Objects
Creating a Sub Procedure
Working with the Application Object
Trapping Errors with the On Error Statement
Understanding Constants
Email us about this courses
Other Uttoxeter Enable Technology Training Courses
TSQL - Uttoxeter SQL Training Courses
Power BI Uttoxeter Training Courses
Data Warehouse - Uttoxeter SQL Training Courses
SQL - Uttoxeter SQL Training Courses
Power Query Uttoxeter Training Courses
JQuery Mobile - Uttoxeter JavaScript Training Courses