ACCESS TRAINING COURSES FLINT
About Enable Technology Flint Access Training Courses
Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another option is we can organise a local socially distanced training site in Flint. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Boots UK Limited, Lloyds TSB Bank PLC, Canadian High Commission, Royal & Sun Alliance Group PLC, DHL Express, Nuclear Engineering Services, Yell Group PLC and GKN PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Flint
- 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 ... Why Program in Access?
- See Training Course Details...
Understanding Control-of-Flow Structures
Working with Events
Understanding Data Types
Understanding Modules
Creating a Standard Module
Using Visual Basic Help
Understanding Collections
Controlling Program Execution
Trapping Errors with the On Error Statement
Working with Variable Scope
Using the For Each...Next Structure
Working with the ADODB Recordset Object
Debugging Code
Navigating the Access Object Hierarchy
Using the Select Case...End Select Structure
Understanding Recordset Cursor Properties - Optional
Using the CacheSize Property - Optional
Naming Procedures
Using Break Mode during Run Mode
Microsoft Access
- 2 day course
- Location: Flint
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Setting Table Relationships
- See Training Course Details...
Importing and Exporting Records
Creating and Using Macros
Getting to Know Access
Calculations in Queries
Modifying Forms
Understanding VBA
DIY Forms
Creating a Relational Database
An Introduction to VBA
Formatting Tables
Adding Records to a Table
Creating Queries
Macro Techniques
Action Queries
Multi Table Queries
Navigation Pane Protection
Parameter Queries
Database Security
Relational Database Design
Creating and Using Reports
Email us about this courses
Other Flint Enable Technology Training Courses
Data Warehouse - Flint SQL Training Courses
Excel 365 Basic Flint Training Courses
VBA Flint Training Courses
Power BI - Flint Microsoft Power BI Training Courses
SQL Flint Training Courses
SSIS Flint Training Courses