ACCESS TRAINING COURSES RUGELEY
About Enable Technology Rugeley Access Training Courses
We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We are set up to deliver Access training courses onsite at your premises. The Access course could also be scheduled at a socially distanced site near you in Rugeley. All Access courses can be customised to meet your particular requirements.
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 guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Carillion PLC, Nuclear Engineering Services, Birmingham Heartlands Hospital, Wolverhampton City Council, Shell UK Oil Products Ltd, West Bromwich Building Society, Keele University and University of Birmingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rugeley
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Understanding Procedures
- See Training Course Details...
Understanding the DoCmd Object
Understanding Errors
Creating a Standard Module
Using Input Boxes
Controlling Program Execution
Working with the ADODB Recordset Object
Understanding Error Handling
Working with the Application Object
Working with the Code Editor
Creating a Function Procedure
Stepping through Code
Locking Records for Updating
Using Break Mode during Run Mode
Using Debugging Tools
Using the For...Next Structure
Using Expressions, Variables, and Intrinsic Functions
Using Intrinsic Constants
Microsoft Access
- 2 day course
- Location: Rugeley
- 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 ... Multi Table Queries
- See Training Course Details...
Aggregation Queries
Macro Techniques
An Introduction to VBA
Formatting Tables
Creating Queries
DIY Forms
Creating and Using Macros
Using a Navigation Form
Modifying Table Structures
Sorting and Filtering
Parameter Queries
Action Queries
Setting Table Relationships
Calculations in Queries
Getting to Know Access
Creating and Using Reports
Understanding VBA
Relational Database Design
Database Security
Working With Records
Email us about this courses
Other Rugeley Enable Technology Training Courses
Excel 365 Intermediate Rugeley Training Courses
Power BI Rugeley Training Courses
Report Builder - Rugeley SQL Server Reporting Services Training Courses
SSIS Rugeley Training Courses
DAX Rugeley Training Courses
PL/SQL - Rugeley SQL Training Courses