ACCESS TRAINING COURSES BRYN PYDEW
About Enable Technology Bryn Pydew Access Training Courses
Enable Technology specialise in succinct skills based Access training. The course will always be taught by a Microsoft Certified Professional (MCP). 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 training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in Bryn Pydew. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are National Power PLC, Dollond & Aitchison Limited, Queen's Medical Centre Nottingham, Loughborough University, Aston University, Barclays Bank PLC, Birmingham City Council and West Bromwich Building Society.
Microsoft Access
- 2 day course
- Location: Bryn Pydew
- 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 ... Database Wellness
- See Training Course Details...
Aggregation Queries
Adding Transactional Records
Action Queries
Creating Queries
Navigation Pane Protection
Using a Navigation Form
Creating a Relational Database
Designing a Lookup Database
Creating and Using Forms
Creating and Using Reports
Macros on Forms
Working With Records
DIY Forms
Parameter Queries
Macro Techniques
An Introduction to VBA
Database Security
Querying Techniques
Formatting Tables
Importing and Exporting Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bryn Pydew
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Setting Breakpoints
- See Training Course Details...
Using Intrinsic Functions
Using the Do...Loop Structure
Trapping Errors with the On Error Statement
Understanding Error Handling
Understanding the Err Object
Declaring Variables
Understanding Classes and Objects
Creating a Sub Procedure
Understanding Objects
Understanding the Form Object
Creating a Function Procedure
Specifying a Recordset Cursor Type
Working with Recordsets
Working with Methods
Organizing Code and Procedures
Locking Records for Updating
Using Message Boxes
Using the For...Next Structure
Email us about this courses
Other Bryn Pydew Enable Technology Training Courses
JQuery Mobile Bryn Pydew Training Courses
SSAS Tabular - Bryn Pydew SQL Server Analysis Services Training Courses
Data Warehouse Bryn Pydew Training Courses
SSRS - Bryn Pydew SQL Server Reporting Services Training Courses
SSAS - Bryn Pydew SQL Server Analysis Services Training Courses
Excel 365 Intermediate Bryn Pydew Training Courses