ACCESS TRAINING COURSES SWINDON
About Enable Technology Swindon Access Training Courses
We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of Access course at a socially distanced venue near you in Swindon. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Capita Group PLC, Unipart Group, University of Birmingham, Queen's Medical Centre Nottingham, GKN PLC, Dollond & Aitchison Limited, Boots UK Limited and Total Telecommunications Limited.
Microsoft Access
- 2 day course
- Location: Swindon
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Setting Table Relationships
- See Training Course Details...
Using a Navigation Form
Creating and Using Forms
Multi Table Queries
Aggregation Queries
Creating Queries
An Introduction to VBA
Designing a Lookup Database
Creating a Lookup Database
Data Validation
Database Security
Modifying Forms
Macro Techniques
Querying Techniques
Parameter Queries
Database Wellness
Macros on Forms
Creating and Using Reports
Understanding VBA
DIY Forms
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: Swindon
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding the Development Environment
- See Training Course Details...
Understanding Constants
Understanding Control-of-Flow Structures
Determining the Value of Expressions
Trapping Errors with the On Error Statement
Using Intrinsic Functions
Understanding the Order of Events
Using the Object Browser
Working with Procedures and Functions
Writing an Error-Handling Routine
Using the Select Case...End Select Structure
Creating a Standard Module
Guidelines for use of Branching Structures
Using the Do...Loop Structure
Understanding Collections
Using the For Each...Next Structure
Setting Break Expressions
Creating a Function Procedure
Declaring and Creating Object Variables
Using Debugging Tools
Handling Errors
Email us about this courses
Other Swindon Enable Technology Training Courses
Power BI - Swindon Microsoft Power BI Training Courses
Excel Power Pivot Swindon Training Courses
VBA - Swindon Excel Training Courses
JavaScript - Swindon JavaScript Training Courses
SSAS Swindon Training Courses
SSAS Tabular Swindon Training Courses