ACCESS TRAINING COURSES RUGELEY
About Enable Technology Rugeley Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.
Enable Technology training courses are delivered as instructor led courses. We are set up to deliver Access training courses onsite at your premises. We can also deliver the Access course at a local training venue in Rugeley. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are TalkTalk Direct Limited, West Bromwich Building Society, National Power PLC, Total Telecommunications Limited, Queen's Medical Centre Nottingham, Fujistu PLC, Birmingham Heartlands Hospital and Homeserve PLC.
Microsoft Access
- 2 day course
- Location: Rugeley
- 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 Reports
- See Training Course Details...
Setting Table Relationships
Adding Records to a Table
Understanding VBA
Data Validation
DIY Forms
An Introduction to VBA
Creating and Using Macros
Using a Navigation Form
Macro Techniques
Creating a Lookup Database
Working With Records
Calculations in Queries
Sorting and Filtering
Creating Queries
Creating a Relational Database
Macros on Forms
Modifying Forms
Aggregation Queries
Designing a Lookup Database
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rugeley
- 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 Procedures
- See Training Course Details...
Understanding Constants
Using Debugging Tools
Working with the ADODB Recordset Object
Understanding Classes and Objects
Understanding Collections
Using the With Statement
Working with Properties
Understanding VBA's Error Trapping Options
Working with Recordsets
Using the Select Case...End Select Structure
Working with Boolean Expressions
Working with Variable Scope
Declaring and Creating Object Variables
Understanding Modules
Working with the Code Editor
Understanding the Order of Events
Understanding Objects
Naming Procedures
Email us about this courses
Other Rugeley Enable Technology Training Courses
SSRS Rugeley Training Courses
JQuery Mobile - Rugeley JavaScript Training Courses
Oracle SQL Rugeley Training Courses
Excel Power Pivot - Rugeley Excel Training Courses
Data Warehouse - Rugeley SQL Training Courses
Excel 365 Intermediate - Rugeley Excel Training Courses