ACCESS TRAINING COURSES MORECAMBE
About Enable Technology Morecambe Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. We provide every candidate with Access training materials which they keep after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another way we could deliver the Access course is at a local training site. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are National Power PLC, Birmingham City Council, Lloyds TSB Bank PLC, Norfolk Police Constabulary, EDF Energy PLC, Halfords Group PLC, Yell Group PLC and Vodafone Group Services.
Microsoft Access
- 2 day course
- Location: Morecambe
- 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 ... Setting Table Relationships
- See Training Course Details...
Creating and Using Macros
Designing a Lookup Database
Relational Database Design
Parameter Queries
Macros on Forms
Creating and Using Forms
Action Queries
Creating a Relational Database
Understanding VBA
Navigation Pane Protection
Adding Transactional Records
Using a Navigation Form
Creating Queries
Aggregation Queries
Creating and Using Reports
Calculations in Queries
Modifying Table Structures
DIY Forms
Importing and Exporting Records
Sorting and Filtering
Microsoft Access Programming Using VBA
- 3 day course
- Location: Morecambe
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Using the Object Browser
- See Training Course Details...
Understanding Classes and Objects
Writing an Error-Handling Routine
Using Input Boxes
Understanding Objects
Controlling Program Execution
Using Intrinsic Constants
Understanding Procedures
Using Intrinsic Functions
Trapping Errors with the On Error Statement
Using the Do...Loop Structure
Using Break Mode during Run Mode
Understanding the DoCmd Object
Understanding Error Handling
Using the CacheSize Property - Optional
Working with the ADODB Recordset Object
Specifying a Recordset Cursor Location - Optional
Using the For Each...Next Structure
Working with Events
Considering Variable Scope and Lifetime Together
Email us about this courses
Other Morecambe Enable Technology Training Courses
SSAS - Morecambe SQL Server Analysis Services Training Courses
TSQL - Morecambe SQL Training Courses
Excel 365 Advanced Morecambe Training Courses
JavaScript Morecambe Training Courses
SSAS Tabular Morecambe Training Courses
VBA - Morecambe Excel Training Courses