ACCESS TRAINING COURSES CHELTENHAM
About Enable Technology Cheltenham Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a Access course at an alternative training site in Cheltenham. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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 Unipart Group, Queen's Medical Centre Nottingham, Total Telecommunications Limited, Countrywide Homes Limited, Dollond & Aitchison Limited, Boots UK Limited, EDF Energy PLC and Norfolk Police Constabulary.
Microsoft Access
- 2 day course
- Location: Cheltenham
- 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 ... Aggregation Queries
- See Training Course Details...
Creating and Using Reports
Working With Records
Creating Queries
Multi Table Queries
Using a Navigation Form
Macro Techniques
Action Queries
Calculations in Queries
Formatting Tables
Parameter Queries
Designing a Lookup Database
An Introduction to VBA
Database Wellness
DIY Forms
Adding Records to a Table
Modifying Table Structures
Creating and Using Forms
Understanding VBA
Sorting and Filtering
Getting to Know Access
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cheltenham
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding the Err Object
- See Training Course Details...
Considering Variable Scope and Lifetime Together
Why Program in Access?
Understanding Control-of-Flow Structures
Using Intrinsic Constants
Using Intrinsic Functions
Working with Properties
Trapping Errors with the On Error Statement
Declaring and Creating Object Variables
Creating a Sub Procedure
Handling Errors
Understanding Procedures
Understanding Collections
Using the If...End If Decision Structures
Naming Procedures
Using the Select Case...End Select Structure
Understanding Recordset Cursor Properties - Optional
Understanding VBA's Error Trapping Options
Email us about this courses
Other Cheltenham Enable Technology Training Courses
JavaScript Cheltenham Training Courses
Report Builder Cheltenham Training Courses
VBA Cheltenham Training Courses
DAX - Cheltenham Excel Training Courses
Excel 365 Basic - Cheltenham Excel Training Courses
Power Query - Cheltenham Excel Training Courses