ACCESS TRAINING COURSES TREDEGAR
About Enable Technology Tredegar 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. 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a course at a local socially distanced venue in Tredegar. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are University of Birmingham, Homeserve PLC, National Power PLC, EDF Energy PLC, Dollond & Aitchison Limited, Norwich Union PLC, Royal & Sun Alliance Group PLC and GKN PLC.
Microsoft Access
- 2 day course
- Location: Tredegar
- 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 ... Creating a Lookup Database
- See Training Course Details...
Sorting and Filtering
Getting to Know Access
Parameter Queries
Adding Records to a Table
Aggregation Queries
Creating and Using Macros
Calculations in Queries
DIY Forms
Modifying Table Structures
Designing a Lookup Database
Querying Techniques
Modifying Forms
Relational Database Design
Creating and Using Forms
Setting Table Relationships
Working With Records
Database Wellness
Creating and Using Reports
Data Validation
Database Security
Microsoft Access Programming Using VBA
- 3 day course
- Location: Tredegar
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Navigating the Access Object Hierarchy
- See Training Course Details...
Creating a Function Procedure
Guidelines for use of Branching Structures
Specifying a Recordset Cursor Type
Working with Events
Understanding Control-of-Flow Structures
Controlling Program Execution
Debugging Code
Working with Procedures and Functions
Specifying a Recordset Cursor Location - Optional
Understanding Constants
Using Expressions, Variables, and Intrinsic Functions
Understanding the Form Object
Stepping through Code
Creating a Sub Procedure
Using the For...Next Structure
Creating a Standard Module
Understanding Classes and Objects
Understanding Error Handling
Email us about this courses
Other Tredegar Enable Technology Training Courses
SQL - Tredegar SQL Training Courses
Power Query Tredegar Training Courses
Data Warehouse Tredegar Training Courses
VBA - Tredegar Excel Training Courses
PL/SQL Tredegar Training Courses
Excel 365 Basic Tredegar Training Courses