ACCESS TRAINING COURSES STAFFORDSHIRE
About Enable Technology Staffordshire Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver Access courses at your site. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Keele University, Canadian High Commission, Nationwide Building Society Limited, Nuclear Engineering Services, Shell UK Oil Products Ltd, Cadbury PLC, Loughborough University and Royal & Sun Alliance Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Staffordshire
- 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 ... Understanding Collections
- See Training Course Details...
Why Program in Access?
Using Expressions, Variables, and Intrinsic Functions
Using the Immediate Window to Call Procedures
Creating a Sub Procedure
Introduction to Programming in Access
Using the If...End If Decision Structures
Working with the Application Object
Using the Do...Loop Structure
Understanding Error Handling
Working with Variable Lifetime
Using Visual Basic Help
Naming Procedures
Using Break Mode during Run Mode
Locking Records for Updating
Understanding the Form Object
Understanding the Err Object
Specifying a Recordset Cursor Type
Using the For...Next Structure
Microsoft Access
- 2 day course
- Location: Staffordshire
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... An Introduction to VBA
- See Training Course Details...
Modifying Forms
Understanding VBA
Working With Records
Navigation Pane Protection
Database Security
Adding Records to a Table
Calculations in Queries
Creating Queries
Data Validation
Querying Techniques
Setting Table Relationships
Sorting and Filtering
Modifying Table Structures
Using a Navigation Form
Action Queries
Macros on Forms
Creating a Lookup Database
Multi Table Queries
Formatting Tables
Database Wellness
Email us about this courses
Other Staffordshire Enable Technology Training Courses
SSAS Staffordshire Training Courses
SSRS Staffordshire Training Courses
TSQL Staffordshire Training Courses
VBA - Staffordshire Excel Training Courses
Power Query Staffordshire Training Courses
JQuery Mobile Staffordshire Training Courses