ACCESS TRAINING COURSES RHYL
About Enable Technology Rhyl Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The training will be delivered by a Microsoft professional with development experience. We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Access courses are taught by a Microsoft Certified Solutions Expert. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If delivery onsite is an issue we will organise a venue near you in Rhyl. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Canadian High Commission, Barclays Bank PLC, EDF Energy PLC, Birmingham City Council, Vodafone Group Services, Shell UK Oil Products Ltd, Birmingham City University and Cadbury PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rhyl
- 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 ... Understanding Recordset Cursor Properties - Optional
- See Training Course Details...
Creating a Sub Procedure
Using Visual Basic Help
Guidelines for use of Branching Structures
Why Program in Access?
Trapping Errors with the On Error Statement
Understanding Data Types
Understanding Error Handling
Using Message Boxes
Writing an Error-Handling Routine
Using the For Each...Next Structure
Working with Procedures and Functions
Understanding the Order of Events
Understanding Expressions and Statements
Understanding the Err Object
Working with the ADODB Recordset Object
Using Intrinsic Functions
Understanding Errors
Working with Boolean Expressions
Microsoft Access
- 2 day course
- Location: Rhyl
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Data Validation
- See Training Course Details...
Navigation Pane Protection
Creating and Using Macros
Querying Techniques
Creating a Relational Database
Creating a Lookup Database
Creating and Using Forms
An Introduction to VBA
Adding Records to a Table
Understanding VBA
Macro Techniques
Parameter Queries
Getting to Know Access
Working With Records
Formatting Tables
Creating and Using Reports
Modifying Table Structures
Adding Transactional Records
Sorting and Filtering
DIY Forms
Designing a Lookup Database
Email us about this courses
Other Rhyl Enable Technology Training Courses
Power BI - Rhyl Microsoft Power BI Training Courses
Excel 365 Advanced Rhyl Training Courses
TSQL - Rhyl SQL Training Courses
JavaScript Rhyl Training Courses
Power Query - Rhyl Excel Training Courses
Excel Power Pivot - Rhyl Excel Training Courses