ACCESS TRAINING COURSES LICHFIELD
About Enable Technology Lichfield Access Training Courses
We offer intensive two and three days Access courses. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
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. The Access course could also be scheduled at a socially distanced site near you in Lichfield. We are happy to modify the Access syllabus to match your teams training 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.
We have operated primarily in the West Midlands for twenty years. Our clients include: South Staffordshire Water PLC, Royal Air Force, Capita Group PLC, Fujistu PLC, Yell Group PLC, GKN PLC, Homeserve PLC and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Lichfield
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Controlling Program Execution
- See Training Course Details...
Working with the Application Object
Specifying a Recordset Cursor Location - Optional
Working with the Code Editor
Setting Breakpoints
Understanding Constants
Using Debugging Tools
Setting Break Expressions
Understanding the Err Object
Understanding Errors
Understanding the Order of Events
Using the If...End If Decision Structures
Using the For...Next Structure
Creating a Function Procedure
Declaring and Creating Object Variables
Using Intrinsic Constants
Locking Records for Updating
Using the Immediate Window to Call Procedures
Using the Select Case...End Select Structure
Using Input Boxes
Microsoft Access
- 2 day course
- Location: Lichfield
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Creating a Lookup Database
- See Training Course Details...
Multi Table Queries
Data Validation
Setting Table Relationships
Understanding VBA
An Introduction to VBA
Modifying Forms
Database Wellness
Formatting Tables
Querying Techniques
Adding Transactional Records
Creating and Using Macros
Database Security
Modifying Table Structures
Navigation Pane Protection
DIY Forms
Action Queries
Creating and Using Forms
Sorting and Filtering
Macro Techniques
Relational Database Design
Email us about this courses
Other Lichfield Enable Technology Training Courses
Report Builder - Lichfield SQL Server Reporting Services Training Courses
TSQL Lichfield Training Courses
SQL Lichfield Training Courses
DAX Lichfield Training Courses
Excel 365 Basic Lichfield Training Courses
SSIS Lichfield Training Courses