ACCESS TRAINING COURSES SOLIHULL
About Enable Technology Solihull Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Courses are instructor led and groups sizes small. 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. Another way we could deliver the Access course is at a local socially distanced training site. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Capita Group PLC, Countrywide Homes Limited, Cadbury PLC, Barclays Bank PLC, Nuclear Engineering Services, GKN PLC, DHL Express and Dollond & Aitchison Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Solihull
- 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 ... Creating a Standard Module
- See Training Course Details...
Using the If...End If Decision Structures
Using Break Mode during Run Mode
Guidelines for use of Branching Structures
Understanding Expressions and Statements
Declaring and Creating Object Variables
Working with Recordsets
Using the Object Browser
Using Intrinsic Constants
Understanding Error Handling
Understanding the Development Environment
Organizing Code and Procedures
Working with the ADODB Recordset Object
Working with Methods
Using Visual Basic Help
Using Input Boxes
Stepping through Code
Considering Variable Scope and Lifetime Together
Trapping Errors with the On Error Statement
Why Program in Access?
Microsoft Access
- 2 day course
- Location: Solihull
- 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 ... Importing and Exporting Records
- See Training Course Details...
Creating and Using Macros
Sorting and Filtering
Adding Transactional Records
Adding Records to a Table
Formatting Tables
Calculations in Queries
Designing a Lookup Database
DIY Forms
Parameter Queries
Querying Techniques
Understanding VBA
Data Validation
Working With Records
Getting to Know Access
Creating a Lookup Database
Modifying Forms
Database Security
Using a Navigation Form
Navigation Pane Protection
Relational Database Design
Email us about this courses
Other Solihull Enable Technology Training Courses
SSIS Solihull Training Courses
SSRS Solihull Training Courses
SSAS Solihull Training Courses
DAX Solihull Training Courses
Data Warehouse Solihull Training Courses
SQL - Solihull SQL Training Courses