ACCESS TRAINING COURSES CANNOCK
About Enable Technology Cannock Access Training Courses
Enable Technology provides practical Access skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local socially distanced training site in Cannock. All Access courses can be customised to meet your particular requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Nuclear Engineering Services, Birmingham City University, Vodafone Group Services, Carillion PLC, Homeserve PLC, GKN PLC, Queen's Medical Centre Nottingham and Keele University.
Microsoft Access
- 2 day course
- Location: Cannock
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Modifying Forms
- See Training Course Details...
An Introduction to VBA
Setting Table Relationships
Getting to Know Access
Action Queries
Creating and Using Forms
Modifying Table Structures
Aggregation Queries
Importing and Exporting Records
Calculations in Queries
Creating and Using Reports
Creating a Lookup Database
DIY Forms
Database Wellness
Data Validation
Creating a Relational Database
Parameter Queries
Querying Techniques
Using a Navigation Form
Database Security
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cannock
- 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 ... Working with Properties
- See Training Course Details...
Using the Select Case...End Select Structure
Understanding Control-of-Flow Structures
Using Visual Basic Help
Using the Object Browser
Using the CacheSize Property - Optional
Specifying a Recordset Cursor Location - Optional
Understanding Data Types
Understanding Error Handling
Understanding Objects
Using Message Boxes
Understanding Collections
Specifying a Recordset Cursor Type
Considering Variable Scope and Lifetime Together
Working with Variable Lifetime
Understanding the DoCmd Object
Working with Procedures and Functions
Working with Boolean Expressions
Email us about this courses
Other Cannock Enable Technology Training Courses
Excel 365 Basic Cannock Training Courses
Excel Power Pivot - Cannock Excel Training Courses
SSAS - Cannock SQL Server Analysis Services Training Courses
Data Warehouse - Cannock SQL Training Courses
DAX Cannock Training Courses
Power BI Cannock Training Courses