ACCESS TRAINING COURSES LLANRUMNEY
About Enable Technology Llanrumney Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Access courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a venue near you in Llanrumney. The Access syllabus can be modified to accommodate your specific training needs.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are TalkTalk Direct Limited, Carillion PLC, Birmingham Heartlands Hospital, Countrywide Homes Limited, Shell UK Oil Products Ltd, Aston University, Barclays Bank PLC and Unipart Group.
Microsoft Access
- 2 day course
- Location: Llanrumney
- 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 and Using Macros
- See Training Course Details...
Using a Navigation Form
Creating and Using Forms
Sorting and Filtering
Data Validation
DIY Forms
Relational Database Design
Creating Queries
Parameter Queries
Importing and Exporting Records
Getting to Know Access
Calculations in Queries
Formatting Tables
Adding Transactional Records
Macros on Forms
Navigation Pane Protection
An Introduction to VBA
Creating a Lookup Database
Setting Table Relationships
Aggregation Queries
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llanrumney
- 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 ... Using Expressions, Variables, and Intrinsic Functions
- See Training Course Details...
Using Debugging Tools
Using Intrinsic Functions
Creating a Sub Procedure
Why Program in Access?
Using Input Boxes
Declaring Variables
Understanding the Order of Events
Using the Do...Loop Structure
Understanding Procedures
Specifying a Recordset Cursor Type
Declaring and Creating Object Variables
Using the Immediate Window to Call Procedures
Working with Variable Scope
Working with the Code Editor
Working with Properties
Working with Recordsets
Understanding the DoCmd Object
Working with Methods
Email us about this courses
Other Llanrumney Enable Technology Training Courses
PL/SQL Llanrumney Training Courses
JavaScript Llanrumney Training Courses
Excel 365 Intermediate - Llanrumney Excel Training Courses
VBA - Llanrumney Excel Training Courses
SSIS Llanrumney Training Courses
TSQL Llanrumney Training Courses