ACCESS TRAINING COURSES NATIONAL
About Enable Technology National Access Training Courses
We have a twenty year history of providing skills based Access industry training. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training Access resources which they can continue to use after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. 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. The Access course could also be scheduled at a socially distanced site near you in National. We are happy to modify the Access syllabus to match your teams training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Unipart Group, West Bromwich Building Society, Nuclear Engineering Services, Carillion PLC, Keele University, Lloyds TSB Bank PLC, Dollond & Aitchison Limited and Norfolk Police Constabulary.
Microsoft Access
- 2 day course
- Location: National
- Telephone on 01952 305730
- 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 ... Macros on Forms
- See Training Course Details...
Multi Table Queries
Importing and Exporting Records
Parameter Queries
Setting Table Relationships
Relational Database Design
Understanding VBA
Creating Queries
Working With Records
Using a Navigation Form
Creating and Using Forms
Modifying Table Structures
Action Queries
Designing a Lookup Database
Navigation Pane Protection
Creating a Relational Database
Getting to Know Access
Database Security
Creating and Using Macros
DIY Forms
Sorting and Filtering
Microsoft Access Programming Using VBA
- 3 day course
- Location: National
- Telephone on 01952 305730
- 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 ... Creating a Sub Procedure
- See Training Course Details...
Specifying a Recordset Cursor Location - Optional
Working with Variable Lifetime
Writing an Error-Handling Routine
Setting Break Expressions
Using Debugging Tools
Naming Procedures
Using Input Boxes
Using the For...Next Structure
Organizing Code and Procedures
Understanding Classes and Objects
Guidelines for use of Branching Structures
Understanding Error Handling
Creating a Standard Module
Setting Breakpoints
Working with Properties
Navigating the Access Object Hierarchy
Email us about this courses
Other National Enable Technology Training Courses
Microsoft Project Level 3 - National Microsoft Project Training Courses
SSAS Tabular National Training Courses
Mobile - National Web Development Training Courses
Crystal 2011 National Training Courses
JQuery National Training Courses
SSRS 2008 National Training Courses