ACCESS TRAINING COURSES MILTON KEYNES
About Enable Technology Milton Keynes Access Training Courses
We have a twenty year history of providing skills based Access industry training. The tutor delivering the course will be a Microsoft certified expert. Every person attending a Access course will be provided with training materials and practice files to retain 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.
Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a socially distanced local training venue in Milton Keynes. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Total Telecommunications Limited, Shell UK Oil Products Ltd, Queen's Medical Centre Nottingham, Vodafone Group Services, Carillion PLC, Royal & Sun Alliance Group PLC, Capita Group PLC and Fujistu PLC.
Microsoft Access
- 2 day course
- Location: Milton Keynes
- 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 ... Relational Database Design
- See Training Course Details...
Adding Records to a Table
Understanding VBA
Working With Records
Database Security
Database Wellness
Importing and Exporting Records
Action Queries
Macros on Forms
Modifying Table Structures
Creating a Lookup Database
Multi Table Queries
Creating and Using Forms
Querying Techniques
Creating and Using Macros
Creating a Relational Database
Calculations in Queries
Aggregation Queries
Data Validation
Modifying Forms
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Milton Keynes
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Declaring Variables
- See Training Course Details...
Working with Events
Understanding Procedures
Understanding the Order of Events
Working with Inline Error Handling
Working with the Code Editor
Using the CacheSize Property - Optional
Working with Recordsets
Setting Breakpoints
Considering Variable Scope and Lifetime Together
Using the If...End If Decision Structures
Stepping through Code
Understanding the Development Environment
Calling Procedures
Navigating the Access Object Hierarchy
Using the For...Next Structure
Using Visual Basic Help
Understanding Control-of-Flow Structures
Email us about this courses
Other Milton Keynes Enable Technology Training Courses
JQuery Mobile Milton Keynes Training Courses
SSIS - Milton Keynes SQL Server Integration Services Training Courses
Excel 365 Basic - Milton Keynes Excel Training Courses
SQL - Milton Keynes SQL Training Courses
JQuery - Milton Keynes JavaScript Training Courses
Data Warehouse Milton Keynes Training Courses