ACCESS TRAINING COURSES STOKE ON TRENT
About Enable Technology Stoke On Trent Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to 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.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in Stoke On Trent. Every Access course can be modified to meet your bespoke 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Shell UK Oil Products Ltd, Queen's Medical Centre Nottingham, Carillion PLC, Cadbury PLC, South Staffordshire Water PLC, Birmingham City University, DHL Express and Yell Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stoke On Trent
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Classes and Objects
- See Training Course Details...
Specifying a Recordset Cursor Location - Optional
Understanding the Development Environment
Working with Variable Lifetime
Naming Procedures
Using Visual Basic Help
Using the With Statement
Working with the Application Object
Using Input Boxes
Understanding Modules
Controlling Program Execution
Working with Events
Trapping Errors with the On Error Statement
Using Message Boxes
Creating a Sub Procedure
Using the Immediate Window to Call Procedures
Using Break Mode during Run Mode
Understanding the Form Object
Working with the ADODB Recordset Object
Using the For Each...Next Structure
Understanding the Order of Events
Microsoft Access
- 2 day course
- Location: Stoke On Trent
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... DIY Forms
- See Training Course Details...
Navigation Pane Protection
Modifying Forms
An Introduction to VBA
Designing a Lookup Database
Setting Table Relationships
Action Queries
Importing and Exporting Records
Querying Techniques
Adding Records to a Table
Creating a Relational Database
Adding Transactional Records
Database Wellness
Creating and Using Forms
Macros on Forms
Relational Database Design
Creating and Using Reports
Calculations in Queries
Macro Techniques
Using a Navigation Form
Getting to Know Access
Email us about this courses
Other Stoke On Trent Enable Technology Training Courses
JQuery Mobile Stoke On Trent Training Courses
SSRS - Stoke On Trent SQL Server Reporting Services Training Courses
Excel 365 Basic - Stoke On Trent Excel Training Courses
Excel 365 Advanced - Stoke On Trent Excel Training Courses
JavaScript - Stoke On Trent JavaScript Training Courses
Power BI - Stoke On Trent Microsoft Power BI Training Courses