ACCESS TRAINING COURSES DENTON
About Enable Technology Denton Access Training Courses
We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a course at a local venue in Denton. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have operated primarily in the West Midlands for twenty years. Our clients include: Yell Group PLC, Vodafone Group Services, Birmingham Heartlands Hospital, Aston University, Capita Group PLC, Nuclear Engineering Services, Lloyds TSB Bank PLC and Carillion PLC.
Microsoft Access
- 2 day course
- Location: Denton
- 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 ... Relational Database Design
- See Training Course Details...
Creating Queries
Multi Table Queries
Creating a Lookup Database
Aggregation Queries
Adding Records to a Table
Sorting and Filtering
Creating and Using Forms
Creating and Using Macros
Action Queries
Macros on Forms
Creating a Relational Database
Navigation Pane Protection
Formatting Tables
Database Security
Parameter Queries
Data Validation
DIY Forms
Querying Techniques
Setting Table Relationships
Using a Navigation Form
Microsoft Access Programming Using VBA
- 3 day course
- Location: Denton
- 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 VBA's Error Trapping Options
- See Training Course Details...
Trapping Errors with the On Error Statement
Introduction to Programming in Access
Working with Recordsets
Considering Variable Scope and Lifetime Together
Understanding Procedures
Understanding Error Handling
Working with the Application Object
Using the Object Browser
Using Debugging Tools
Setting Breakpoints
Understanding Objects
Understanding the Err Object
Working with Variable Lifetime
Understanding the Form Object
Using Expressions, Variables, and Intrinsic Functions
Working with Variable Scope
Using Intrinsic Constants
Understanding Constants
Naming Procedures
Email us about this courses
Other Denton Enable Technology Training Courses
PL/SQL Denton Training Courses
Excel 365 Advanced Denton Training Courses
Oracle SQL - Denton SQL Training Courses
TSQL Denton Training Courses
SSAS Tabular - Denton SQL Server Analysis Services Training Courses
Excel 365 Intermediate - Denton Excel Training Courses