ACCESS TRAINING COURSES RHYL
About Enable Technology Rhyl Access Training Courses
Enable Technology provides practical Access skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a Access course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We are set up to deliver Access training courses onsite at your premises. We can also deliver the Access course at a socially distanced local training venue in Rhyl. We are happy to modify the Access syllabus to match your teams training 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 Birmingham City Council, West Bromwich Building Society, Birmingham City University, GKN PLC, Nuclear Engineering Services, Homeserve PLC, Fujistu PLC and Dollond & Aitchison Limited.
Microsoft Access
- 2 day course
- Location: Rhyl
- 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 ... Understanding VBA
- See Training Course Details...
Designing a Lookup Database
Creating and Using Forms
Creating a Relational Database
Creating and Using Reports
Working With Records
Data Validation
Macro Techniques
DIY Forms
Macros on Forms
Multi Table Queries
Setting Table Relationships
Creating a Lookup Database
Creating Queries
Adding Transactional Records
Getting to Know Access
Using a Navigation Form
An Introduction to VBA
Aggregation Queries
Sorting and Filtering
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rhyl
- 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 the DoCmd Object
- See Training Course Details...
Using the With Statement
Understanding Collections
Understanding Expressions and Statements
Setting Breakpoints
Using Debugging Tools
Working with Inline Error Handling
Understanding the Form Object
Understanding Errors
Calling Procedures
Creating a Standard Module
Understanding the Order of Events
Understanding the Development Environment
Using the Do...Loop Structure
Specifying a Recordset Cursor Location - Optional
Considering Variable Scope and Lifetime Together
Using the If...End If Decision Structures
Navigating the Access Object Hierarchy
Specifying a Recordset Cursor Type
Naming Procedures
Email us about this courses
Other Rhyl Enable Technology Training Courses
Report Builder - Rhyl SQL Server Reporting Services Training Courses
Excel Power Pivot - Rhyl Excel Training Courses
Excel 365 Intermediate - Rhyl Excel Training Courses
SSRS Rhyl Training Courses
TSQL - Rhyl SQL Training Courses
SSAS Tabular - Rhyl SQL Server Analysis Services Training Courses