ACCESS TRAINING COURSES RUNCORN
About Enable Technology Runcorn Access Training Courses
We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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 Runcorn. The Access syllabus can be modified to accommodate your specific training 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
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Total Telecommunications Limited, Queen's Medical Centre Nottingham, National Power PLC, Vodafone Group Services, Boots UK Limited, Wolverhampton City Council, Lloyds TSB Bank PLC and Canadian High Commission.
Microsoft Access
- 2 day course
- Location: Runcorn
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Database Security
- See Training Course Details...
Creating and Using Macros
Aggregation Queries
Modifying Table Structures
Macros on Forms
Calculations in Queries
DIY Forms
Creating and Using Forms
An Introduction to VBA
Creating Queries
Understanding VBA
Creating a Relational Database
Setting Table Relationships
Data Validation
Database Wellness
Relational Database Design
Sorting and Filtering
Macro Techniques
Multi Table Queries
Adding Transactional Records
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Runcorn
- 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 ... Understanding the Form Object
- See Training Course Details...
Declaring Variables
Debugging Code
Navigating the Access Object Hierarchy
Working with Variable Lifetime
Working with Boolean Expressions
Using the For...Next Structure
Understanding Control-of-Flow Structures
Understanding Collections
Understanding Modules
Using Input Boxes
Specifying a Recordset Cursor Location - Optional
Stepping through Code
Organizing Code and Procedures
Understanding the Development Environment
Using Message Boxes
Why Program in Access?
Understanding Data Types
Working with Events
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Email us about this courses
Other Runcorn Enable Technology Training Courses
SQL Runcorn Training Courses
JQuery Mobile Runcorn Training Courses
PL/SQL - Runcorn SQL Training Courses
SSRS - Runcorn SQL Server Reporting Services Training Courses
TSQL - Runcorn SQL Training Courses
Report Builder - Runcorn SQL Server Reporting Services Training Courses