ACCESS TRAINING COURSES HUDDERSFIELD
About Enable Technology Huddersfield Access Training Courses
Enable Technology provides practical Access skills based technology training. The training will be delivered by a Microsoft professional with development experience. Each course participant will be issued with training Access resources which they can continue to use after the training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We also offer the option of scheduling of Access course at a venue near you in Huddersfield. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Halfords Group PLC, Birmingham City University, Keele University, Birmingham Heartlands Hospital, Carillion PLC, Barclays Bank PLC, Royal & Sun Alliance Group PLC and Aston University.
Microsoft Access
- 2 day course
- Location: Huddersfield
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Creating a Relational Database
- See Training Course Details...
Getting to Know Access
Macros on Forms
Creating and Using Macros
Using a Navigation Form
Querying Techniques
Creating and Using Reports
Understanding VBA
Importing and Exporting Records
Aggregation Queries
Creating a Lookup Database
Sorting and Filtering
Action Queries
DIY Forms
Modifying Table Structures
Working With Records
Creating and Using Forms
Database Security
Adding Transactional Records
Data Validation
Macro Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Huddersfield
- 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 ... Using Intrinsic Functions
- See Training Course Details...
Determining the Value of Expressions
Working with Procedures and Functions
Organizing Code and Procedures
Using the Object Browser
Working with Methods
Understanding the Err Object
Creating a Sub Procedure
Naming Procedures
Navigating the Access Object Hierarchy
Working with Variable Lifetime
Using the For Each...Next Structure
Using Intrinsic Constants
Using the CacheSize Property - Optional
Stepping through Code
Creating a Standard Module
Understanding the DoCmd Object
Understanding the Development Environment
Using Break Mode during Run Mode
Email us about this courses
Other Huddersfield Enable Technology Training Courses
SSAS Tabular - Huddersfield SQL Server Analysis Services Training Courses
JavaScript Huddersfield Training Courses
Excel 365 Intermediate - Huddersfield Excel Training Courses
Report Builder Huddersfield Training Courses
Oracle SQL Huddersfield Training Courses
SQL - Huddersfield SQL Training Courses