ACCESS TRAINING COURSES CHELTENHAM
About Enable Technology Cheltenham Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given Access courseware which they can refer to after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local socially distanced venue in Cheltenham. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Norfolk Police Constabulary, Capita Group PLC, National Power PLC, Cadbury PLC, Loughborough University, Norwich Union PLC, EDF Energy PLC and University of Birmingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cheltenham
- 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 ... Using the For Each...Next Structure
- See Training Course Details...
Using Debugging Tools
Using the With Statement
Creating a Sub Procedure
Considering Variable Scope and Lifetime Together
Understanding Error Handling
Working with Methods
Why Program in Access?
Using Message Boxes
Locking Records for Updating
Trapping Errors with the On Error Statement
Understanding the Development Environment
Working with the ADODB Recordset Object
Understanding Recordset Cursor Properties - Optional
Using Input Boxes
Declaring Variables
Using Break Mode during Run Mode
Understanding Modules
Using the For...Next Structure
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 ... Action Queries
- See Training Course Details...
Calculations in Queries
Creating a Lookup Database
Understanding VBA
Importing and Exporting Records
Querying Techniques
Creating Queries
Creating and Using Macros
Data Validation
Creating and Using Forms
An Introduction to VBA
DIY Forms
Navigation Pane Protection
Parameter Queries
Multi Table Queries
Using a Navigation Form
Database Wellness
Getting to Know Access
Database Security
Designing a Lookup Database
Relational Database Design
Email us about this courses
Other Cheltenham Enable Technology Training Courses
DAX Cheltenham Training Courses
JavaScript - Cheltenham JavaScript Training Courses
Excel 365 Intermediate - Cheltenham Excel Training Courses
Report Builder - Cheltenham SQL Server Reporting Services Training Courses
SSRS - Cheltenham SQL Server Reporting Services Training Courses
SSIS Cheltenham Training Courses