ACCESS TRAINING COURSES LIVERPOOL
About Enable Technology Liverpool Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.
Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver Access courses onsite at your site. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to discuss customising the course content should you have particular Access training requirements.
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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: University of Birmingham, Loughborough University, Vodafone Group Services, Yell Group PLC, Fujistu PLC, DHL Express, Royal Air Force and Dollond & Aitchison Limited.
Microsoft Access
- 2 day course
- Location: Liverpool
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Creating Queries
- See Training Course Details...
Formatting Tables
Importing and Exporting Records
Getting to Know Access
Adding Transactional Records
Working With Records
Adding Records to a Table
Database Security
Macros on Forms
Relational Database Design
DIY Forms
Multi Table Queries
Designing a Lookup Database
Database Wellness
Setting Table Relationships
Modifying Table Structures
Data Validation
An Introduction to VBA
Action Queries
Querying Techniques
Macro Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Liverpool
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding Collections
- See Training Course Details...
Working with Variable Scope
Why Program in Access?
Working with Properties
Using Visual Basic Help
Using Expressions, Variables, and Intrinsic Functions
Using Break Mode during Run Mode
Naming Procedures
Understanding Control-of-Flow Structures
Using the Select Case...End Select Structure
Using the For...Next Structure
Using the If...End If Decision Structures
Working with Boolean Expressions
Understanding Error Handling
Understanding the Form Object
Understanding Objects
Understanding the Development Environment
Setting Break Expressions
Specifying a Recordset Cursor Location - Optional
Stepping through Code
Email us about this courses
Other Liverpool Enable Technology Training Courses
JQuery - Liverpool JavaScript Training Courses
SSRS Liverpool Training Courses
JavaScript Liverpool Training Courses
SSAS - Liverpool SQL Server Analysis Services Training Courses
Report Builder - Liverpool SQL Server Reporting Services Training Courses
JQuery Mobile - Liverpool JavaScript Training Courses