ACCESS TRAINING COURSES SMETHWICK
About Enable Technology Smethwick Access Training Courses
We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with Access training materials which they keep 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local venue in Smethwick. We are happy to modify the Access syllabus to match your teams training requirements.
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. Some of our clients are Total Telecommunications Limited, Capita Group PLC, Cadbury PLC, EDF Energy PLC, DHL Express, Birmingham Heartlands Hospital, Boots UK Limited and GKN PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Smethwick
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Working with Procedures and Functions
- See Training Course Details...
Using the CacheSize Property - Optional
Using Visual Basic Help
Writing an Error-Handling Routine
Setting Break Expressions
Creating a Function Procedure
Guidelines for use of Branching Structures
Declaring and Creating Object Variables
Understanding the Form Object
Navigating the Access Object Hierarchy
Introduction to Programming in Access
Understanding Recordset Cursor Properties - Optional
Working with Variable Scope
Understanding the Development Environment
Understanding Constants
Why Program in Access?
Debugging Code
Calling Procedures
Microsoft Access
- 2 day course
- Location: Smethwick
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Macros on Forms
- See Training Course Details...
Modifying Forms
Adding Records to a Table
Sorting and Filtering
Understanding VBA
Designing a Lookup Database
Data Validation
Database Wellness
Parameter Queries
Aggregation Queries
DIY Forms
Creating and Using Forms
Database Security
Navigation Pane Protection
Calculations in Queries
Action Queries
Creating and Using Reports
Importing and Exporting Records
Creating and Using Macros
Using a Navigation Form
Multi Table Queries
Email us about this courses
Other Smethwick Enable Technology Training Courses
TSQL - Smethwick SQL Training Courses
Excel 365 Basic - Smethwick Excel Training Courses
Oracle SQL - Smethwick SQL Training Courses
Excel 365 Intermediate Smethwick Training Courses
VBA - Smethwick Excel Training Courses
SSAS Smethwick Training Courses