ACCESS TRAINING COURSES STOKE ON TRENT
About Enable Technology Stoke On Trent Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). We provide every candidate with Access training materials which they keep 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.
We provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a Access course at an alternative training site in Stoke On Trent. We are more than happy to incorporate additional topics to accommodate your organisations Access 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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Fujistu PLC, Shell UK Oil Products Ltd, Nationwide Building Society Limited, Birmingham City Council, Canadian High Commission, Queen's Medical Centre Nottingham, Birmingham City University and TalkTalk Direct Limited.
Microsoft Access
- 2 day course
- Location: Stoke On Trent
- 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 ... Multi Table Queries
- See Training Course Details...
Sorting and Filtering
Creating and Using Reports
DIY Forms
Querying Techniques
Using a Navigation Form
Creating and Using Macros
Modifying Table Structures
Calculations in Queries
Setting Table Relationships
Aggregation Queries
Adding Transactional Records
Importing and Exporting Records
Creating a Relational Database
Designing a Lookup Database
Adding Records to a Table
Macros on Forms
Database Security
Working With Records
Navigation Pane Protection
Modifying Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stoke On Trent
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with the Code Editor
- See Training Course Details...
Why Program in Access?
Working with Methods
Organizing Code and Procedures
Understanding Classes and Objects
Stepping through Code
Specifying a Recordset Cursor Location - Optional
Creating a Standard Module
Understanding Procedures
Using Debugging Tools
Working with Events
Understanding the Form Object
Introduction to Programming in Access
Using the With Statement
Understanding Errors
Understanding the Development Environment
Creating a Sub Procedure
Controlling Program Execution
Email us about this courses
Other Stoke On Trent Enable Technology Training Courses
Data Warehouse - Stoke On Trent SQL Training Courses
Excel 365 Basic Stoke On Trent Training Courses
JQuery - Stoke On Trent JavaScript Training Courses
Report Builder - Stoke On Trent SQL Server Reporting Services Training Courses
JQuery Mobile Stoke On Trent Training Courses
Excel 365 Intermediate - Stoke On Trent Excel Training Courses