ACCESS TRAINING COURSES SKELMERSDALE
About Enable Technology Skelmersdale Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. 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 Skelmersdale. The Access syllabus can be adjusted and additional topics incorporated if helpful.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Halfords Group PLC, Birmingham City Council, South Staffordshire Water PLC, Birmingham City University, Aston University, Loughborough University, TalkTalk Direct Limited and Dollond & Aitchison Limited.
Microsoft Access
- 2 day course
- Location: Skelmersdale
- 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 ... Getting to Know Access
- See Training Course Details...
Parameter Queries
Setting Table Relationships
Navigation Pane Protection
Creating and Using Macros
Creating a Lookup Database
Creating and Using Reports
Querying Techniques
Formatting Tables
Creating and Using Forms
Adding Records to a Table
Calculations in Queries
Working With Records
Aggregation Queries
Database Security
An Introduction to VBA
Macros on Forms
Adding Transactional Records
Creating Queries
Modifying Table Structures
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Skelmersdale
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Working with Procedures and Functions
- See Training Course Details...
Working with Variable Lifetime
Understanding Classes and Objects
Understanding VBA's Error Trapping Options
Using the If...End If Decision Structures
Working with Variable Scope
Understanding the Development Environment
Controlling Program Execution
Understanding Expressions and Statements
Setting Breakpoints
Using the Immediate Window to Call Procedures
Using Intrinsic Constants
Using Visual Basic Help
Understanding Modules
Understanding Recordset Cursor Properties - Optional
Using the Select Case...End Select Structure
Declaring and Creating Object Variables
Understanding Control-of-Flow Structures
Email us about this courses
Other Skelmersdale Enable Technology Training Courses
JQuery Skelmersdale Training Courses
SSAS Tabular Skelmersdale Training Courses
SSIS - Skelmersdale SQL Server Integration Services Training Courses
Excel Power Pivot Skelmersdale Training Courses
Oracle SQL - Skelmersdale SQL Training Courses
VBA Skelmersdale Training Courses