ACCESS TRAINING COURSES EAST MIDLANDS
About Enable Technology East Midlands Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and Access course resources that can be referenced post 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.
Enable Technology offers instructor led training taught by technology specialists. We are set up to deliver Access training courses onsite at your premises. Another way we could deliver the Access course is at a local training site. Every Access course can be modified to meet your bespoke requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Royal Air Force, Yell Group PLC, Canadian High Commission, Shell UK Oil Products Ltd, Birmingham City Council, Fujistu PLC, Aston University and Total Telecommunications Limited.
Microsoft Access
- 2 day course
- Location: East Midlands
- 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 ... Calculations in Queries
- See Training Course Details...
Database Wellness
Sorting and Filtering
Navigation Pane Protection
Data Validation
Understanding VBA
Getting to Know Access
Using a Navigation Form
Creating Queries
Importing and Exporting Records
Creating and Using Forms
Macros on Forms
Creating a Relational Database
Working With Records
Multi Table Queries
Querying Techniques
Action Queries
Modifying Forms
Database Security
An Introduction to VBA
Modifying Table Structures
Microsoft Access Programming Using VBA
- 3 day course
- Location: East Midlands
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Using the With Statement
- See Training Course Details...
Working with Variable Lifetime
Specifying a Recordset Cursor Type
Understanding Collections
Understanding the Form Object
Declaring Variables
Understanding the DoCmd Object
Understanding Data Types
Calling Procedures
Using Visual Basic Help
Debugging Code
Working with Boolean Expressions
Working with the ADODB Recordset Object
Using the Object Browser
Setting Break Expressions
Working with Events
Understanding Recordset Cursor Properties - Optional
Understanding Control-of-Flow Structures
Using Input Boxes
Email us about this courses
Other East Midlands Enable Technology Training Courses
Power BI East Midlands Training Courses
SSAS Tabular East Midlands Training Courses
JQuery Mobile - East Midlands JavaScript Training Courses
Oracle SQL - East Midlands SQL Training Courses
Data Warehouse - East Midlands SQL Training Courses
VBA - East Midlands Excel Training Courses