ACCESS TRAINING COURSES PRESTATYN
About Enable Technology Prestatyn Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to discuss customising the course content should you have particular Access training requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are GKN PLC, Lloyds TSB Bank PLC, EDF Energy PLC, DHL Express, Unipart Group, National Power PLC, Shell UK Oil Products Ltd and Carillion PLC.
Microsoft Access
- 2 day course
- Location: Prestatyn
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Macros on Forms
- See Training Course Details...
Creating and Using Macros
Multi Table Queries
Modifying Forms
Action Queries
Relational Database Design
Parameter Queries
Using a Navigation Form
Database Wellness
Creating Queries
Aggregation Queries
Creating a Relational Database
Creating and Using Reports
Working With Records
Modifying Table Structures
Querying Techniques
Creating and Using Forms
DIY Forms
Adding Transactional Records
Navigation Pane Protection
Sorting and Filtering
Microsoft Access Programming Using VBA
- 3 day course
- Location: Prestatyn
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Naming Procedures
- See Training Course Details...
Trapping Errors with the On Error Statement
Using the Immediate Window to Call Procedures
Working with the ADODB Recordset Object
Setting Breakpoints
Using Expressions, Variables, and Intrinsic Functions
Using the Do...Loop Structure
Using Message Boxes
Using Break Mode during Run Mode
Declaring Variables
Understanding the Err Object
Understanding Data Types
Understanding Objects
Understanding the DoCmd Object
Setting Break Expressions
Understanding the Development Environment
Using the Object Browser
Using the With Statement
Stepping through Code
Working with the Code Editor
Email us about this courses
Other Prestatyn Enable Technology Training Courses
DAX - Prestatyn Excel Training Courses
SSRS - Prestatyn SQL Server Reporting Services Training Courses
JavaScript Prestatyn Training Courses
Power Query Prestatyn Training Courses
SQL Prestatyn Training Courses
Excel Power Pivot - Prestatyn Excel Training Courses