ACCESS TRAINING COURSES GORSEINON
About Enable Technology Gorseinon Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. 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. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology offers instructor led training taught by technology specialists. 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 option is we can organise a local training site in Gorseinon. We are happy to discuss customising the course content should you have particular Access training requirements.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Nuclear Engineering Services, TalkTalk Direct Limited, Shell UK Oil Products Ltd, Norfolk Police Constabulary, Birmingham City University, Carillion PLC, GKN PLC and Wolverhampton City Council.
Microsoft Access
- 2 day course
- Location: Gorseinon
- 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 ... Action Queries
- See Training Course Details...
DIY Forms
Macros on Forms
Modifying Forms
Formatting Tables
Creating and Using Reports
Navigation Pane Protection
Aggregation Queries
An Introduction to VBA
Creating Queries
Working With Records
Adding Transactional Records
Creating a Relational Database
Data Validation
Getting to Know Access
Database Security
Adding Records to a Table
Modifying Table Structures
Querying Techniques
Multi Table Queries
Parameter Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gorseinon
- 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 ... Understanding Expressions and Statements
- See Training Course Details...
Controlling Program Execution
Understanding Procedures
Understanding the Err Object
Debugging Code
Working with Recordsets
Using the CacheSize Property - Optional
Using the Do...Loop Structure
Setting Break Expressions
Using Break Mode during Run Mode
Using the For...Next Structure
Understanding Errors
Working with the Application Object
Working with Variable Scope
Understanding Recordset Cursor Properties - Optional
Understanding Modules
Understanding Constants
Guidelines for use of Branching Structures
Email us about this courses
Other Gorseinon Enable Technology Training Courses
Power Query - Gorseinon Excel Training Courses
Excel 365 Advanced - Gorseinon Excel Training Courses
JQuery Mobile Gorseinon Training Courses
SSAS Tabular Gorseinon Training Courses
TSQL - Gorseinon SQL Training Courses
SSAS - Gorseinon SQL Server Analysis Services Training Courses