ACCESS TRAINING COURSES DENTON
About Enable Technology Denton Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor delivering the course will be a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use 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.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Denton. We are happy to modify the Access syllabus to match your teams training requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Carillion PLC, Birmingham Heartlands Hospital, Canadian High Commission, Norwich Union PLC, Shell UK Oil Products Ltd, Royal Air Force, Vodafone Group Services and Norfolk Police Constabulary.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Denton
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Why Program in Access?
- See Training Course Details...
Understanding the DoCmd Object
Understanding the Development Environment
Using the Do...Loop Structure
Working with the Application Object
Using the If...End If Decision Structures
Introduction to Programming in Access
Using the Select Case...End Select Structure
Using Debugging Tools
Understanding Collections
Using the For Each...Next Structure
Calling Procedures
Using Intrinsic Functions
Stepping through Code
Working with the ADODB Recordset Object
Locking Records for Updating
Creating a Standard Module
Guidelines for use of Branching Structures
Microsoft Access
- 2 day course
- Location: Denton
- 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 ... Querying Techniques
- See Training Course Details...
Relational Database Design
Multi Table Queries
Creating and Using Reports
Creating and Using Forms
Modifying Table Structures
Creating Queries
Formatting Tables
Action Queries
Data Validation
Adding Transactional Records
Aggregation Queries
Getting to Know Access
Importing and Exporting Records
Creating a Lookup Database
Designing a Lookup Database
An Introduction to VBA
Sorting and Filtering
Navigation Pane Protection
Creating a Relational Database
Creating and Using Macros
Email us about this courses
Other Denton Enable Technology Training Courses
SSAS - Denton SQL Server Analysis Services Training Courses
SSAS Tabular - Denton SQL Server Analysis Services Training Courses
SQL Denton Training Courses
Excel 365 Advanced Denton Training Courses
Report Builder Denton Training Courses
DAX - Denton Excel Training Courses