ACCESS TRAINING COURSES CROSBY
About Enable Technology Crosby Access Training Courses
Enable Technology specialise in succinct skills based Access training. All of our tutors are Microsoft Certified Professionals. Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.
Courses are instructor led and groups sizes small. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If delivery onsite is an issue we will organise a socially distanced venue near you in Crosby. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are GKN PLC, Keele University, Cadbury PLC, West Bromwich Building Society, Canadian High Commission, Birmingham Heartlands Hospital, Norwich Union PLC and DHL Express.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Crosby
- 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 ... Working with Variable Scope
- See Training Course Details...
Creating a Sub Procedure
Declaring and Creating Object Variables
Using the For Each...Next Structure
Why Program in Access?
Navigating the Access Object Hierarchy
Understanding Recordset Cursor Properties - Optional
Using the With Statement
Introduction to Programming in Access
Using Intrinsic Constants
Understanding Constants
Guidelines for use of Branching Structures
Using Intrinsic Functions
Using the For...Next Structure
Understanding the Form Object
Calling Procedures
Understanding Modules
Understanding the Err Object
Creating a Standard Module
Understanding Objects
Microsoft Access
- 2 day course
- Location: Crosby
- Telephone on 01952 938014
- 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 ... Relational Database Design
- See Training Course Details...
Parameter Queries
Creating a Relational Database
Calculations in Queries
Importing and Exporting Records
Macro Techniques
Modifying Forms
Getting to Know Access
An Introduction to VBA
Creating and Using Forms
Creating Queries
Navigation Pane Protection
Data Validation
Adding Transactional Records
Sorting and Filtering
DIY Forms
Setting Table Relationships
Working With Records
Understanding VBA
Designing a Lookup Database
Multi Table Queries
Email us about this courses
Other Crosby Enable Technology Training Courses
Excel 365 Intermediate Crosby Training Courses
Data Warehouse Crosby Training Courses
Excel 365 Advanced - Crosby Excel Training Courses
Excel 365 Basic - Crosby Excel Training Courses
Report Builder - Crosby SQL Server Reporting Services Training Courses
Excel Power Pivot - Crosby Excel Training Courses