ACCESS TRAINING COURSES COLWYN BAY
About Enable Technology Colwyn Bay Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. If you prefer we can offer an offsite socially distanced training location in Colwyn Bay. We will work with you prior to the course to tailor the Access syllabus to match your 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. Some of our clients are Boots UK Limited, Canadian High Commission, Dollond & Aitchison Limited, TalkTalk Direct Limited, Loughborough University, Unipart Group, Wolverhampton City Council and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Colwyn Bay
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Setting Breakpoints
- See Training Course Details...
Controlling Program Execution
Working with Inline Error Handling
Understanding Procedures
Understanding the Err Object
Using Intrinsic Functions
Understanding the Development Environment
Understanding Data Types
Setting Break Expressions
Working with Boolean Expressions
Understanding Constants
Considering Variable Scope and Lifetime Together
Using the If...End If Decision Structures
Understanding the Form Object
Declaring Variables
Working with Recordsets
Working with Procedures and Functions
Understanding Expressions and Statements
Using Intrinsic Constants
Specifying a Recordset Cursor Location - Optional
Locking Records for Updating
Microsoft Access
- 2 day course
- Location: Colwyn Bay
- 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 ... Creating and Using Macros
- See Training Course Details...
Creating Queries
Creating a Lookup Database
Formatting Tables
Getting to Know Access
DIY Forms
Database Security
Understanding VBA
Designing a Lookup Database
Relational Database Design
Modifying Forms
Aggregation Queries
Working With Records
Database Wellness
Setting Table Relationships
Querying Techniques
Adding Records to a Table
Multi Table Queries
Data Validation
Macros on Forms
Action Queries
Email us about this courses
Other Colwyn Bay Enable Technology Training Courses
JQuery Colwyn Bay Training Courses
Data Warehouse - Colwyn Bay SQL Training Courses
DAX Colwyn Bay Training Courses
PL/SQL - Colwyn Bay SQL Training Courses
TSQL Colwyn Bay Training Courses
Power Query - Colwyn Bay Excel Training Courses