ACCESS TRAINING COURSES YORKSHIRE
About Enable Technology Yorkshire Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The Access course could also be scheduled at a socially distanced site near you in Yorkshire. 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 Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are National Power PLC, Lloyds TSB Bank PLC, Vodafone Group Services, Yell Group PLC, Homeserve PLC, Norfolk Police Constabulary, Boots UK Limited and Shell UK Oil Products Ltd.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Yorkshire
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Working with the ADODB Recordset Object
- See Training Course Details...
Understanding Data Types
Declaring and Creating Object Variables
Understanding Collections
Specifying a Recordset Cursor Location - Optional
Guidelines for use of Branching Structures
Working with Procedures and Functions
Using Input Boxes
Setting Break Expressions
Creating a Function Procedure
Working with Boolean Expressions
Understanding Errors
Controlling Program Execution
Creating a Standard Module
Handling Errors
Locking Records for Updating
Understanding Control-of-Flow Structures
Working with the Code Editor
Organizing Code and Procedures
Working with Properties
Microsoft Access
- 2 day course
- Location: Yorkshire
- Telephone on 01952 938014
- 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 ... Multi Table Queries
- See Training Course Details...
Creating and Using Forms
Creating a Lookup Database
Creating a Relational Database
Setting Table Relationships
Getting to Know Access
Database Security
Modifying Forms
An Introduction to VBA
Aggregation Queries
Adding Transactional Records
Action Queries
Navigation Pane Protection
Relational Database Design
Calculations in Queries
Working With Records
Querying Techniques
Understanding VBA
DIY Forms
Importing and Exporting Records
Creating and Using Reports
Email us about this courses
Other Yorkshire Enable Technology Training Courses
Power Query Yorkshire Training Courses
SQL - Yorkshire SQL Training Courses
SSAS - Yorkshire SQL Server Analysis Services Training Courses
Excel 365 Intermediate - Yorkshire Excel Training Courses
Power BI Yorkshire Training Courses
TSQL Yorkshire Training Courses