ACCESS TRAINING COURSES HARROGATE
About Enable Technology Harrogate Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given Access courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver Access training courses onsite at your premises. Another option is we can organise a local training site in Harrogate. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Wolverhampton City Council, Loughborough University, Royal Air Force, Birmingham Heartlands Hospital, DHL Express, National Power PLC, Lloyds TSB Bank PLC and Yell Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Harrogate
- 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 ... Understanding Data Types
- See Training Course Details...
Calling Procedures
Understanding the DoCmd Object
Understanding Collections
Organizing Code and Procedures
Working with Boolean Expressions
Naming Procedures
Working with the Application Object
Using the CacheSize Property - Optional
Using Intrinsic Constants
Using the Select Case...End Select Structure
Understanding Constants
Working with Methods
Working with Procedures and Functions
Debugging Code
Understanding Procedures
Using Intrinsic Functions
Setting Breakpoints
Understanding Recordset Cursor Properties - Optional
Using Input Boxes
Microsoft Access
- 2 day course
- Location: Harrogate
- 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
Using a Navigation Form
Parameter Queries
Setting Table Relationships
Modifying Forms
Understanding VBA
Creating a Lookup Database
Action Queries
Formatting Tables
Calculations in Queries
Navigation Pane Protection
Getting to Know Access
Creating a Relational Database
Aggregation Queries
Adding Records to a Table
Macro Techniques
Relational Database Design
Adding Transactional Records
DIY Forms
An Introduction to VBA
Email us about this courses
Other Harrogate Enable Technology Training Courses
TSQL - Harrogate SQL Training Courses
JavaScript Harrogate Training Courses
Power Query - Harrogate Excel Training Courses
JQuery Mobile - Harrogate JavaScript Training Courses
VBA Harrogate Training Courses
PL/SQL Harrogate Training Courses