ACCESS TRAINING COURSES POWYS
About Enable Technology Powys Access Training Courses
We have a twenty year history of providing skills based Access industry training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another option is we can organise a local training site in Powys. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Birmingham City Council, Royal & Sun Alliance Group PLC, Carillion PLC, Birmingham Heartlands Hospital, Fujistu PLC, Shell UK Oil Products Ltd, TalkTalk Direct Limited and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Powys
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Introduction to Programming in Access
- See Training Course Details...
Setting Breakpoints
Working with Properties
Using the CacheSize Property - Optional
Using Debugging Tools
Declaring and Creating Object Variables
Understanding Classes and Objects
Navigating the Access Object Hierarchy
Working with Variable Lifetime
Understanding Modules
Declaring Variables
Using the Immediate Window to Call Procedures
Trapping Errors with the On Error Statement
Locking Records for Updating
Working with Boolean Expressions
Creating a Sub Procedure
Working with Events
Microsoft Access
- 2 day course
- Location: Powys
- 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 ... Macros on Forms
- See Training Course Details...
Using a Navigation Form
Data Validation
Designing a Lookup Database
Action Queries
Sorting and Filtering
Creating a Lookup Database
An Introduction to VBA
Creating and Using Reports
Macro Techniques
Creating and Using Macros
Parameter Queries
Understanding VBA
Modifying Table Structures
Database Security
Importing and Exporting Records
Setting Table Relationships
Calculations in Queries
Querying Techniques
Formatting Tables
Aggregation Queries
Email us about this courses
Other Powys Enable Technology Training Courses
SSAS Tabular - Powys SQL Server Analysis Services Training Courses
Oracle SQL - Powys SQL Training Courses
DAX Powys Training Courses
Power BI - Powys Microsoft Power BI Training Courses
VBA Powys Training Courses
SSIS Powys Training Courses