ACCESS TRAINING COURSES MORECAMBE
About Enable Technology Morecambe Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source 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 specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Morecambe. The Access syllabus can be modified to accommodate your specific training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Yell Group PLC, Cadbury PLC, Homeserve PLC, Shell UK Oil Products Ltd, Birmingham City University, Royal & Sun Alliance Group PLC, Royal Air Force and TalkTalk Direct Limited.
Microsoft Access
- 2 day course
- Location: Morecambe
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Creating and Using Macros
- See Training Course Details...
Adding Transactional Records
Creating and Using Forms
Understanding VBA
Creating Queries
DIY Forms
Adding Records to a Table
Getting to Know Access
Using a Navigation Form
Data Validation
Macro Techniques
Formatting Tables
Relational Database Design
Designing a Lookup Database
Macros on Forms
Creating a Relational Database
Sorting and Filtering
Querying Techniques
Aggregation Queries
Modifying Forms
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Morecambe
- 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 ... Introduction to Programming in Access
- See Training Course Details...
Understanding VBA's Error Trapping Options
Using the Select Case...End Select Structure
Working with Boolean Expressions
Using Message Boxes
Writing an Error-Handling Routine
Considering Variable Scope and Lifetime Together
Understanding Classes and Objects
Understanding Constants
Understanding Error Handling
Working with the ADODB Recordset Object
Setting Break Expressions
Creating a Sub Procedure
Understanding Modules
Using Intrinsic Constants
Declaring Variables
Understanding the Form Object
Working with Variable Lifetime
Why Program in Access?
Trapping Errors with the On Error Statement
Email us about this courses
Other Morecambe Enable Technology Training Courses
Excel 365 Basic - Morecambe Excel Training Courses
Report Builder Morecambe Training Courses
Excel 365 Advanced - Morecambe Excel Training Courses
JQuery - Morecambe JavaScript Training Courses
SSIS Morecambe Training Courses
Excel 365 Intermediate Morecambe Training Courses