ACCESS TRAINING COURSES DEWSBURY
About Enable Technology Dewsbury Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training Access resources which they can continue to use after the training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a venue near you in Dewsbury. All Access courses can be customised to meet your particular 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 Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Loughborough University, Capita Group PLC, South Staffordshire Water PLC, University of Birmingham, Wolverhampton City Council, Keele University, Birmingham City Council and Queen's Medical Centre Nottingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dewsbury
- 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 ... Handling Errors
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Using the Immediate Window to Call Procedures
Understanding Classes and Objects
Naming Procedures
Calling Procedures
Determining the Value of Expressions
Working with Variable Lifetime
Declaring and Creating Object Variables
Working with Events
Guidelines for use of Branching Structures
Stepping through Code
Understanding Data Types
Considering Variable Scope and Lifetime Together
Using the Object Browser
Using the If...End If Decision Structures
Using Intrinsic Functions
Trapping Errors with the On Error Statement
Using Visual Basic Help
Understanding the Err Object
Understanding Control-of-Flow Structures
Microsoft Access
- 2 day course
- Location: Dewsbury
- 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 a Lookup Database
- See Training Course Details...
Creating and Using Forms
Creating Queries
Understanding VBA
Formatting Tables
Calculations in Queries
Database Security
Creating and Using Macros
Data Validation
Action Queries
Navigation Pane Protection
Using a Navigation Form
Parameter Queries
Working With Records
Creating and Using Reports
Sorting and Filtering
Querying Techniques
Modifying Forms
Setting Table Relationships
Macros on Forms
Multi Table Queries
Email us about this courses
Other Dewsbury Enable Technology Training Courses
Excel 365 Advanced Dewsbury Training Courses
SQL - Dewsbury SQL Training Courses
SSAS Tabular - Dewsbury SQL Server Analysis Services Training Courses
Report Builder - Dewsbury SQL Server Reporting Services Training Courses
JQuery - Dewsbury JavaScript Training Courses
Oracle SQL Dewsbury Training Courses