ACCESS TRAINING COURSES GORSEINON
About Enable Technology Gorseinon Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given Access courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite training location in Gorseinon. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Barclays Bank PLC, South Staffordshire Water PLC, National Power PLC, Shell UK Oil Products Ltd, Loughborough University, Boots UK Limited, Carillion PLC and Capita Group PLC.
Microsoft Access
- 2 day course
- Location: Gorseinon
- 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 ... Multi Table Queries
- See Training Course Details...
Querying Techniques
Creating and Using Forms
Creating a Lookup Database
Macros on Forms
Using a Navigation Form
Action Queries
Modifying Forms
Data Validation
Formatting Tables
Navigation Pane Protection
Creating and Using Reports
Adding Records to a Table
DIY Forms
Database Wellness
Understanding VBA
Creating a Relational Database
Designing a Lookup Database
Creating Queries
Modifying Table Structures
Importing and Exporting Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gorseinon
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding Errors
- See Training Course Details...
Setting Break Expressions
Introduction to Programming in Access
Working with Inline Error Handling
Specifying a Recordset Cursor Location - Optional
Using Input Boxes
Understanding the Development Environment
Using Visual Basic Help
Understanding the Order of Events
Declaring Variables
Creating a Sub Procedure
Using the If...End If Decision Structures
Using Intrinsic Functions
Working with Recordsets
Trapping Errors with the On Error Statement
Setting Breakpoints
Using the Select Case...End Select Structure
Understanding Expressions and Statements
Considering Variable Scope and Lifetime Together
Working with Variable Lifetime
Email us about this courses
Other Gorseinon Enable Technology Training Courses
Oracle SQL Gorseinon Training Courses
Power BI Gorseinon Training Courses
Excel 365 Basic Gorseinon Training Courses
VBA Gorseinon Training Courses
SSAS - Gorseinon SQL Server Analysis Services Training Courses
SSAS Tabular - Gorseinon SQL Server Analysis Services Training Courses