ACCESS TRAINING COURSES BOURNEMOUTH
About Enable Technology Bournemouth Access Training Courses
We offer intensive two and three days Access courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and Access course resources that can be referenced post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Access courses are taught by a Microsoft Certified Solutions Expert. 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. We can also deliver the Access course at a socially distanced local training venue in Bournemouth. Every Access course can be modified to meet your bespoke requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Norwich Union PLC, EDF Energy PLC, Boots UK Limited, Cadbury PLC, Total Telecommunications Limited, Birmingham City University, Homeserve PLC and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bournemouth
- 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 ... Using the For...Next Structure
- See Training Course Details...
Understanding the Order of Events
Understanding Constants
Understanding Errors
Using the Immediate Window to Call Procedures
Using the CacheSize Property - Optional
Setting Break Expressions
Working with Recordsets
Using Visual Basic Help
Understanding the Err Object
Setting Breakpoints
Understanding Control-of-Flow Structures
Declaring Variables
Using Break Mode during Run Mode
Working with the Application Object
Working with Methods
Understanding VBA's Error Trapping Options
Using the Object Browser
Using the If...End If Decision Structures
Microsoft Access
- 2 day course
- Location: Bournemouth
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Creating a Lookup Database
- See Training Course Details...
Sorting and Filtering
Creating and Using Reports
Navigation Pane Protection
Creating Queries
Designing a Lookup Database
An Introduction to VBA
Working With Records
Modifying Forms
Data Validation
Importing and Exporting Records
Setting Table Relationships
Relational Database Design
Querying Techniques
Creating and Using Macros
Formatting Tables
Creating a Relational Database
Multi Table Queries
Macro Techniques
Using a Navigation Form
Adding Transactional Records
Email us about this courses
Other Bournemouth Enable Technology Training Courses
JQuery Mobile Bournemouth Training Courses
PL/SQL Bournemouth Training Courses
JavaScript - Bournemouth JavaScript Training Courses
SSAS Tabular - Bournemouth SQL Server Analysis Services Training Courses
SSAS - Bournemouth SQL Server Analysis Services Training Courses
SSRS - Bournemouth SQL Server Reporting Services Training Courses