ACCESS TRAINING COURSES WEST GLAMORGAN
About Enable Technology West Glamorgan Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
We provide instructor led training coupled with hands on training. 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. We also offer the option of scheduling of Access course at a socially distanced venue near you in West Glamorgan. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Aston University, Unipart Group, Keele University, Norfolk Police Constabulary, University of Birmingham, South Staffordshire Water PLC, Halfords Group PLC and Loughborough University.
Microsoft Access
- 2 day course
- Location: West Glamorgan
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Action Queries
- See Training Course Details...
Database Security
Creating a Lookup Database
Creating and Using Macros
An Introduction to VBA
Understanding VBA
Adding Records to a Table
Creating and Using Forms
Querying Techniques
DIY Forms
Getting to Know Access
Multi Table Queries
Navigation Pane Protection
Creating Queries
Data Validation
Parameter Queries
Designing a Lookup Database
Aggregation Queries
Database Wellness
Creating and Using Reports
Calculations in Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: West Glamorgan
- 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 CacheSize Property - Optional
- See Training Course Details...
Writing an Error-Handling Routine
Using the For...Next Structure
Using the Select Case...End Select Structure
Working with Recordsets
Working with Variable Scope
Using Input Boxes
Using the With Statement
Using the Object Browser
Guidelines for use of Branching Structures
Specifying a Recordset Cursor Location - Optional
Understanding Errors
Understanding Recordset Cursor Properties - Optional
Understanding Constants
Understanding the DoCmd Object
Using Intrinsic Functions
Setting Breakpoints
Working with Methods
Understanding the Order of Events
Email us about this courses
Other West Glamorgan Enable Technology Training Courses
SQL West Glamorgan Training Courses
JQuery Mobile - West Glamorgan JavaScript Training Courses
DAX West Glamorgan Training Courses
VBA West Glamorgan Training Courses
Excel 365 Intermediate - West Glamorgan Excel Training Courses
JQuery - West Glamorgan JavaScript Training Courses