ACCESS TRAINING COURSES ABERDARE
About Enable Technology Aberdare Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. 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. 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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Aberdare. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Nationwide Building Society Limited, Lloyds TSB Bank PLC, DHL Express, South Staffordshire Water PLC, Aston University, Countrywide Homes Limited, Vodafone Group Services and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Aberdare
- 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 ... Using the Select Case...End Select Structure
- See Training Course Details...
Setting Breakpoints
Using the For Each...Next Structure
Working with Procedures and Functions
Introduction to Programming in Access
Working with Inline Error Handling
Understanding Modules
Debugging Code
Understanding the DoCmd Object
Naming Procedures
Using the If...End If Decision Structures
Working with the Application Object
Understanding Error Handling
Writing an Error-Handling Routine
Working with Recordsets
Locking Records for Updating
Using Intrinsic Constants
Determining the Value of Expressions
Working with Properties
Understanding the Form Object
Microsoft Access
- 2 day course
- Location: Aberdare
- 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 ... Working With Records
- See Training Course Details...
Setting Table Relationships
Modifying Table Structures
Data Validation
Querying Techniques
Action Queries
Creating and Using Forms
Understanding VBA
Parameter Queries
Macros on Forms
Modifying Forms
Navigation Pane Protection
Adding Records to a Table
Sorting and Filtering
Creating and Using Reports
Macro Techniques
Database Wellness
Relational Database Design
Using a Navigation Form
Adding Transactional Records
Designing a Lookup Database
Email us about this courses
Other Aberdare Enable Technology Training Courses
TSQL - Aberdare SQL Training Courses
SSIS - Aberdare SQL Server Integration Services Training Courses
JQuery - Aberdare JavaScript Training Courses
DAX Aberdare Training Courses
Excel 365 Basic Aberdare Training Courses
JavaScript Aberdare Training Courses