ACCESS TRAINING COURSES CANNOCK
About Enable Technology Cannock Access Training Courses
Enable Technology provides practical Access skills based technology training. The training will be delivered by a Microsoft professional with development experience. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a course at a local venue in Cannock. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training 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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Nationwide Building Society Limited, DHL Express, Capita Group PLC, Keele University, Queen's Medical Centre Nottingham, Nuclear Engineering Services, Royal & Sun Alliance Group PLC and Birmingham Heartlands Hospital.
Microsoft Access
- 2 day course
- Location: Cannock
- 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 ... Parameter Queries
- See Training Course Details...
Calculations in Queries
Modifying Table Structures
Querying Techniques
Data Validation
Database Security
An Introduction to VBA
Aggregation Queries
Macro Techniques
Getting to Know Access
Relational Database Design
Working With Records
Database Wellness
Creating and Using Reports
Action Queries
Modifying Forms
Creating and Using Macros
Navigation Pane Protection
Adding Records to a Table
Formatting Tables
Setting Table Relationships
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cannock
- 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 ... Using Intrinsic Functions
- See Training Course Details...
Understanding Classes and Objects
Understanding the Order of Events
Using the Select Case...End Select Structure
Understanding VBA's Error Trapping Options
Working with Events
Using the With Statement
Using Break Mode during Run Mode
Working with Variable Scope
Specifying a Recordset Cursor Location - Optional
Declaring Variables
Using the Do...Loop Structure
Understanding the DoCmd Object
Why Program in Access?
Trapping Errors with the On Error Statement
Using Visual Basic Help
Understanding Expressions and Statements
Working with Procedures and Functions
Calling Procedures
Guidelines for use of Branching Structures
Email us about this courses
Other Cannock Enable Technology Training Courses
SSIS - Cannock SQL Server Integration Services Training Courses
Power BI Cannock Training Courses
SSRS - Cannock SQL Server Reporting Services Training Courses
JavaScript Cannock Training Courses
Excel 365 Advanced - Cannock Excel Training Courses
Excel 365 Basic Cannock Training Courses