ACCESS TRAINING COURSES MERTHYR TYDFIL
About Enable Technology Merthyr Tydfil Access Training Courses
Enable Technology specialise in succinct skills based Access training. The tutor delivering the course will be a Microsoft certified expert. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If delivery onsite is an issue we will organise a socially distanced venue near you in Merthyr Tydfil. All Access courses can be customised to meet your particular 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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Royal & Sun Alliance Group PLC, Unipart Group, Canadian High Commission, Vodafone Group Services, GKN PLC, Birmingham City Council, Fujistu PLC and Aston University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Merthyr Tydfil
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding the Order of Events
- See Training Course Details...
Specifying a Recordset Cursor Type
Understanding Procedures
Using the CacheSize Property - Optional
Calling Procedures
Determining the Value of Expressions
Writing an Error-Handling Routine
Understanding the Form Object
Considering Variable Scope and Lifetime Together
Working with Properties
Working with Variable Lifetime
Using the Immediate Window to Call Procedures
Navigating the Access Object Hierarchy
Handling Errors
Debugging Code
Using the If...End If Decision Structures
Locking Records for Updating
Creating a Standard Module
Declaring and Creating Object Variables
Microsoft Access
- 2 day course
- Location: Merthyr Tydfil
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Creating and Using Forms
- See Training Course Details...
An Introduction to VBA
Macro Techniques
Creating a Relational Database
Using a Navigation Form
Formatting Tables
Calculations in Queries
Creating a Lookup Database
Importing and Exporting Records
Creating and Using Reports
Data Validation
Designing a Lookup Database
Sorting and Filtering
Setting Table Relationships
Parameter Queries
Creating and Using Macros
Understanding VBA
Aggregation Queries
Adding Records to a Table
Macros on Forms
Creating Queries
Email us about this courses
Other Merthyr Tydfil Enable Technology Training Courses
SSAS Merthyr Tydfil Training Courses
Excel 365 Advanced - Merthyr Tydfil Excel Training Courses
Excel Power Pivot Merthyr Tydfil Training Courses
SSAS Tabular - Merthyr Tydfil SQL Server Analysis Services Training Courses
SSIS - Merthyr Tydfil SQL Server Integration Services Training Courses
SQL Merthyr Tydfil Training Courses