ACCESS TRAINING COURSES CHESHIRE
About Enable Technology Cheshire Access Training Courses
Enable Technology specialise in succinct skills based Access training. The tutor delivering the course will be a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Another way we could deliver the Access course is at a local training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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. Our clients include: Vodafone Group Services, National Power PLC, Yell Group PLC, Nuclear Engineering Services, Lloyds TSB Bank PLC, Boots UK Limited, Loughborough University and Canadian High Commission.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cheshire
- 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 ... Understanding Recordset Cursor Properties - Optional
- See Training Course Details...
Using the Do...Loop Structure
Organizing Code and Procedures
Specifying a Recordset Cursor Location - Optional
Using Intrinsic Functions
Understanding the DoCmd Object
Using Visual Basic Help
Why Program in Access?
Understanding Objects
Understanding Modules
Calling Procedures
Using the For Each...Next Structure
Understanding VBA's Error Trapping Options
Creating a Function Procedure
Working with Properties
Using the With Statement
Using Message Boxes
Using Debugging Tools
Using the CacheSize Property - Optional
Using Expressions, Variables, and Intrinsic Functions
Microsoft Access
- 2 day course
- Location: Cheshire
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Setting Table Relationships
- See Training Course Details...
Creating and Using Macros
Calculations in Queries
DIY Forms
Aggregation Queries
Action Queries
Sorting and Filtering
Adding Records to a Table
Formatting Tables
Macros on Forms
Creating a Lookup Database
Creating and Using Forms
Querying Techniques
Creating Queries
Creating a Relational Database
Data Validation
Importing and Exporting Records
Designing a Lookup Database
Macro Techniques
Modifying Table Structures
Navigation Pane Protection
Email us about this courses
Other Cheshire Enable Technology Training Courses
Excel 365 Intermediate Cheshire Training Courses
JQuery Cheshire Training Courses
Power BI Cheshire Training Courses
Power Query Cheshire Training Courses
SQL Cheshire Training Courses
DAX Cheshire Training Courses