ACCESS TRAINING COURSES SALE
About Enable Technology Sale Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. We guarantee the training will be delivered by a Microsoft certified expert. We will issue each Access training participant with learning resources which they can refer to post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Sale. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have operated primarily in the West Midlands for twenty years. Our clients include: TalkTalk Direct Limited, Homeserve PLC, Vodafone Group Services, Barclays Bank PLC, Shell UK Oil Products Ltd, Countrywide Homes Limited, Yell Group PLC and Royal & Sun Alliance Group PLC.
Microsoft Access
- 2 day course
- Location: Sale
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Aggregation Queries
Creating a Relational Database
Creating Queries
Modifying Forms
An Introduction to VBA
Querying Techniques
Using a Navigation Form
Importing and Exporting Records
Adding Transactional Records
Data Validation
Calculations in Queries
Macros on Forms
Creating and Using Reports
Modifying Table Structures
Macro Techniques
Parameter Queries
Formatting Tables
Database Security
Action Queries
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Sale
- 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 ... Writing an Error-Handling Routine
- See Training Course Details...
Using the For...Next Structure
Using the Do...Loop Structure
Understanding Data Types
Considering Variable Scope and Lifetime Together
Understanding Classes and Objects
Trapping Errors with the On Error Statement
Understanding Procedures
Creating a Standard Module
Using the CacheSize Property - Optional
Specifying a Recordset Cursor Type
Declaring and Creating Object Variables
Using the With Statement
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Controlling Program Execution
Understanding VBA's Error Trapping Options
Setting Break Expressions
Understanding Control-of-Flow Structures
Using Break Mode during Run Mode
Email us about this courses
Other Sale Enable Technology Training Courses
Excel 365 Advanced - Sale Excel Training Courses
Power BI Sale Training Courses
TSQL - Sale SQL Training Courses
SSAS Tabular - Sale SQL Server Analysis Services Training Courses
Excel 365 Basic - Sale Excel Training Courses
DAX - Sale Excel Training Courses