ACCESS TRAINING COURSES BEDWAS
About Enable Technology Bedwas Access Training Courses
We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to 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 also offer the option of scheduling of Access course at a socially distanced venue near you in Bedwas. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Shell UK Oil Products Ltd, Aston University, Lloyds TSB Bank PLC, West Bromwich Building Society, Royal & Sun Alliance Group PLC, DHL Express, Cadbury PLC and National Power PLC.
Microsoft Access
- 2 day course
- Location: Bedwas
- Telephone on 01952 938014
- 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 ... Creating and Using Macros
- See Training Course Details...
Adding Transactional Records
Creating a Relational Database
Creating and Using Forms
Multi Table Queries
Formatting Tables
Designing a Lookup Database
Database Security
Modifying Table Structures
Data Validation
Modifying Forms
Database Wellness
Calculations in Queries
Creating Queries
Creating a Lookup Database
Getting to Know Access
Parameter Queries
Using a Navigation Form
Action Queries
Macros on Forms
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bedwas
- 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 Form Object
- See Training Course Details...
Working with Properties
Working with the Code Editor
Using Input Boxes
Specifying a Recordset Cursor Type
Introduction to Programming in Access
Working with the ADODB Recordset Object
Stepping through Code
Using Intrinsic Constants
Organizing Code and Procedures
Using the Immediate Window to Call Procedures
Working with Recordsets
Locking Records for Updating
Calling Procedures
Using the Do...Loop Structure
Understanding Collections
Email us about this courses
Other Bedwas Enable Technology Training Courses
DAX - Bedwas Excel Training Courses
SSAS Tabular Bedwas Training Courses
JQuery - Bedwas JavaScript Training Courses
Report Builder - Bedwas SQL Server Reporting Services Training Courses
PL/SQL - Bedwas SQL Training Courses
Excel 365 Intermediate Bedwas Training Courses