ACCESS TRAINING COURSES RUNCORN
About Enable Technology Runcorn Access Training Courses
We are a company that provides short intensive Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. 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.
Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of Access course at a socially distanced venue near you in Runcorn. All Access courses can be customised to meet your particular requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Queen's Medical Centre Nottingham, Nuclear Engineering Services, Lloyds TSB Bank PLC, Royal & Sun Alliance Group PLC, Carillion PLC, DHL Express, Canadian High Commission and Halfords Group PLC.
Microsoft Access
- 2 day course
- Location: Runcorn
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Using a Navigation Form
- See Training Course Details...
Creating a Relational Database
Aggregation Queries
Importing and Exporting Records
Querying Techniques
Creating and Using Macros
Action Queries
Designing a Lookup Database
Modifying Forms
Sorting and Filtering
Database Wellness
Working With Records
Calculations in Queries
Multi Table Queries
Navigation Pane Protection
Getting to Know Access
Modifying Table Structures
Creating a Lookup Database
Relational Database Design
Formatting Tables
Database Security
Microsoft Access Programming Using VBA
- 3 day course
- Location: Runcorn
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding the Order of Events
- See Training Course Details...
Setting Breakpoints
Using Intrinsic Functions
Setting Break Expressions
Understanding the Err Object
Specifying a Recordset Cursor Type
Understanding Objects
Understanding Recordset Cursor Properties - Optional
Using the Immediate Window to Call Procedures
Working with the ADODB Recordset Object
Understanding Data Types
Creating a Function Procedure
Considering Variable Scope and Lifetime Together
Using Debugging Tools
Using Input Boxes
Understanding Control-of-Flow Structures
Navigating the Access Object Hierarchy
Writing an Error-Handling Routine
Email us about this courses
Other Runcorn Enable Technology Training Courses
SSAS Tabular - Runcorn SQL Server Analysis Services Training Courses
Power Query - Runcorn Excel Training Courses
Oracle SQL - Runcorn SQL Training Courses
TSQL - Runcorn SQL Training Courses
VBA Runcorn Training Courses
Excel 365 Intermediate - Runcorn Excel Training Courses