ACCESS TRAINING COURSES RUGBY
About Enable Technology Rugby Access Training Courses
Enable Technology provides practical Access skills based technology training. The training will be delivered by a Microsoft professional with development experience. 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.
Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local venue in Rugby. Every Access course can be modified to meet your bespoke requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Fujistu PLC, Norwich Union PLC, GKN PLC, Birmingham City Council, Birmingham Heartlands Hospital, Canadian High Commission, Aston University and Keele University.
Microsoft Access
- 2 day course
- Location: Rugby
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Creating a Lookup Database
- See Training Course Details...
Creating and Using Forms
An Introduction to VBA
Aggregation Queries
Understanding VBA
Macro Techniques
Navigation Pane Protection
Importing and Exporting Records
Adding Transactional Records
Database Security
DIY Forms
Macros on Forms
Using a Navigation Form
Modifying Table Structures
Working With Records
Designing a Lookup Database
Sorting and Filtering
Querying Techniques
Creating and Using Macros
Formatting Tables
Creating Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rugby
- 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 ... Using Input Boxes
- See Training Course Details...
Working with Variable Lifetime
Working with Recordsets
Working with Methods
Calling Procedures
Understanding Objects
Understanding the Err Object
Handling Errors
Creating a Sub Procedure
Understanding Error Handling
Understanding VBA's Error Trapping Options
Understanding Recordset Cursor Properties - Optional
Understanding Modules
Introduction to Programming in Access
Declaring Variables
Naming Procedures
Controlling Program Execution
Declaring and Creating Object Variables
Using the Do...Loop Structure
Working with the Application Object
Working with Procedures and Functions
Email us about this courses
Other Rugby Enable Technology Training Courses
SSIS Rugby Training Courses
VBA Rugby Training Courses
Power Query - Rugby Excel Training Courses
Report Builder - Rugby SQL Server Reporting Services Training Courses
Excel 365 Basic - Rugby Excel Training Courses
PL/SQL Rugby Training Courses