ACCESS TRAINING COURSES RUGBY
About Enable Technology Rugby Access Training Courses
We are a company that provides short intensive Access training courses. The training will be delivered by a Microsoft professional with development experience. All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. We can also deliver the Access course at a socially distanced local training venue in Rugby. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Total Telecommunications Limited, Aston University, University of Birmingham, Countrywide Homes Limited, West Bromwich Building Society, DHL Express, Birmingham Heartlands Hospital and Loughborough University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rugby
- 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 ... Using the For...Next Structure
- See Training Course Details...
Working with Variable Lifetime
Working with the ADODB Recordset Object
Working with Events
Stepping through Code
Understanding Control-of-Flow Structures
Working with Methods
Understanding Constants
Using Visual Basic Help
Navigating the Access Object Hierarchy
Determining the Value of Expressions
Creating a Standard Module
Working with Procedures and Functions
Understanding Recordset Cursor Properties - Optional
Understanding Objects
Creating a Sub Procedure
Microsoft Access
- 2 day course
- Location: Rugby
- 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 ... Querying Techniques
- See Training Course Details...
Working With Records
Creating a Relational Database
Data Validation
Navigation Pane Protection
Designing a Lookup Database
Macro Techniques
Parameter Queries
DIY Forms
Creating and Using Reports
Setting Table Relationships
Adding Records to a Table
Action Queries
Creating and Using Forms
Formatting Tables
Database Wellness
Importing and Exporting Records
Relational Database Design
Creating a Lookup Database
Creating and Using Macros
Using a Navigation Form
Email us about this courses
Other Rugby Enable Technology Training Courses
Oracle SQL - Rugby SQL Training Courses
PL/SQL - Rugby SQL Training Courses
SSAS Rugby Training Courses
TSQL - Rugby SQL Training Courses
JavaScript - Rugby JavaScript Training Courses
Excel 365 Advanced - Rugby Excel Training Courses