ACCESS TRAINING COURSES ASHTON-UNDER-LYNE
About Enable Technology Ashton-under-lyne Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver Access courses onsite at your site. We also offer the option of scheduling of Access course at a socially distanced venue near you in Ashton-under-lyne. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Cadbury PLC, Homeserve PLC, Royal & Sun Alliance Group PLC, Capita Group PLC, Keele University, Queen's Medical Centre Nottingham, South Staffordshire Water PLC and EDF Energy PLC.
Microsoft Access
- 2 day course
- Location: Ashton-under-lyne
- Telephone on 01952 305730
- 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 ... Designing a Lookup Database
- See Training Course Details...
Database Wellness
Getting to Know Access
Calculations in Queries
Creating a Lookup Database
Multi Table Queries
Creating Queries
Setting Table Relationships
Importing and Exporting Records
Working With Records
Macro Techniques
Data Validation
Parameter Queries
Creating a Relational Database
Formatting Tables
Creating and Using Macros
Relational Database Design
An Introduction to VBA
Macros on Forms
Adding Transactional Records
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ashton-under-lyne
- Telephone on 01952 305730
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding Constants
- See Training Course Details...
Using the For Each...Next Structure
Using Break Mode during Run Mode
Using the For...Next Structure
Understanding Expressions and Statements
Understanding the Form Object
Understanding Data Types
Naming Procedures
Understanding VBA's Error Trapping Options
Creating a Sub Procedure
Using Intrinsic Functions
Working with Inline Error Handling
Working with Recordsets
Working with the Application Object
Using the Do...Loop Structure
Understanding Recordset Cursor Properties - Optional
Specifying a Recordset Cursor Type
Debugging Code
Writing an Error-Handling Routine
Using the Immediate Window to Call Procedures
Working with Properties
Email us about this courses
Other Ashton-under-lyne Enable Technology Training Courses
Oracle SQL - Ashton-under-lyne SQL Training Courses
Excel Intermediate - Ashton-under-lyne Excel Training Courses
SSAS 2017 Ashton-under-lyne Training Courses
PL/SQL - Ashton-under-lyne SQL Training Courses
SQL - Ashton-under-lyne SQL Training Courses
Project 2016 L1 - Ashton-under-lyne Microsoft Project Training Courses