ACCESS TRAINING COURSES SHROPSHIRE
About Enable Technology Shropshire Access Training Courses
Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Access courses are taught by a Microsoft Certified Solutions Expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Shropshire. The Access syllabus can be modified to accommodate your specific 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 operated primarily in the West Midlands for twenty years. Our clients include: TalkTalk Direct Limited, Shell UK Oil Products Ltd, University of Birmingham, Lloyds TSB Bank PLC, Fujistu PLC, Norwich Union PLC, Royal Air Force and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Shropshire
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Working with Properties
- See Training Course Details...
Using the Do...Loop Structure
Declaring and Creating Object Variables
Understanding VBA's Error Trapping Options
Locking Records for Updating
Using Debugging Tools
Trapping Errors with the On Error Statement
Working with Inline Error Handling
Guidelines for use of Branching Structures
Using the Select Case...End Select Structure
Understanding Modules
Using the CacheSize Property - Optional
Understanding Expressions and Statements
Understanding Control-of-Flow Structures
Understanding Constants
Understanding Data Types
Understanding Procedures
Using the With Statement
Using the Immediate Window to Call Procedures
Microsoft Access
- 2 day course
- Location: Shropshire
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Getting to Know Access
- See Training Course Details...
Adding Records to a Table
Using a Navigation Form
Sorting and Filtering
Understanding VBA
Database Wellness
Relational Database Design
Aggregation Queries
Action Queries
Formatting Tables
Parameter Queries
Database Security
Navigation Pane Protection
An Introduction to VBA
Creating and Using Macros
Creating Queries
Creating and Using Forms
Adding Transactional Records
Creating a Relational Database
Working With Records
Data Validation
Email us about this courses
Other Shropshire Enable Technology Training Courses
Data Warehouse Shropshire Training Courses
VBA Shropshire Training Courses
PL/SQL - Shropshire SQL Training Courses
SQL - Shropshire SQL Training Courses
Excel 365 Intermediate - Shropshire Excel Training Courses
SSAS Tabular Shropshire Training Courses