ACCESS TRAINING COURSES GRIMSBY
About Enable Technology Grimsby Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. The Access course could also be scheduled at a socially distanced site near you in Grimsby. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are National Power PLC, Birmingham City Council, Lloyds TSB Bank PLC, Birmingham Heartlands Hospital, Halfords Group PLC, GKN PLC, Nationwide Building Society Limited and Homeserve PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Grimsby
- 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 ... Why Program in Access?
- See Training Course Details...
Controlling Program Execution
Understanding Collections
Working with Recordsets
Using Debugging Tools
Working with the ADODB Recordset Object
Using the If...End If Decision Structures
Working with Procedures and Functions
Using Break Mode during Run Mode
Using the For...Next Structure
Handling Errors
Understanding Error Handling
Setting Break Expressions
Understanding VBA's Error Trapping Options
Working with the Code Editor
Locking Records for Updating
Using Message Boxes
Using the With Statement
Working with Methods
Microsoft Access
- 2 day course
- Location: Grimsby
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Creating and Using Reports
- See Training Course Details...
Database Wellness
Working With Records
Sorting and Filtering
Importing and Exporting Records
Adding Transactional Records
Getting to Know Access
Creating a Relational Database
Using a Navigation Form
Multi Table Queries
Navigation Pane Protection
An Introduction to VBA
Modifying Table Structures
Creating Queries
Creating and Using Forms
Parameter Queries
Creating and Using Macros
Adding Records to a Table
Macros on Forms
Database Security
Modifying Forms
Email us about this courses
Other Grimsby Enable Technology Training Courses
JavaScript - Grimsby JavaScript Training Courses
VBA - Grimsby Excel Training Courses
Oracle SQL - Grimsby SQL Training Courses
PL/SQL Grimsby Training Courses
Excel 365 Advanced Grimsby Training Courses
DAX - Grimsby Excel Training Courses