ACCESS TRAINING COURSES SMETHWICK
About Enable Technology Smethwick Access Training Courses
Enable Technology specialise in succinct skills based Access training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given Access courseware which they can refer to after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver Access courses onsite at your site. We can also deliver the Access course at a local training venue in Smethwick. All Access courses can be customised to meet your particular requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Nuclear Engineering Services, Barclays Bank PLC, Yell Group PLC, Capita Group PLC, Carillion PLC, Loughborough University, Total Telecommunications Limited and Norwich Union PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Smethwick
- 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 Object Browser
- See Training Course Details...
Working with Events
Understanding Errors
Using Debugging Tools
Working with the ADODB Recordset Object
Debugging Code
Working with Properties
Understanding Classes and Objects
Working with Boolean Expressions
Working with Inline Error Handling
Using Intrinsic Functions
Using the Immediate Window to Call Procedures
Guidelines for use of Branching Structures
Using the With Statement
Why Program in Access?
Using Message Boxes
Understanding Recordset Cursor Properties - Optional
Naming 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...
Multi Table Queries
Formatting Tables
Macro Techniques
Creating and Using Reports
Working With Records
Modifying Forms
Designing a Lookup Database
Aggregation Queries
Creating and Using Macros
Creating Queries
DIY Forms
Action Queries
Sorting and Filtering
Modifying Table Structures
Importing and Exporting Records
An Introduction to VBA
Data Validation
Database Security
Adding Transactional Records
Getting to Know Access
Email us about this courses
Other Smethwick Enable Technology Training Courses
JavaScript - Smethwick JavaScript Training Courses
SSAS - Smethwick SQL Server Analysis Services Training Courses
TSQL - Smethwick SQL Training Courses
SSIS Smethwick Training Courses
Report Builder Smethwick Training Courses
PL/SQL Smethwick Training Courses