ACCESS TRAINING COURSES WREXHAM
About Enable Technology Wrexham Access Training Courses
Enable Technology specialise in succinct skills based Access training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued Access training manuals they can refer to 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.
Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. We can also deliver the Access course at a local training venue in Wrexham. All Access courses can be customised to meet your particular requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Halfords Group PLC, Yell Group PLC, Dollond & Aitchison Limited, Loughborough University, Birmingham City Council, Royal & Sun Alliance Group PLC, Capita Group PLC and University of Birmingham.
Microsoft Access
- 2 day course
- Location: Wrexham
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Adding Transactional Records
- See Training Course Details...
Parameter Queries
Creating and Using Forms
Adding Records to a Table
Creating a Relational Database
Formatting Tables
Sorting and Filtering
Macro Techniques
Querying Techniques
Creating and Using Reports
Database Wellness
Action Queries
Relational Database Design
Creating Queries
An Introduction to VBA
Aggregation Queries
Multi Table Queries
Calculations in Queries
Data Validation
Understanding VBA
Using a Navigation Form
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wrexham
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Understanding the Form Object
- See Training Course Details...
Using Break Mode during Run Mode
Working with Variable Lifetime
Using Message Boxes
Understanding Classes and Objects
Navigating the Access Object Hierarchy
Using the With Statement
Using Intrinsic Functions
Specifying a Recordset Cursor Type
Using the Do...Loop Structure
Using the For Each...Next Structure
Understanding Control-of-Flow Structures
Understanding the DoCmd Object
Working with Events
Understanding the Err Object
Working with Recordsets
Understanding Procedures
Creating a Standard Module
Using Input Boxes
Understanding Recordset Cursor Properties - Optional
Email us about this courses
Other Wrexham Enable Technology Training Courses
Excel 365 Advanced Wrexham Training Courses
SSAS - Wrexham SQL Server Analysis Services Training Courses
Excel 365 Basic Wrexham Training Courses
Excel 365 Intermediate Wrexham Training Courses
Power BI - Wrexham Microsoft Power BI Training Courses
Power Query Wrexham Training Courses