ACCESS TRAINING COURSES CHESTER
About Enable Technology Chester Access Training Courses
We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We are set up to deliver Access training courses onsite at your premises. Another option is we can organise a local socially distanced training site in Chester. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to 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: University of Birmingham, EDF Energy PLC, Capita Group PLC, GKN PLC, DHL Express, Barclays Bank PLC, Dollond & Aitchison Limited and Keele University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Chester
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with Variable Lifetime
- See Training Course Details...
Why Program in Access?
Declaring Variables
Using the Object Browser
Understanding Modules
Using the CacheSize Property - Optional
Handling Errors
Working with Events
Specifying a Recordset Cursor Location - Optional
Working with Inline Error Handling
Setting Break Expressions
Understanding the Order of Events
Understanding the Form Object
Understanding Recordset Cursor Properties - Optional
Writing an Error-Handling Routine
Setting Breakpoints
Using Message Boxes
Declaring and Creating Object Variables
Understanding Constants
Using the For Each...Next Structure
Understanding Data Types
Microsoft Access
- 2 day course
- Location: Chester
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Modifying Table Structures
- See Training Course Details...
Macros on Forms
Database Security
Designing a Lookup Database
Adding Records to a Table
Parameter Queries
Creating a Lookup Database
Understanding VBA
Creating a Relational Database
Using a Navigation Form
Data Validation
Creating and Using Reports
Setting Table Relationships
Modifying Forms
Relational Database Design
Getting to Know Access
Database Wellness
Creating Queries
Navigation Pane Protection
Working With Records
Importing and Exporting Records
Email us about this courses
Other Chester Enable Technology Training Courses
Excel 365 Basic - Chester Excel Training Courses
JQuery - Chester JavaScript Training Courses
Power BI Chester Training Courses
Excel Power Pivot Chester Training Courses
Excel 365 Advanced - Chester Excel Training Courses
DAX - Chester Excel Training Courses