ACCESS TRAINING COURSES SMETHWICK
About Enable Technology Smethwick Access Training Courses
We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft 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 Smethwick. 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.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: University of Birmingham, Birmingham Heartlands Hospital, Royal Air Force, EDF Energy PLC, Unipart Group, Dollond & Aitchison Limited, Wolverhampton City Council and Aston University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Smethwick
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Using Intrinsic Constants
- See Training Course Details...
Understanding VBA's Error Trapping Options
Creating a Sub Procedure
Using Intrinsic Functions
Working with the Code Editor
Declaring and Creating Object Variables
Organizing Code and Procedures
Using Visual Basic Help
Understanding Classes and Objects
Using the Select Case...End Select Structure
Trapping Errors with the On Error Statement
Using Expressions, Variables, and Intrinsic Functions
Understanding Errors
Using Input Boxes
Using Message Boxes
Writing an Error-Handling Routine
Understanding the Development Environment
Microsoft Access
- 2 day course
- Location: Smethwick
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Querying Techniques
- See Training Course Details...
Sorting and Filtering
Creating a Relational Database
Database Wellness
Understanding VBA
Creating Queries
Getting to Know Access
Designing a Lookup Database
Adding Records to a Table
Aggregation Queries
Macros on Forms
Relational Database Design
Multi Table Queries
Data Validation
Action Queries
Creating a Lookup Database
Creating and Using Reports
Adding Transactional Records
Parameter Queries
Using a Navigation Form
Setting Table Relationships
Email us about this courses
Other Smethwick Enable Technology Training Courses
SQL Smethwick Training Courses
JavaScript - Smethwick JavaScript Training Courses
JQuery Mobile Smethwick Training Courses
Excel 365 Intermediate - Smethwick Excel Training Courses
Excel 365 Advanced - Smethwick Excel Training Courses
SSRS - Smethwick SQL Server Reporting Services Training Courses