ACCESS TRAINING COURSES CHORLEY
About Enable Technology Chorley Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
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 socially distanced venue in Chorley. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are DHL Express, Yell Group PLC, West Bromwich Building Society, Wolverhampton City Council, Queen's Medical Centre Nottingham, Nationwide Building Society Limited, Barclays Bank PLC and Nuclear Engineering Services.
Microsoft Access
- 2 day course
- Location: Chorley
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Macros on Forms
- See Training Course Details...
Using a Navigation Form
Creating and Using Macros
Creating Queries
Creating a Relational Database
Getting to Know Access
Designing a Lookup Database
Setting Table Relationships
Relational Database Design
Multi Table Queries
Sorting and Filtering
Data Validation
Aggregation Queries
Navigation Pane Protection
Querying Techniques
Action Queries
Macro Techniques
Calculations in Queries
Creating and Using Forms
Creating a Lookup Database
DIY Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Chorley
- 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 ... Specifying a Recordset Cursor Type
- See Training Course Details...
Using Input Boxes
Calling Procedures
Understanding Control-of-Flow Structures
Using Intrinsic Constants
Understanding the Err Object
Working with Variable Lifetime
Writing an Error-Handling Routine
Using the For...Next Structure
Creating a Standard Module
Trapping Errors with the On Error Statement
Introduction to Programming in Access
Understanding the Order of Events
Specifying a Recordset Cursor Location - Optional
Creating a Sub Procedure
Working with Methods
Handling Errors
Declaring and Creating Object Variables
Email us about this courses
Other Chorley Enable Technology Training Courses
Power BI - Chorley Microsoft Power BI Training Courses
TSQL - Chorley SQL Training Courses
PL/SQL - Chorley SQL Training Courses
SSIS Chorley Training Courses
Data Warehouse Chorley Training Courses
Report Builder - Chorley SQL Server Reporting Services Training Courses