ACCESS TRAINING COURSES MILFORD HAVEN
About Enable Technology Milford Haven 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. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology offers instructor led training taught by technology specialists. 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. Another way we could deliver the Access course is at a local socially distanced training site. Every Access course can be modified to meet your bespoke requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: University of Birmingham, Nuclear Engineering Services, Barclays Bank PLC, EDF Energy PLC, Birmingham Heartlands Hospital, Cadbury PLC, National Power PLC and TalkTalk Direct Limited.
Microsoft Access
- 2 day course
- Location: Milford Haven
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Using a Navigation Form
- See Training Course Details...
Creating and Using Forms
Multi Table Queries
An Introduction to VBA
Understanding VBA
Relational Database Design
Querying Techniques
Calculations in Queries
Macro Techniques
Database Security
Creating and Using Reports
DIY Forms
Setting Table Relationships
Formatting Tables
Macros on Forms
Aggregation Queries
Creating a Lookup Database
Data Validation
Modifying Table Structures
Creating a Relational Database
Creating Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Milford Haven
- 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 the DoCmd Object
- See Training Course Details...
Understanding Control-of-Flow Structures
Using Break Mode during Run Mode
Working with Variable Lifetime
Creating a Sub Procedure
Understanding Objects
Handling Errors
Understanding Expressions and Statements
Using Message Boxes
Understanding Constants
Understanding Classes and Objects
Working with Inline Error Handling
Working with Methods
Using Debugging Tools
Understanding the Development Environment
Understanding Recordset Cursor Properties - Optional
Declaring Variables
Using the For Each...Next Structure
Email us about this courses
Other Milford Haven Enable Technology Training Courses
PL/SQL - Milford Haven SQL Training Courses
Excel 365 Basic - Milford Haven Excel Training Courses
VBA - Milford Haven Excel Training Courses
SSAS Tabular Milford Haven Training Courses
Data Warehouse - Milford Haven SQL Training Courses
JavaScript Milford Haven Training Courses