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. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Courses are instructor led and groups sizes small. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Cirencester. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: TalkTalk Direct Limited, Homeserve PLC, Halfords Group PLC, Wolverhampton City Council, DHL Express, Lloyds TSB Bank PLC, Canadian High Commission and Keele University.
Microsoft Access
- 2 day course
- Location: Cirencester
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Database Wellness
- See Training Course Details...
Relational Database Design
Database Security
Multi Table Queries
Action Queries
Creating a Relational Database
Setting Table Relationships
Creating and Using Macros
Adding Records to a Table
Data Validation
Adding Transactional Records
Aggregation Queries
Sorting and Filtering
DIY Forms
Designing a Lookup Database
Navigation Pane Protection
An Introduction to VBA
Working With Records
Formatting Tables
Parameter Queries
Using a Navigation Form
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cirencester
- 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 ... Navigating the Access Object Hierarchy
- See Training Course Details...
Creating a Standard Module
Working with the ADODB Recordset Object
Using the For...Next Structure
Using the If...End If Decision Structures
Using Message Boxes
Introduction to Programming in Access
Working with the Application Object
Understanding Recordset Cursor Properties - Optional
Declaring Variables
Writing an Error-Handling Routine
Using Debugging Tools
Specifying a Recordset Cursor Type
Working with Recordsets
Understanding Objects
Understanding Procedures
Using the For Each...Next Structure
Using the Object Browser
Working with Properties
Understanding Control-of-Flow Structures
Email us about this courses
Other Cirencester Enable Technology Training Courses
Excel 365 Intermediate Cirencester Training Courses
SSIS - Cirencester SQL Server Integration Services Training Courses
SSRS - Cirencester SQL Server Reporting Services Training Courses
Excel Power Pivot - Cirencester Excel Training Courses
Report Builder Cirencester Training Courses
SSAS - Cirencester SQL Server Analysis Services Training Courses