ACCESS TRAINING COURSES CLWYD
About Enable Technology Clwyd Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a Access course will be provided with training materials and practice files to retain 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.
We provide instructor led training coupled with hands on training. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a socially distanced venue near you in Clwyd. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Some of our clients are GKN PLC, Birmingham City Council, Halfords Group PLC, Homeserve PLC, Carillion PLC, Loughborough University, Unipart Group and Fujistu PLC.
Microsoft Access
- 2 day course
- Location: Clwyd
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Creating and Using Reports
- See Training Course Details...
Sorting and Filtering
Setting Table Relationships
Macros on Forms
Aggregation Queries
Creating and Using Forms
Getting to Know Access
Adding Transactional Records
Using a Navigation Form
Adding Records to a Table
Creating a Lookup Database
Creating a Relational Database
Formatting Tables
Modifying Forms
Importing and Exporting Records
Creating and Using Macros
Designing a Lookup Database
Relational Database Design
Navigation Pane Protection
Multi Table Queries
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Clwyd
- 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...
Understanding the Err Object
Using the For...Next Structure
Creating a Standard Module
Working with Methods
Working with Recordsets
Working with the ADODB Recordset Object
Creating a Sub Procedure
Writing an Error-Handling Routine
Understanding Recordset Cursor Properties - Optional
Working with the Application Object
Using Expressions, Variables, and Intrinsic Functions
Using Intrinsic Constants
Guidelines for use of Branching Structures
Understanding the Order of Events
Using Debugging Tools
Using the For Each...Next Structure
Working with Properties
Understanding Control-of-Flow Structures
Locking Records for Updating
Working with the Code Editor
Email us about this courses
Other Clwyd Enable Technology Training Courses
Power BI - Clwyd Microsoft Power BI Training Courses
Power Query - Clwyd Excel Training Courses
Data Warehouse - Clwyd SQL Training Courses
Excel 365 Basic - Clwyd Excel Training Courses
JQuery Mobile - Clwyd JavaScript Training Courses
PL/SQL - Clwyd SQL Training Courses