ACCESS TRAINING COURSES REDDITCH
About Enable Technology Redditch Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. Every course participant is given Access courseware which they can refer to after the training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Redditch. We are happy to modify the Access syllabus to match your teams training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Aston University, Royal Air Force, Birmingham City University, Boots UK Limited, Nationwide Building Society Limited, Cadbury PLC, Lloyds TSB Bank PLC and Keele University.
Microsoft Access
- 2 day course
- Location: Redditch
- 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 ... Relational Database Design
- See Training Course Details...
Parameter Queries
Multi Table Queries
An Introduction to VBA
Using a Navigation Form
DIY Forms
Navigation Pane Protection
Creating Queries
Database Security
Designing a Lookup Database
Sorting and Filtering
Understanding VBA
Macro Techniques
Macros on Forms
Getting to Know Access
Importing and Exporting Records
Setting Table Relationships
Calculations in Queries
Creating and Using Forms
Data Validation
Working With Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Redditch
- 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 Message Boxes
- See Training Course Details...
Using the Select Case...End Select Structure
Working with Variable Lifetime
Understanding Objects
Specifying a Recordset Cursor Type
Specifying a Recordset Cursor Location - Optional
Understanding the Err Object
Using Intrinsic Functions
Using the CacheSize Property - Optional
Using the Do...Loop Structure
Understanding Recordset Cursor Properties - Optional
Working with Variable Scope
Using the For...Next Structure
Debugging Code
Understanding the Form Object
Writing an Error-Handling Routine
Understanding Classes and Objects
Working with Boolean Expressions
Using Input Boxes
Understanding VBA's Error Trapping Options
Understanding the Development Environment
Email us about this courses
Other Redditch Enable Technology Training Courses
VBA - Redditch Excel Training Courses
JavaScript Redditch Training Courses
SQL Redditch Training Courses
TSQL - Redditch SQL Training Courses
SSRS Redditch Training Courses
DAX - Redditch Excel Training Courses