ACCESS TRAINING COURSES CHADDERTON
About Enable Technology Chadderton Access Training Courses
Enable Technology specialise in succinct skills based Access training. We guarantee the training will be delivered by a Microsoft certified expert. We will issue each Access training participant with learning resources which they can refer to post training. 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 set up a training lab at your premises and deliver Access courses onsite at your site. The Access course could also be scheduled at a socially distanced site near you in Chadderton. We are happy to modify the Access syllabus to match your teams training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to 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 Cadbury PLC, Norfolk Police Constabulary, Norwich Union PLC, Yell Group PLC, Royal Air Force, Keele University, West Bromwich Building Society and Nuclear Engineering Services.
Microsoft Access
- 2 day course
- Location: Chadderton
- 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 ... Creating Queries
- See Training Course Details...
Querying Techniques
Adding Transactional Records
Data Validation
Creating a Lookup Database
Formatting Tables
Getting to Know Access
Creating a Relational Database
Navigation Pane Protection
Action Queries
Database Wellness
Calculations in Queries
Creating and Using Reports
Parameter Queries
DIY Forms
Using a Navigation Form
Understanding VBA
Macro Techniques
Importing and Exporting Records
Adding Records to a Table
Setting Table Relationships
Microsoft Access Programming Using VBA
- 3 day course
- Location: Chadderton
- 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 ... Trapping Errors with the On Error Statement
- See Training Course Details...
Setting Break Expressions
Using the If...End If Decision Structures
Navigating the Access Object Hierarchy
Declaring and Creating Object Variables
Locking Records for Updating
Using the CacheSize Property - Optional
Creating a Sub Procedure
Calling Procedures
Using the Do...Loop Structure
Organizing Code and Procedures
Why Program in Access?
Creating a Standard Module
Using the Immediate Window to Call Procedures
Understanding Objects
Understanding Error Handling
Understanding the Development Environment
Guidelines for use of Branching Structures
Naming Procedures
Working with Events
Email us about this courses
Other Chadderton Enable Technology Training Courses
SSRS - Chadderton SQL Server Reporting Services Training Courses
JQuery Mobile - Chadderton JavaScript Training Courses
VBA - Chadderton Excel Training Courses
JavaScript - Chadderton JavaScript Training Courses
Excel 365 Advanced Chadderton Training Courses
Excel 365 Basic Chadderton Training Courses