ACCESS TRAINING COURSES PORTHCAWL
About Enable Technology Porthcawl Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training Access resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of Access course at a socially distanced venue near you in Porthcawl. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: South Staffordshire Water PLC, Birmingham City Council, EDF Energy PLC, Norwich Union PLC, Capita Group PLC, DHL Express, Cadbury PLC and Royal Air Force.
Microsoft Access
- 2 day course
- Location: Porthcawl
- 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 ... Formatting Tables
- See Training Course Details...
Creating and Using Forms
Creating a Lookup Database
Calculations in Queries
DIY Forms
Sorting and Filtering
Creating a Relational Database
Macros on Forms
Navigation Pane Protection
Modifying Table Structures
Database Wellness
Macro Techniques
Adding Transactional Records
Setting Table Relationships
Action Queries
Querying Techniques
Data Validation
Creating and Using Reports
Parameter Queries
Database Security
Modifying Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Porthcawl
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Using the Select Case...End Select Structure
- See Training Course Details...
Using Intrinsic Functions
Specifying a Recordset Cursor Type
Using the Immediate Window to Call Procedures
Creating a Sub Procedure
Understanding Errors
Working with Inline Error Handling
Naming Procedures
Locking Records for Updating
Introduction to Programming in Access
Working with Boolean Expressions
Guidelines for use of Branching Structures
Declaring and Creating Object Variables
Creating a Standard Module
Setting Break Expressions
Understanding Objects
Using the If...End If Decision Structures
Setting Breakpoints
Understanding Control-of-Flow Structures
Creating a Function Procedure
Email us about this courses
Other Porthcawl Enable Technology Training Courses
Data Warehouse Porthcawl Training Courses
TSQL - Porthcawl SQL Training Courses
Power Query Porthcawl Training Courses
JQuery Mobile - Porthcawl JavaScript Training Courses
JavaScript - Porthcawl JavaScript Training Courses
SSRS Porthcawl Training Courses