ACCESS TRAINING COURSES OSWESTRY
About Enable Technology Oswestry Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.
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. Another way we could deliver the Access course is at a local socially distanced training site. 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.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Lloyds TSB Bank PLC, Queen's Medical Centre Nottingham, Dollond & Aitchison Limited, Birmingham Heartlands Hospital, Keele University, Yell Group PLC, Countrywide Homes Limited and Carillion PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Oswestry
- 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 ... Working with Boolean Expressions
- See Training Course Details...
Understanding Constants
Understanding Collections
Setting Breakpoints
Understanding Data Types
Working with Recordsets
Writing an Error-Handling Routine
Understanding Control-of-Flow Structures
Understanding Procedures
Using Visual Basic Help
Determining the Value of Expressions
Understanding the Development Environment
Understanding Recordset Cursor Properties - Optional
Creating a Standard Module
Using Break Mode during Run Mode
Setting Break Expressions
Working with Methods
Working with Procedures and Functions
Microsoft Access
- 2 day course
- Location: Oswestry
- 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 ... Adding Records to a Table
- See Training Course Details...
Creating a Lookup Database
Creating and Using Macros
Navigation Pane Protection
Macro Techniques
Multi Table Queries
Formatting Tables
Macros on Forms
Understanding VBA
Setting Table Relationships
DIY Forms
Aggregation Queries
Action Queries
Creating and Using Forms
Getting to Know Access
Using a Navigation Form
Creating Queries
Importing and Exporting Records
Adding Transactional Records
Creating a Relational Database
Sorting and Filtering
Email us about this courses
Other Oswestry Enable Technology Training Courses
VBA Oswestry Training Courses
Power Query - Oswestry Excel Training Courses
SQL - Oswestry SQL Training Courses
Excel Power Pivot - Oswestry Excel Training Courses
Excel 365 Basic Oswestry Training Courses
SSAS Tabular Oswestry Training Courses