ACCESS TRAINING COURSES KIDDERMINSTER
About Enable Technology Kidderminster Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Courses are instructor led and groups sizes small. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We can also deliver the Access course at a socially distanced local training venue in Kidderminster. 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Capita Group PLC, West Bromwich Building Society, Birmingham City Council, Birmingham City University, Royal & Sun Alliance Group PLC, GKN PLC, South Staffordshire Water PLC and TalkTalk Direct Limited.
Microsoft Access
- 2 day course
- Location: Kidderminster
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Relational Database Design
- See Training Course Details...
Database Security
Designing a Lookup Database
Creating and Using Macros
Multi Table Queries
Data Validation
Importing and Exporting Records
Macros on Forms
Creating and Using Forms
Querying Techniques
Creating Queries
Working With Records
Action Queries
Creating a Lookup Database
Getting to Know Access
Adding Records to a Table
Using a Navigation Form
Macro Techniques
An Introduction to VBA
Calculations in Queries
Navigation Pane Protection
Microsoft Access Programming Using VBA
- 3 day course
- Location: Kidderminster
- 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 Select Case...End Select Structure
- See Training Course Details...
Locking Records for Updating
Writing an Error-Handling Routine
Using Break Mode during Run Mode
Using the Object Browser
Using Message Boxes
Calling Procedures
Naming Procedures
Using the With Statement
Navigating the Access Object Hierarchy
Understanding Constants
Debugging Code
Working with Variable Scope
Using the For...Next Structure
Working with Properties
Working with Events
Understanding Recordset Cursor Properties - Optional
Setting Breakpoints
Creating a Standard Module
Understanding the Err Object
Using Intrinsic Constants
Email us about this courses
Other Kidderminster Enable Technology Training Courses
SSRS - Kidderminster SQL Server Reporting Services Training Courses
Excel 365 Advanced Kidderminster Training Courses
SSIS Kidderminster Training Courses
SSAS - Kidderminster SQL Server Analysis Services Training Courses
JQuery Kidderminster Training Courses
Data Warehouse Kidderminster Training Courses