ACCESS TRAINING COURSES LEYLAND
About Enable Technology Leyland Access Training Courses
Enable Technology provides practical Access skills based technology training. 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. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can bring the equipment necessary to deliver Access courses at your site. If delivery onsite is an issue we will organise a venue near you in Leyland. We are happy to discuss customising the course content should you have particular Access training requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Nationwide Building Society Limited, Aston University, Cadbury PLC, Halfords Group PLC, Fujistu PLC, Queen's Medical Centre Nottingham, GKN PLC and Shell UK Oil Products Ltd.
Microsoft Access
- 2 day course
- Location: Leyland
- 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...
Multi Table Queries
Modifying Forms
Macros on Forms
Creating and Using Macros
Creating a Lookup Database
Adding Records to a Table
Navigation Pane Protection
An Introduction to VBA
Working With Records
Creating and Using Reports
Understanding VBA
Action Queries
Relational Database Design
Importing and Exporting Records
Sorting and Filtering
Database Security
DIY Forms
Modifying Table Structures
Database Wellness
Adding Transactional Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leyland
- 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 Recordset Cursor Properties - Optional
- See Training Course Details...
Calling Procedures
Understanding the Err Object
Understanding Objects
Working with the Application Object
Using the With Statement
Declaring and Creating Object Variables
Using the Select Case...End Select Structure
Using Expressions, Variables, and Intrinsic Functions
Understanding Collections
Introduction to Programming in Access
Understanding Data Types
Guidelines for use of Branching Structures
Using Break Mode during Run Mode
Naming Procedures
Specifying a Recordset Cursor Type
Using Message Boxes
Using the CacheSize Property - Optional
Navigating the Access Object Hierarchy
Email us about this courses
Other Leyland Enable Technology Training Courses
SSAS Tabular - Leyland SQL Server Analysis Services Training Courses
JavaScript Leyland Training Courses
PL/SQL - Leyland SQL Training Courses
Oracle SQL Leyland Training Courses
Excel 365 Intermediate Leyland Training Courses
JQuery - Leyland JavaScript Training Courses