ACCESS TRAINING COURSES PUDSEY
About Enable Technology Pudsey Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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. Alternatively we could schedule a course at a local venue in Pudsey. We are happy to modify the Access syllabus to match your teams training requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Birmingham Heartlands Hospital, Dollond & Aitchison Limited, Lloyds TSB Bank PLC, Yell Group PLC, Royal & Sun Alliance Group PLC, National Power PLC, Queen's Medical Centre Nottingham and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Pudsey
- 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 ... Creating a Standard Module
- See Training Course Details...
Understanding Data Types
Understanding Collections
Working with the ADODB Recordset Object
Specifying a Recordset Cursor Location - Optional
Using the Immediate Window to Call Procedures
Declaring Variables
Using Message Boxes
Working with Variable Scope
Using the Object Browser
Understanding Error Handling
Using the With Statement
Naming Procedures
Using Expressions, Variables, and Intrinsic Functions
Understanding the Err Object
Working with Events
Working with Boolean Expressions
Using Input Boxes
Microsoft Access
- 2 day course
- Location: Pudsey
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Parameter Queries
- See Training Course Details...
Importing and Exporting Records
Database Security
Understanding VBA
Calculations in Queries
Aggregation Queries
Getting to Know Access
Creating a Lookup Database
Modifying Forms
Querying Techniques
Sorting and Filtering
Setting Table Relationships
Database Wellness
Working With Records
Adding Transactional Records
Creating and Using Reports
Data Validation
Adding Records to a Table
Action Queries
Macros on Forms
An Introduction to VBA
Email us about this courses
Other Pudsey Enable Technology Training Courses
Power Query Pudsey Training Courses
Power BI Pudsey Training Courses
JavaScript - Pudsey JavaScript Training Courses
Excel 365 Intermediate Pudsey Training Courses
Excel 365 Advanced - Pudsey Excel Training Courses
Excel Power Pivot Pudsey Training Courses