ACCESS TRAINING COURSES CANNOCK
About Enable Technology Cannock Access Training Courses
We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the Access course at a local training venue in Cannock. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Royal & Sun Alliance Group PLC, Queen's Medical Centre Nottingham, EDF Energy PLC, DHL Express, Carillion PLC, Cadbury PLC, South Staffordshire Water PLC and GKN PLC.
Microsoft Access
- 2 day course
- Location: Cannock
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Parameter Queries
- See Training Course Details...
Getting to Know Access
Multi Table Queries
Formatting Tables
Sorting and Filtering
Macros on Forms
Database Wellness
Importing and Exporting Records
Modifying Table Structures
Using a Navigation Form
Calculations in Queries
Macro Techniques
Modifying Forms
Adding Records to a Table
Relational Database Design
Database Security
Querying Techniques
Setting Table Relationships
Creating Queries
Designing a Lookup Database
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cannock
- 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 ... Working with Inline Error Handling
- See Training Course Details...
Understanding Error Handling
Creating a Function Procedure
Using Debugging Tools
Controlling Program Execution
Understanding Errors
Using the Immediate Window to Call Procedures
Using the For Each...Next Structure
Using Message Boxes
Working with Variable Lifetime
Specifying a Recordset Cursor Location - Optional
Locking Records for Updating
Working with Variable Scope
Creating a Sub Procedure
Using the For...Next Structure
Understanding Procedures
Working with Properties
Understanding Expressions and Statements
Guidelines for use of Branching Structures
Email us about this courses
Other Cannock Enable Technology Training Courses
Report Builder Cannock Training Courses
Excel 365 Intermediate - Cannock Excel Training Courses
Power Query - Cannock Excel Training Courses
TSQL Cannock Training Courses
JQuery - Cannock JavaScript Training Courses
SSAS - Cannock SQL Server Analysis Services Training Courses