ACCESS TRAINING COURSES WEDNESBURY
About Enable Technology Wednesbury Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We provide instructor led training coupled with hands on training. 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 local training venue in Wednesbury. 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.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Canadian High Commission, Yell Group PLC, Royal Air Force, Unipart Group, Nuclear Engineering Services, EDF Energy PLC, Birmingham City Council and Nationwide Building Society Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wednesbury
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with Properties
- See Training Course Details...
Working with Variable Lifetime
Writing an Error-Handling Routine
Determining the Value of Expressions
Using the For Each...Next Structure
Understanding Collections
Using Visual Basic Help
Declaring and Creating Object Variables
Working with the Application Object
Working with the ADODB Recordset Object
Using the If...End If Decision Structures
Understanding Modules
Setting Breakpoints
Understanding Data Types
Understanding Control-of-Flow Structures
Using the With Statement
Controlling Program Execution
Introduction to Programming in Access
Understanding the Form Object
Using the Select Case...End Select Structure
Microsoft Access
- 2 day course
- Location: Wednesbury
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Creating a Relational Database
- See Training Course Details...
An Introduction to VBA
Data Validation
Navigation Pane Protection
Sorting and Filtering
Creating a Lookup Database
Working With Records
Database Wellness
Adding Transactional Records
Database Security
Calculations in Queries
Getting to Know Access
Macros on Forms
Macro Techniques
Querying Techniques
Designing a Lookup Database
Action Queries
Modifying Table Structures
Parameter Queries
Creating and Using Reports
DIY Forms
Email us about this courses
Other Wednesbury Enable Technology Training Courses
SSAS - Wednesbury SQL Server Analysis Services Training Courses
SQL Wednesbury Training Courses
Power Query - Wednesbury Excel Training Courses
PL/SQL Wednesbury Training Courses
Power BI - Wednesbury Microsoft Power BI Training Courses
Report Builder Wednesbury Training Courses