ACCESS TRAINING COURSES SPLOTT
About Enable Technology Splott Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training Access resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a local training venue in Splott. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Homeserve PLC, Canadian High Commission, Nuclear Engineering Services, GKN PLC, Vodafone Group Services, Fujistu PLC, Wolverhampton City Council and West Bromwich Building Society.
Microsoft Access
- 2 day course
- Location: Splott
- 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 ... Navigation Pane Protection
- See Training Course Details...
DIY Forms
Importing and Exporting Records
Adding Transactional Records
Creating and Using Forms
Relational Database Design
Modifying Table Structures
Action Queries
Database Wellness
Creating a Lookup Database
Macros on Forms
Multi Table Queries
Creating and Using Macros
Modifying Forms
Working With Records
Getting to Know Access
Using a Navigation Form
An Introduction to VBA
Database Security
Understanding VBA
Macro Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Splott
- 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 ... Using Expressions, Variables, and Intrinsic Functions
- See Training Course Details...
Using the For Each...Next Structure
Using the If...End If Decision Structures
Working with Boolean Expressions
Considering Variable Scope and Lifetime Together
Understanding Modules
Using Visual Basic Help
Working with Properties
Understanding Control-of-Flow Structures
Introduction to Programming in Access
Understanding Constants
Naming Procedures
Using Input Boxes
Trapping Errors with the On Error Statement
Understanding the Err Object
Understanding the Form Object
Using Break Mode during Run Mode
Working with Variable Lifetime
Email us about this courses
Other Splott Enable Technology Training Courses
SQL Splott Training Courses
SSAS Splott Training Courses
SSAS Tabular - Splott SQL Server Analysis Services Training Courses
PL/SQL - Splott SQL Training Courses
Excel 365 Intermediate - Splott Excel Training Courses
DAX Splott Training Courses