ACCESS TRAINING COURSES OSWESTRY
About Enable Technology Oswestry Access Training Courses
We have a twenty year history of providing skills based Access industry training. The tutor delivering the course will be a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a Access course at an alternative training site in Oswestry. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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 Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Canadian High Commission, Aston University, Vodafone Group Services, West Bromwich Building Society, Wolverhampton City Council, TalkTalk Direct Limited, Capita Group PLC and Fujistu PLC.
Microsoft Access
- 2 day course
- Location: Oswestry
- 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 ... Multi Table Queries
- See Training Course Details...
Database Wellness
Setting Table Relationships
Using a Navigation Form
Creating a Relational Database
Macros on Forms
Action Queries
Creating and Using Macros
Creating a Lookup Database
Creating and Using Reports
Working With Records
Importing and Exporting Records
Understanding VBA
Creating and Using Forms
Parameter Queries
Formatting Tables
Adding Transactional Records
Creating Queries
Relational Database Design
Designing a Lookup Database
Getting to Know Access
Microsoft Access Programming Using VBA
- 3 day course
- Location: Oswestry
- Telephone on 01952 938014
- 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 ... Writing an Error-Handling Routine
- See Training Course Details...
Understanding Modules
Understanding the Order of Events
Understanding VBA's Error Trapping Options
Understanding Objects
Using the Do...Loop Structure
Using the Immediate Window to Call Procedures
Understanding the DoCmd Object
Understanding Collections
Declaring Variables
Working with Methods
Locking Records for Updating
Specifying a Recordset Cursor Location - Optional
Setting Breakpoints
Understanding Data Types
Using the With Statement
Working with Procedures and Functions
Calling Procedures
Using Intrinsic Functions
Creating a Sub Procedure
Email us about this courses
Other Oswestry Enable Technology Training Courses
Power BI - Oswestry Microsoft Power BI Training Courses
SSRS - Oswestry SQL Server Reporting Services Training Courses
Excel 365 Intermediate Oswestry Training Courses
Data Warehouse Oswestry Training Courses
Excel Power Pivot Oswestry Training Courses
PL/SQL Oswestry Training Courses