ACCESS TRAINING COURSES MANCHESTER
About Enable Technology Manchester Access Training Courses
We have a twenty year history of providing skills based Access industry training. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a venue near you in Manchester. We are happy to discuss customising the course content should you have particular Access training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Birmingham City Council, Cadbury PLC, TalkTalk Direct Limited, Norwich Union PLC, West Bromwich Building Society, DHL Express, Total Telecommunications Limited and Nationwide Building Society Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Manchester
- 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 ... Declaring and Creating Object Variables
- See Training Course Details...
Understanding Constants
Handling Errors
Understanding Modules
Working with Variable Scope
Working with the ADODB Recordset Object
Working with Recordsets
Using the For Each...Next Structure
Using the Do...Loop Structure
Using Message Boxes
Working with Inline Error Handling
Understanding Collections
Considering Variable Scope and Lifetime Together
Guidelines for use of Branching Structures
Working with the Application Object
Organizing Code and Procedures
Navigating the Access Object Hierarchy
Creating a Sub Procedure
Using the Immediate Window to Call Procedures
Using Intrinsic Constants
Microsoft Access
- 2 day course
- Location: Manchester
- 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 ... Getting to Know Access
- See Training Course Details...
Creating and Using Forms
Creating a Lookup Database
Creating and Using Macros
Data Validation
Creating Queries
Database Security
Formatting Tables
Adding Records to a Table
Modifying Forms
Adding Transactional Records
Aggregation Queries
An Introduction to VBA
Sorting and Filtering
Creating and Using Reports
Working With Records
Action Queries
Multi Table Queries
Setting Table Relationships
Macros on Forms
Relational Database Design
Email us about this courses
Other Manchester Enable Technology Training Courses
JavaScript Manchester Training Courses
PL/SQL - Manchester SQL Training Courses
SSAS Tabular Manchester Training Courses
SSAS - Manchester SQL Server Analysis Services Training Courses
SQL Manchester Training Courses
Excel 365 Advanced - Manchester Excel Training Courses