ACCESS TRAINING COURSES CIRENCESTER
About Enable Technology Cirencester Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The course will always be taught by a Microsoft Certified Professional (MCP). We provide every candidate with Access training materials which they keep after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a Access course at an alternative training site in Cirencester. We are happy to modify the Access syllabus to match your teams training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Cadbury PLC, Lloyds TSB Bank PLC, Aston University, Barclays Bank PLC, West Bromwich Building Society, Carillion PLC, Birmingham Heartlands Hospital and National Power PLC.
Microsoft Access
- 2 day course
- Location: Cirencester
- 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 ... Database Security
- See Training Course Details...
Sorting and Filtering
Getting to Know Access
Creating Queries
Data Validation
Understanding VBA
DIY Forms
Multi Table Queries
Relational Database Design
Creating a Relational Database
Parameter Queries
Creating and Using Reports
Adding Records to a Table
Creating and Using Macros
Action Queries
Database Wellness
Designing a Lookup Database
Working With Records
Modifying Forms
Adding Transactional Records
An Introduction to VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cirencester
- 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 ... Working with Procedures and Functions
- See Training Course Details...
Working with Properties
Trapping Errors with the On Error Statement
Guidelines for use of Branching Structures
Organizing Code and Procedures
Controlling Program Execution
Understanding the Form Object
Setting Breakpoints
Locking Records for Updating
Determining the Value of Expressions
Naming Procedures
Understanding Objects
Working with Inline Error Handling
Using Debugging Tools
Understanding Errors
Understanding Collections
Understanding the DoCmd Object
Using Intrinsic Constants
Email us about this courses
Other Cirencester Enable Technology Training Courses
SSAS Tabular - Cirencester SQL Server Analysis Services Training Courses
Oracle SQL - Cirencester SQL Training Courses
SSAS Cirencester Training Courses
TSQL - Cirencester SQL Training Courses
JQuery Cirencester Training Courses
Excel 365 Basic - Cirencester Excel Training Courses