ACCESS TRAINING COURSES GATESHEAD
About Enable Technology Gateshead Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. Each course participant will be issued with training Access resources which they can continue to use after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If delivery onsite is an issue we will organise a venue near you in Gateshead. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Vodafone Group Services, Nuclear Engineering Services, Capita Group PLC, Norwich Union PLC, DHL Express, Dollond & Aitchison Limited, National Power PLC and Cadbury PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gateshead
- 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 ... Specifying a Recordset Cursor Type
- See Training Course Details...
Setting Breakpoints
Working with Methods
Working with Variable Lifetime
Specifying a Recordset Cursor Location - Optional
Working with Recordsets
Stepping through Code
Declaring and Creating Object Variables
Understanding Control-of-Flow Structures
Setting Break Expressions
Debugging Code
Using Input Boxes
Working with Properties
Understanding Procedures
Understanding Data Types
Understanding Expressions and Statements
Understanding the Order of Events
Understanding Error Handling
Navigating the Access Object Hierarchy
Microsoft Access
- 2 day course
- Location: Gateshead
- 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 ... An Introduction to VBA
- See Training Course Details...
Relational Database Design
Creating and Using Forms
Formatting Tables
Adding Records to a Table
Importing and Exporting Records
Calculations in Queries
Data Validation
Database Wellness
Creating Queries
Action Queries
DIY Forms
Sorting and Filtering
Modifying Table Structures
Parameter Queries
Multi Table Queries
Modifying Forms
Aggregation Queries
Macros on Forms
Creating and Using Macros
Creating and Using Reports
Email us about this courses
Other Gateshead Enable Technology Training Courses
TSQL - Gateshead SQL Training Courses
JavaScript Gateshead Training Courses
Excel 365 Basic Gateshead Training Courses
Excel 365 Advanced Gateshead Training Courses
DAX Gateshead Training Courses
SSRS - Gateshead SQL Server Reporting Services Training Courses