ACCESS TRAINING COURSES BARNSLEY
About Enable Technology Barnsley Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each course participant will be issued with training Access resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology training courses are delivered as instructor led courses. 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. If delivery onsite is an issue we will organise a socially distanced venue near you in Barnsley. 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 also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We have operated primarily in the West Midlands for twenty years. Some of our clients are Aston University, Birmingham City University, West Bromwich Building Society, Nuclear Engineering Services, Shell UK Oil Products Ltd, Nationwide Building Society Limited, Total Telecommunications Limited and South Staffordshire Water PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Barnsley
- 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 ... Understanding Recordset Cursor Properties - Optional
- See Training Course Details...
Using Visual Basic Help
Working with Events
Working with the ADODB Recordset Object
Understanding Constants
Understanding the Err Object
Using the With Statement
Using Debugging Tools
Using Input Boxes
Understanding Procedures
Working with Boolean Expressions
Using the For...Next Structure
Understanding Control-of-Flow Structures
Creating a Standard Module
Understanding the Development Environment
Working with Recordsets
Guidelines for use of Branching Structures
Using the For Each...Next Structure
Understanding Expressions and Statements
Microsoft Access
- 2 day course
- Location: Barnsley
- 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 ... Sorting and Filtering
- See Training Course Details...
Getting to Know Access
Setting Table Relationships
Working With Records
Modifying Forms
Action Queries
An Introduction to VBA
Creating a Lookup Database
Creating and Using Macros
Calculations in Queries
Formatting Tables
Using a Navigation Form
Creating a Relational Database
Multi Table Queries
Creating and Using Reports
Querying Techniques
Adding Records to a Table
Creating Queries
Importing and Exporting Records
Macro Techniques
Designing a Lookup Database
Email us about this courses
Other Barnsley Enable Technology Training Courses
Excel 365 Intermediate Barnsley Training Courses
DAX Barnsley Training Courses
SQL - Barnsley SQL Training Courses
Oracle SQL - Barnsley SQL Training Courses
SSIS - Barnsley SQL Server Integration Services Training Courses
Report Builder - Barnsley SQL Server Reporting Services Training Courses