ACCESS TRAINING COURSES BEDWORTH
About Enable Technology Bedworth Access Training Courses
Enable Technology specialise in succinct skills based Access training. All Enable Technology tutors are Microsoft certified experts. All course participants are issued Access training manuals they can 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.
Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a course at a local socially distanced venue in Bedworth. The Access syllabus can be modified to accommodate your specific training needs.
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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Birmingham City Council, South Staffordshire Water PLC, Keele University, West Bromwich Building Society, Norfolk Police Constabulary, Cadbury PLC, DHL Express and Norwich Union PLC.
Microsoft Access
- 2 day course
- Location: Bedworth
- 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 ... Macro Techniques
- See Training Course Details...
Aggregation Queries
Macros on Forms
Querying Techniques
Multi Table Queries
Action Queries
Creating Queries
Data Validation
Importing and Exporting Records
Relational Database Design
Database Security
An Introduction to VBA
Sorting and Filtering
Creating and Using Macros
DIY Forms
Modifying Table Structures
Designing a Lookup Database
Parameter Queries
Calculations in Queries
Setting Table Relationships
Creating and Using Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bedworth
- 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 Data Types
- See Training Course Details...
Understanding the Order of Events
Creating a Function Procedure
Working with Procedures and Functions
Understanding Control-of-Flow Structures
Stepping through Code
Specifying a Recordset Cursor Location - Optional
Understanding the Development Environment
Using the For...Next Structure
Using Intrinsic Functions
Guidelines for use of Branching Structures
Writing an Error-Handling Routine
Understanding Objects
Using the Select Case...End Select Structure
Debugging Code
Working with the Code Editor
Working with Variable Lifetime
Working with Recordsets
Using Intrinsic Constants
Understanding Procedures
Email us about this courses
Other Bedworth Enable Technology Training Courses
Excel 365 Advanced Bedworth Training Courses
Power BI Bedworth Training Courses
DAX Bedworth Training Courses
SQL Bedworth Training Courses
VBA - Bedworth Excel Training Courses
Excel 365 Basic Bedworth Training Courses