ACCESS TRAINING COURSES NOTTINGHAM
About Enable Technology Nottingham Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant is given Access courseware which they can refer to after the training. 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. We are set up to deliver Access training courses onsite at your premises. We also offer the option of scheduling of Access course at a socially distanced venue near you in Nottingham. We are happy to modify the Access syllabus to match your teams training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Lloyds TSB Bank PLC, Norfolk Police Constabulary, Halfords Group PLC, Carillion PLC, Norwich Union PLC, Queen's Medical Centre Nottingham, GKN PLC and National Power PLC.
Microsoft Access
- 2 day course
- Location: Nottingham
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Creating Queries
- See Training Course Details...
Relational Database Design
Working With Records
Importing and Exporting Records
Creating a Lookup Database
Macros on Forms
Formatting Tables
Querying Techniques
Adding Records to a Table
Data Validation
Parameter Queries
Designing a Lookup Database
Navigation Pane Protection
Using a Navigation Form
Multi Table Queries
Sorting and Filtering
Calculations in Queries
Action Queries
DIY Forms
Creating and Using Reports
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Nottingham
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Working with Variable Scope
- See Training Course Details...
Understanding Objects
Using Intrinsic Functions
Working with Variable Lifetime
Using the Object Browser
Understanding Modules
Using the CacheSize Property - Optional
Understanding VBA's Error Trapping Options
Understanding Data Types
Organizing Code and Procedures
Working with Properties
Using the With Statement
Why Program in Access?
Understanding the DoCmd Object
Introduction to Programming in Access
Working with Recordsets
Understanding Constants
Understanding Collections
Calling Procedures
Working with Inline Error Handling
Email us about this courses
Other Nottingham Enable Technology Training Courses
Oracle SQL - Nottingham SQL Training Courses
PL/SQL - Nottingham SQL Training Courses
Excel 365 Basic - Nottingham Excel Training Courses
JavaScript - Nottingham JavaScript Training Courses
SSAS Nottingham Training Courses
VBA Nottingham Training Courses