ACCESS TRAINING COURSES STRETFORD
About Enable Technology Stretford Access Training Courses
Enable Technology specialise in succinct skills based Access training. The course will always be taught by a Microsoft Certified Professional (MCP). We will issue each Access training participant with learning resources which they can refer to post training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the Access course at a socially distanced local training venue in Stretford. All Access courses can be customised to meet your particular 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Countrywide Homes Limited, Norwich Union PLC, Barclays Bank PLC, Queen's Medical Centre Nottingham, Fujistu PLC, EDF Energy PLC, Homeserve PLC and Loughborough University.
Microsoft Access
- 2 day course
- Location: Stretford
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Parameter Queries
- See Training Course Details...
Creating Queries
Creating and Using Reports
Adding Transactional Records
Action Queries
Multi Table Queries
Relational Database Design
Creating a Relational Database
Getting to Know Access
Navigation Pane Protection
Working With Records
Aggregation Queries
Creating and Using Macros
Formatting Tables
Querying Techniques
Data Validation
Creating a Lookup Database
Modifying Table Structures
An Introduction to VBA
Importing and Exporting Records
Understanding VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stretford
- 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 ... Understanding Modules
- See Training Course Details...
Understanding Expressions and Statements
Considering Variable Scope and Lifetime Together
Controlling Program Execution
Using Intrinsic Constants
Determining the Value of Expressions
Using Break Mode during Run Mode
Using Intrinsic Functions
Declaring Variables
Writing an Error-Handling Routine
Understanding the Form Object
Creating a Standard Module
Working with Boolean Expressions
Understanding the Err Object
Why Program in Access?
Using Debugging Tools
Calling Procedures
Using the CacheSize Property - Optional
Email us about this courses
Other Stretford Enable Technology Training Courses
JQuery Mobile Stretford Training Courses
JQuery Stretford Training Courses
Excel Power Pivot Stretford Training Courses
Excel 365 Basic - Stretford Excel Training Courses
SSAS Tabular Stretford Training Courses
JavaScript - Stretford JavaScript Training Courses