ACCESS TRAINING COURSES WAKEFIELD
About Enable Technology Wakefield Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training Access resources which they can continue to use after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Access course at a venue near you in Wakefield. All Access courses can be customised to meet your particular requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions 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: Lloyds TSB Bank PLC, Homeserve PLC, Loughborough University, Royal Air Force, Keele University, Vodafone Group Services, West Bromwich Building Society and Cadbury PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wakefield
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding Objects
- See Training Course Details...
Navigating the Access Object Hierarchy
Using the For Each...Next Structure
Declaring and Creating Object Variables
Working with Events
Locking Records for Updating
Debugging Code
Considering Variable Scope and Lifetime Together
Introduction to Programming in Access
Using Intrinsic Functions
Understanding Recordset Cursor Properties - Optional
Understanding the DoCmd Object
Organizing Code and Procedures
Working with Recordsets
Declaring Variables
Understanding Error Handling
Understanding Classes and Objects
Microsoft Access
- 2 day course
- Location: Wakefield
- 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 ... Creating and Using Forms
- See Training Course Details...
Importing and Exporting Records
Creating and Using Macros
Data Validation
Formatting Tables
Creating and Using Reports
Adding Transactional Records
Understanding VBA
Parameter Queries
Designing a Lookup Database
Creating Queries
Creating a Lookup Database
Macro Techniques
Database Wellness
Aggregation Queries
Modifying Forms
Calculations in Queries
Setting Table Relationships
Macros on Forms
Creating a Relational Database
Modifying Table Structures
Email us about this courses
Other Wakefield Enable Technology Training Courses
SSRS Wakefield Training Courses
SSAS Tabular - Wakefield SQL Server Analysis Services Training Courses
Oracle SQL - Wakefield SQL Training Courses
SSIS Wakefield Training Courses
Power BI Wakefield Training Courses
PL/SQL Wakefield Training Courses