ACCESS TRAINING COURSES SCUNTHORPE
About Enable Technology Scunthorpe Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to after the course. 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 offers instructor led training taught by technology specialists. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another way we could deliver the Access course is at a local training site. 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 also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are West Bromwich Building Society, Countrywide Homes Limited, Unipart Group, National Power PLC, Norwich Union PLC, Norfolk Police Constabulary, Dollond & Aitchison Limited and GKN PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Scunthorpe
- 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 ... Trapping Errors with the On Error Statement
- See Training Course Details...
Understanding Control-of-Flow Structures
Understanding Procedures
Locking Records for Updating
Using the For Each...Next Structure
Understanding the Err Object
Working with Properties
Using Debugging Tools
Using the CacheSize Property - Optional
Handling Errors
Using the Object Browser
Using the If...End If Decision Structures
Working with Procedures and Functions
Understanding Errors
Understanding Collections
Setting Breakpoints
Understanding Recordset Cursor Properties - Optional
Understanding Error Handling
Why Program in Access?
Microsoft Access
- 2 day course
- Location: Scunthorpe
- 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 ... Calculations in Queries
- See Training Course Details...
Aggregation Queries
Creating and Using Reports
Data Validation
Sorting and Filtering
Database Security
Setting Table Relationships
Multi Table Queries
Adding Records to a Table
Macro Techniques
Importing and Exporting Records
Formatting Tables
DIY Forms
Understanding VBA
Modifying Table Structures
Action Queries
Designing a Lookup Database
Creating and Using Macros
Modifying Forms
Querying Techniques
Creating a Lookup Database
Email us about this courses
Other Scunthorpe Enable Technology Training Courses
SQL - Scunthorpe SQL Training Courses
Report Builder - Scunthorpe SQL Server Reporting Services Training Courses
Power Query - Scunthorpe Excel Training Courses
Oracle SQL Scunthorpe Training Courses
JQuery Scunthorpe Training Courses
Power BI Scunthorpe Training Courses