ACCESS TRAINING COURSES NORTHWICH
About Enable Technology Northwich Access Training Courses
We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. All course participants are issued Access training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We can also deliver the Access course at a local training venue in Northwich. We are happy to discuss customising the course content should you have particular Access training requirements.
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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Barclays Bank PLC, Keele University, Royal & Sun Alliance Group PLC, Halfords Group PLC, Birmingham Heartlands Hospital, Nuclear Engineering Services, Carillion PLC and Aston University.
Microsoft Access
- 2 day course
- Location: Northwich
- 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 ... Database Security
- See Training Course Details...
Adding Transactional Records
Aggregation Queries
Action Queries
Creating and Using Reports
Creating a Relational Database
Understanding VBA
Multi Table Queries
Macro Techniques
An Introduction to VBA
Querying Techniques
Designing a Lookup Database
Data Validation
Relational Database Design
Working With Records
Setting Table Relationships
Modifying Forms
Formatting Tables
Getting to Know Access
Creating and Using Macros
Creating Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Northwich
- 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 ... Introduction to Programming in Access
- See Training Course Details...
Working with Boolean Expressions
Understanding Data Types
Controlling Program Execution
Understanding Classes and Objects
Handling Errors
Using the For...Next Structure
Creating a Function Procedure
Working with Inline Error Handling
Guidelines for use of Branching Structures
Using Visual Basic Help
Understanding the DoCmd Object
Working with Events
Working with Variable Scope
Why Program in Access?
Understanding Control-of-Flow Structures
Understanding Collections
Using the Select Case...End Select Structure
Email us about this courses
Other Northwich Enable Technology Training Courses
SQL Northwich Training Courses
SSIS Northwich Training Courses
Data Warehouse Northwich Training Courses
DAX - Northwich Excel Training Courses
TSQL - Northwich SQL Training Courses
SSAS - Northwich SQL Server Analysis Services Training Courses