ACCESS TRAINING COURSES PRESTATYN
About Enable Technology Prestatyn Access Training Courses
We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a training location in Prestatyn. 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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Shell UK Oil Products Ltd, Dollond & Aitchison Limited, Norfolk Police Constabulary, Cadbury PLC, Birmingham City Council, Lloyds TSB Bank PLC, Nuclear Engineering Services and Birmingham City University.
Microsoft Access
- 2 day course
- Location: Prestatyn
- 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 ... Sorting and Filtering
- See Training Course Details...
Macro Techniques
Importing and Exporting Records
Creating and Using Forms
An Introduction to VBA
Setting Table Relationships
Calculations in Queries
Understanding VBA
Data Validation
Working With Records
Modifying Forms
Modifying Table Structures
Querying Techniques
Creating and Using Macros
Using a Navigation Form
Formatting Tables
Creating a Lookup Database
Aggregation Queries
Action Queries
Macros on Forms
Creating Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Prestatyn
- 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 ... Understanding Procedures
- See Training Course Details...
Debugging Code
Understanding Control-of-Flow Structures
Using the For Each...Next Structure
Working with Events
Declaring and Creating Object Variables
Understanding Collections
Naming Procedures
Understanding the Err Object
Using the Do...Loop Structure
Considering Variable Scope and Lifetime Together
Understanding Constants
Working with Procedures and Functions
Understanding Errors
Organizing Code and Procedures
Understanding the Order of Events
Declaring Variables
Introduction to Programming in Access
Why Program in Access?
Email us about this courses
Other Prestatyn Enable Technology Training Courses
SSIS Prestatyn Training Courses
TSQL Prestatyn Training Courses
Power BI - Prestatyn Microsoft Power BI Training Courses
Data Warehouse - Prestatyn SQL Training Courses
Excel 365 Advanced Prestatyn Training Courses
JQuery - Prestatyn JavaScript Training Courses