ACCESS TRAINING COURSES WIGAN
About Enable Technology Wigan Access Training Courses
Enable Technology provides practical Access skills based technology training. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of Access course at a venue near you in Wigan. 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.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Birmingham City Council, Norwich Union PLC, West Bromwich Building Society, Total Telecommunications Limited, Yell Group PLC, Norfolk Police Constabulary, Canadian High Commission and Carillion PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wigan
- 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 ... Declaring Variables
- See Training Course Details...
Setting Breakpoints
Introduction to Programming in Access
Understanding the Form Object
Using Message Boxes
Writing an Error-Handling Routine
Using the With Statement
Understanding Constants
Understanding the Development Environment
Using Intrinsic Functions
Using the Object Browser
Working with Properties
Creating a Sub Procedure
Determining the Value of Expressions
Understanding the Err Object
Working with Recordsets
Understanding Objects
Creating a Function Procedure
Understanding Recordset Cursor Properties - Optional
Working with the Application Object
Microsoft Access
- 2 day course
- Location: Wigan
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Modifying Forms
- See Training Course Details...
Macro Techniques
Creating a Relational Database
Setting Table Relationships
Adding Records to a Table
Navigation Pane Protection
An Introduction to VBA
Creating and Using Forms
Creating and Using Macros
Macros on Forms
Sorting and Filtering
Working With Records
Adding Transactional Records
Querying Techniques
Multi Table Queries
Getting to Know Access
Understanding VBA
Calculations in Queries
Modifying Table Structures
Relational Database Design
Importing and Exporting Records
Email us about this courses
Other Wigan Enable Technology Training Courses
SSIS Wigan Training Courses
SSAS Tabular - Wigan SQL Server Analysis Services Training Courses
SQL - Wigan SQL Training Courses
DAX - Wigan Excel Training Courses
Power BI Wigan Training Courses
Report Builder Wigan Training Courses