ACCESS TRAINING COURSES AMMANFORD
About Enable Technology Ammanford Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local training site. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Birmingham City Council, Dollond & Aitchison Limited, Homeserve PLC, Yell Group PLC, Countrywide Homes Limited, Fujistu PLC, Queen's Medical Centre Nottingham and Lloyds TSB Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ammanford
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding the Order of Events
- See Training Course Details...
Understanding the DoCmd Object
Understanding Objects
Understanding Data Types
Using Expressions, Variables, and Intrinsic Functions
Using Break Mode during Run Mode
Trapping Errors with the On Error Statement
Naming Procedures
Using Message Boxes
Using Intrinsic Constants
Understanding VBA's Error Trapping Options
Stepping through Code
Using Visual Basic Help
Declaring and Creating Object Variables
Using the Immediate Window to Call Procedures
Understanding Classes and Objects
Understanding Errors
Declaring Variables
Creating a Function Procedure
Understanding Collections
Microsoft Access
- 2 day course
- Location: Ammanford
- 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 ... Creating a Lookup Database
- See Training Course Details...
Setting Table Relationships
Adding Records to a Table
Aggregation Queries
Formatting Tables
Database Wellness
Sorting and Filtering
Creating a Relational Database
Modifying Table Structures
Creating Queries
Importing and Exporting Records
Navigation Pane Protection
Creating and Using Macros
Working With Records
Macros on Forms
Multi Table Queries
Getting to Know Access
Using a Navigation Form
Querying Techniques
Data Validation
Parameter Queries
Email us about this courses
Other Ammanford Enable Technology Training Courses
Power BI Ammanford Training Courses
SQL - Ammanford SQL Training Courses
Power Query - Ammanford Excel Training Courses
Excel 365 Advanced Ammanford Training Courses
Excel 365 Intermediate Ammanford Training Courses
SSAS Tabular Ammanford Training Courses