ACCESS TRAINING COURSES HUDDERSFIELD
About Enable Technology Huddersfield Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. All course participants are issued Access training manuals they can refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
We provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a Access course at an alternative training site in Huddersfield. Every Access course can be modified to meet your bespoke 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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, Countrywide Homes Limited, Loughborough University, University of Birmingham, Cadbury PLC, West Bromwich Building Society and Norwich Union PLC.
Microsoft Access
- 2 day course
- Location: Huddersfield
- 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 ... Using a Navigation Form
- See Training Course Details...
Macros on Forms
DIY Forms
Action Queries
Creating and Using Macros
Setting Table Relationships
Querying Techniques
Modifying Forms
Creating Queries
Calculations in Queries
Creating a Lookup Database
Sorting and Filtering
Database Wellness
Navigation Pane Protection
Importing and Exporting Records
Formatting Tables
Adding Transactional Records
Adding Records to a Table
Macro Techniques
Understanding VBA
Working With Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Huddersfield
- 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 ... Using the For Each...Next Structure
- See Training Course Details...
Using the Select Case...End Select Structure
Using the If...End If Decision Structures
Working with Methods
Understanding Constants
Writing an Error-Handling Routine
Working with Variable Lifetime
Using Break Mode during Run Mode
Setting Breakpoints
Using the Do...Loop Structure
Navigating the Access Object Hierarchy
Using Expressions, Variables, and Intrinsic Functions
Using Debugging Tools
Understanding Errors
Considering Variable Scope and Lifetime Together
Understanding Data Types
Working with the Application Object
Understanding Objects
Email us about this courses
Other Huddersfield Enable Technology Training Courses
Excel 365 Basic - Huddersfield Excel Training Courses
TSQL Huddersfield Training Courses
VBA Huddersfield Training Courses
Data Warehouse - Huddersfield SQL Training Courses
JQuery Mobile Huddersfield Training Courses
Excel Power Pivot - Huddersfield Excel Training Courses