ACCESS TRAINING COURSES STOKE ON TRENT
About Enable Technology Stoke On Trent Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. We provide every candidate with Access training materials which they keep after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. If delivery onsite is an issue we will organise a venue near you in Stoke On Trent. We will work with you prior to the course to tailor the Access syllabus to match your 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. Some of our clients are Cadbury PLC, Halfords Group PLC, Countrywide Homes Limited, Carillion PLC, Birmingham Heartlands Hospital, Keele University, Fujistu PLC and Dollond & Aitchison Limited.
Microsoft Access
- 2 day course
- Location: Stoke On Trent
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Modifying Table Structures
- See Training Course Details...
Adding Transactional Records
Querying Techniques
Aggregation Queries
Parameter Queries
Creating Queries
Relational Database Design
Designing a Lookup Database
Creating a Relational Database
Modifying Forms
Creating a Lookup Database
Creating and Using Macros
Adding Records to a Table
Importing and Exporting Records
Using a Navigation Form
Creating and Using Forms
Navigation Pane Protection
Working With Records
Macros on Forms
DIY Forms
Formatting Tables
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stoke On Trent
- 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 Input Boxes
- See Training Course Details...
Understanding Error Handling
Working with Variable Scope
Understanding Constants
Specifying a Recordset Cursor Location - Optional
Using the If...End If Decision Structures
Using the For...Next Structure
Understanding Modules
Working with Methods
Using Intrinsic Constants
Using the With Statement
Using Expressions, Variables, and Intrinsic Functions
Using Message Boxes
Why Program in Access?
Understanding VBA's Error Trapping Options
Calling Procedures
Understanding the Development Environment
Working with Inline Error Handling
Working with the ADODB Recordset Object
Creating a Standard Module
Email us about this courses
Other Stoke On Trent Enable Technology Training Courses
Data Warehouse - Stoke On Trent SQL Training Courses
Report Builder Stoke On Trent Training Courses
SSRS - Stoke On Trent SQL Server Reporting Services Training Courses
DAX Stoke On Trent Training Courses
JavaScript Stoke On Trent Training Courses
SSAS - Stoke On Trent SQL Server Analysis Services Training Courses