ACCESS TRAINING COURSES DROITWICH
About Enable Technology Droitwich Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each course participant will be issued with training Access resources which they can continue to use after the 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.
Access courses are taught by a Microsoft Certified Solutions Expert. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a Access course at an alternative training site in Droitwich. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your 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. Some of our clients are Loughborough University, Norfolk Police Constabulary, Queen's Medical Centre Nottingham, Capita Group PLC, Unipart Group, Aston University, Yell Group PLC and Homeserve PLC.
Microsoft Access
- 2 day course
- Location: Droitwich
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Database Wellness
- See Training Course Details...
Parameter Queries
Relational Database Design
Creating and Using Reports
Macro Techniques
Data Validation
Sorting and Filtering
Database Security
An Introduction to VBA
Calculations in Queries
Aggregation Queries
Importing and Exporting Records
Using a Navigation Form
Querying Techniques
Navigation Pane Protection
Formatting Tables
Adding Transactional Records
Working With Records
Setting Table Relationships
Getting to Know Access
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Droitwich
- 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 ... Naming Procedures
- See Training Course Details...
Creating a Sub Procedure
Controlling Program Execution
Working with Variable Scope
Using the For Each...Next Structure
Using the If...End If Decision Structures
Understanding Data Types
Using Input Boxes
Declaring Variables
Introduction to Programming in Access
Working with Procedures and Functions
Working with Methods
Using the CacheSize Property - Optional
Understanding the Form Object
Understanding the DoCmd Object
Using Break Mode during Run Mode
Working with Boolean Expressions
Using Message Boxes
Handling Errors
Email us about this courses
Other Droitwich Enable Technology Training Courses
Report Builder - Droitwich SQL Server Reporting Services Training Courses
SSAS Tabular - Droitwich SQL Server Analysis Services Training Courses
Oracle SQL - Droitwich SQL Training Courses
JavaScript - Droitwich JavaScript Training Courses
Excel 365 Intermediate - Droitwich Excel Training Courses
VBA - Droitwich Excel Training Courses