ACCESS TRAINING COURSES SOUTHPORT
About Enable Technology Southport Access Training Courses
Enable Technology provides practical Access skills based technology training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each course participant will be issued with training Access resources which they can continue to use after the 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.
We provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be modified to accommodate your specific training needs.
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 Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Royal Air Force, Nationwide Building Society Limited, Yell Group PLC, Wolverhampton City Council, EDF Energy PLC, Lloyds TSB Bank PLC, Carillion PLC and Total Telecommunications Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Southport
- 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 Procedures and Functions
- See Training Course Details...
Why Program in Access?
Organizing Code and Procedures
Working with Boolean Expressions
Understanding Data Types
Considering Variable Scope and Lifetime Together
Working with the ADODB Recordset Object
Using Expressions, Variables, and Intrinsic Functions
Creating a Sub Procedure
Understanding the Err Object
Understanding Control-of-Flow Structures
Understanding the Development Environment
Using Intrinsic Functions
Specifying a Recordset Cursor Location - Optional
Using the With Statement
Using the Immediate Window to Call Procedures
Setting Break Expressions
Using the For...Next Structure
Microsoft Access
- 2 day course
- Location: Southport
- 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 ... Navigation Pane Protection
- See Training Course Details...
Macro Techniques
Calculations in Queries
Setting Table Relationships
Designing a Lookup Database
Action Queries
Understanding VBA
Creating and Using Forms
An Introduction to VBA
Macros on Forms
Database Wellness
Creating Queries
DIY Forms
Multi Table Queries
Getting to Know Access
Creating and Using Macros
Sorting and Filtering
Adding Records to a Table
Database Security
Relational Database Design
Parameter Queries
Email us about this courses
Other Southport Enable Technology Training Courses
PL/SQL Southport Training Courses
SQL - Southport SQL Training Courses
Excel 365 Intermediate Southport Training Courses
DAX Southport Training Courses
SSAS Tabular Southport Training Courses
Excel Power Pivot Southport Training Courses