ACCESS TRAINING COURSES WILTSHIRE
About Enable Technology Wiltshire Access Training Courses
Enable Technology specialise in succinct skills based Access training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. 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 provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. We can also deliver the Access course at a local training venue in Wiltshire. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time 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 TalkTalk Direct Limited, Capita Group PLC, Fujistu PLC, Yell Group PLC, Shell UK Oil Products Ltd, Nationwide Building Society Limited, Royal Air Force and Barclays Bank PLC.
Microsoft Access
- 2 day course
- Location: Wiltshire
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Adding Records to a Table
- See Training Course Details...
Working With Records
Modifying Table Structures
An Introduction to VBA
Macro Techniques
Adding Transactional Records
Database Security
Querying Techniques
Parameter Queries
Formatting Tables
Setting Table Relationships
Getting to Know Access
Data Validation
Importing and Exporting Records
Sorting and Filtering
Relational Database Design
Creating a Relational Database
Creating a Lookup Database
Using a Navigation Form
Database Wellness
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wiltshire
- 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 the Development Environment
- See Training Course Details...
Working with Boolean Expressions
Trapping Errors with the On Error Statement
Stepping through Code
Using the Immediate Window to Call Procedures
Understanding Modules
Using Debugging Tools
Navigating the Access Object Hierarchy
Understanding Data Types
Using the With Statement
Working with the Code Editor
Creating a Standard Module
Understanding Classes and Objects
Setting Break Expressions
Declaring Variables
Using the For Each...Next Structure
Calling Procedures
Using the If...End If Decision Structures
Working with Methods
Email us about this courses
Other Wiltshire Enable Technology Training Courses
Excel Power Pivot - Wiltshire Excel Training Courses
Excel 365 Basic - Wiltshire Excel Training Courses
SSIS Wiltshire Training Courses
SSAS Tabular Wiltshire Training Courses
Data Warehouse Wiltshire Training Courses
SSRS Wiltshire Training Courses