ACCESS TRAINING COURSES SKELMERSDALE
About Enable Technology Skelmersdale 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 Professionals. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a training location in Skelmersdale. Every Access course can be modified to meet your bespoke requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Barclays Bank PLC, Norwich Union PLC, Loughborough University, Carillion PLC, TalkTalk Direct Limited, Dollond & Aitchison Limited, Fujistu PLC and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Skelmersdale
- 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 ... Modifying Forms
- See Training Course Details...
Adding Transactional Records
Using a Navigation Form
Relational Database Design
Macro Techniques
Working With Records
Creating a Relational Database
Formatting Tables
Creating and Using Reports
An Introduction to VBA
Creating and Using Macros
Database Security
Understanding VBA
Creating Queries
Sorting and Filtering
DIY Forms
Action Queries
Multi Table Queries
Data Validation
Setting Table Relationships
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Skelmersdale
- 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 ... Working with the ADODB Recordset Object
- See Training Course Details...
Working with the Application Object
Specifying a Recordset Cursor Type
Stepping through Code
Declaring Variables
Working with Recordsets
Understanding the DoCmd Object
Specifying a Recordset Cursor Location - Optional
Guidelines for use of Branching Structures
Using the With Statement
Understanding Data Types
Working with Events
Using the For Each...Next Structure
Understanding the Development Environment
Understanding Recordset Cursor Properties - Optional
Understanding the Order of Events
Trapping Errors with the On Error Statement
Why Program in Access?
Email us about this courses
Other Skelmersdale Enable Technology Training Courses
DAX - Skelmersdale Excel Training Courses
PL/SQL - Skelmersdale SQL Training Courses
Power BI Skelmersdale Training Courses
JQuery - Skelmersdale JavaScript Training Courses
Oracle SQL Skelmersdale Training Courses
JQuery Mobile Skelmersdale Training Courses