ACCESS TRAINING COURSES NEWCASTLE UNDER LYME
About Enable Technology Newcastle Under Lyme Access Training Courses
We are a company that provides short intensive Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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 Newcastle Under Lyme. We are happy to modify the Access syllabus to match your teams training 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 Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Queen's Medical Centre Nottingham, Shell UK Oil Products Ltd, Keele University, DHL Express, Cadbury PLC, GKN PLC, Lloyds TSB Bank PLC and Norfolk Police Constabulary.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newcastle Under Lyme
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Creating a Standard Module
- See Training Course Details...
Navigating the Access Object Hierarchy
Using Break Mode during Run Mode
Debugging Code
Writing an Error-Handling Routine
Understanding Errors
Determining the Value of Expressions
Working with Boolean Expressions
Controlling Program Execution
Working with Variable Lifetime
Setting Breakpoints
Understanding Modules
Understanding VBA's Error Trapping Options
Declaring Variables
Working with the Application Object
Understanding Recordset Cursor Properties - Optional
Why Program in Access?
Naming Procedures
Understanding Constants
Microsoft Access
- 2 day course
- Location: Newcastle Under Lyme
- 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 ... Getting to Know Access
- See Training Course Details...
Macros on Forms
Aggregation Queries
Modifying Forms
Creating Queries
Multi Table Queries
Formatting Tables
Modifying Table Structures
Calculations in Queries
Creating a Relational Database
Database Wellness
Database Security
DIY Forms
Action Queries
Relational Database Design
Macro Techniques
Importing and Exporting Records
Adding Records to a Table
Using a Navigation Form
Data Validation
Sorting and Filtering
Email us about this courses
Other Newcastle Under Lyme Enable Technology Training Courses
SSIS - Newcastle Under Lyme SQL Server Integration Services Training Courses
SSAS Newcastle Under Lyme Training Courses
Excel 365 Intermediate - Newcastle Under Lyme Excel Training Courses
Power BI Newcastle Under Lyme Training Courses
PL/SQL Newcastle Under Lyme Training Courses
Data Warehouse Newcastle Under Lyme Training Courses