ACCESS TRAINING COURSES DEWSBURY
About Enable Technology Dewsbury Access Training Courses
We have a twenty year history of providing skills based Access industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We will issue each Access training participant with learning resources which they can refer to post training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Dewsbury. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Barclays Bank PLC, Loughborough University, Aston University, Fujistu PLC, Boots UK Limited, South Staffordshire Water PLC, Keele University and Canadian High Commission.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dewsbury
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding the Form Object
- See Training Course Details...
Using Intrinsic Functions
Working with Inline Error Handling
Specifying a Recordset Cursor Type
Naming Procedures
Working with the Application Object
Declaring and Creating Object Variables
Understanding the Development Environment
Understanding the Order of Events
Writing an Error-Handling Routine
Specifying a Recordset Cursor Location - Optional
Using the Do...Loop Structure
Working with the Code Editor
Locking Records for Updating
Working with Variable Lifetime
Understanding Data Types
Setting Breakpoints
Microsoft Access
- 2 day course
- Location: Dewsbury
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Working With Records
- See Training Course Details...
DIY Forms
Setting Table Relationships
Creating and Using Reports
Macro Techniques
Understanding VBA
Database Wellness
Sorting and Filtering
Formatting Tables
Action Queries
Getting to Know Access
Calculations in Queries
Creating a Lookup Database
Data Validation
Adding Records to a Table
Creating and Using Macros
Parameter Queries
Importing and Exporting Records
Relational Database Design
Querying Techniques
Multi Table Queries
Email us about this courses
Other Dewsbury Enable Technology Training Courses
SQL Dewsbury Training Courses
Excel 365 Intermediate - Dewsbury Excel Training Courses
Excel Power Pivot Dewsbury Training Courses
JQuery Dewsbury Training Courses
DAX - Dewsbury Excel Training Courses
Excel 365 Advanced Dewsbury Training Courses