ACCESS TRAINING COURSES SUNDERLAND
About Enable Technology Sunderland Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Professionals. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
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 supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. We can also deliver the Access course at a local training venue in Sunderland. We are happy to modify the Access syllabus to match your teams training requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: DHL Express, Fujistu PLC, EDF Energy PLC, Birmingham City Council, Norwich Union PLC, Unipart Group, Boots UK Limited and Keele University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Sunderland
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Introduction to Programming in Access
- See Training Course Details...
Understanding VBA's Error Trapping Options
Working with Procedures and Functions
Handling Errors
Working with Variable Lifetime
Understanding Constants
Using the If...End If Decision Structures
Working with the Application Object
Working with Properties
Using the Object Browser
Using the With Statement
Understanding the Development Environment
Using the For Each...Next Structure
Setting Break Expressions
Working with Methods
Using the For...Next Structure
Understanding Control-of-Flow Structures
Setting Breakpoints
Microsoft Access
- 2 day course
- Location: Sunderland
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Creating a Relational Database
- See Training Course Details...
Macros on Forms
Getting to Know Access
Parameter Queries
Importing and Exporting Records
Creating and Using Macros
Creating a Lookup Database
Understanding VBA
Using a Navigation Form
DIY Forms
Creating and Using Reports
Creating and Using Forms
Working With Records
Navigation Pane Protection
Adding Records to a Table
Relational Database Design
Modifying Table Structures
Calculations in Queries
Database Security
Database Wellness
Aggregation Queries
Email us about this courses
Other Sunderland Enable Technology Training Courses
SSAS - Sunderland SQL Server Analysis Services Training Courses
JQuery Sunderland Training Courses
VBA - Sunderland Excel Training Courses
Data Warehouse Sunderland Training Courses
TSQL - Sunderland SQL Training Courses
SSAS Tabular - Sunderland SQL Server Analysis Services Training Courses