ACCESS TRAINING COURSES LEEK
About Enable Technology Leek Access Training Courses
Enable Technology specialise in succinct skills based Access training. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training Access resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. 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 Leek. 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. Some of our clients are Fujistu PLC, Royal Air Force, Shell UK Oil Products Ltd, Dollond & Aitchison Limited, EDF Energy PLC, Homeserve PLC, Unipart Group and Norwich Union PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leek
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Organizing Code and Procedures
- See Training Course Details...
Understanding the DoCmd Object
Guidelines for use of Branching Structures
Using the Select Case...End Select Structure
Understanding Control-of-Flow Structures
Working with Methods
Setting Break Expressions
Controlling Program Execution
Understanding Recordset Cursor Properties - Optional
Understanding Collections
Understanding Constants
Understanding the Development Environment
Understanding the Order of Events
Understanding the Err Object
Working with Procedures and Functions
Naming Procedures
Using Intrinsic Functions
Microsoft Access
- 2 day course
- Location: Leek
- 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 ... Database Wellness
- See Training Course Details...
Parameter Queries
An Introduction to VBA
Creating Queries
Data Validation
Macros on Forms
Importing and Exporting Records
Calculations in Queries
Database Security
Designing a Lookup Database
Modifying Table Structures
Using a Navigation Form
Navigation Pane Protection
Creating a Lookup Database
Modifying Forms
Setting Table Relationships
Working With Records
Action Queries
Querying Techniques
Creating and Using Macros
Creating a Relational Database
Email us about this courses
Other Leek Enable Technology Training Courses
Excel 365 Advanced - Leek Excel Training Courses
SSRS - Leek SQL Server Reporting Services Training Courses
Power BI Leek Training Courses
SSAS - Leek SQL Server Analysis Services Training Courses
PL/SQL - Leek SQL Training Courses
Oracle SQL - Leek SQL Training Courses