ACCESS TRAINING COURSES SOUTHPORT
About Enable Technology Southport Access Training Courses
We are a company that provides short intensive Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
We provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local venue in Southport. Every Access course can be modified to meet your bespoke 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. Our clients include: Queen's Medical Centre Nottingham, Dollond & Aitchison Limited, TalkTalk Direct Limited, Loughborough University, Norwich Union PLC, Barclays Bank PLC, Shell UK Oil Products Ltd and Fujistu PLC.
Microsoft Access
- 2 day course
- Location: Southport
- 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 ... Modifying Table Structures
- See Training Course Details...
Aggregation Queries
Creating and Using Macros
Data Validation
Formatting Tables
DIY Forms
Relational Database Design
Macros on Forms
Creating Queries
Designing a Lookup Database
Multi Table Queries
An Introduction to VBA
Navigation Pane Protection
Action Queries
Adding Records to a Table
Using a Navigation Form
Database Security
Setting Table Relationships
Creating and Using Forms
Calculations in Queries
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Southport
- 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 ... Working with Variable Scope
- See Training Course Details...
Using Break Mode during Run Mode
Determining the Value of Expressions
Using Expressions, Variables, and Intrinsic Functions
Understanding the Development Environment
Understanding Procedures
Understanding Errors
Why Program in Access?
Naming Procedures
Organizing Code and Procedures
Working with Inline Error Handling
Creating a Function Procedure
Calling Procedures
Working with the ADODB Recordset Object
Understanding the Order of Events
Understanding Data Types
Working with Procedures and Functions
Working with Properties
Working with Recordsets
Email us about this courses
Other Southport Enable Technology Training Courses
SSRS Southport Training Courses
Data Warehouse - Southport SQL Training Courses
DAX Southport Training Courses
SQL - Southport SQL Training Courses
Power Query - Southport Excel Training Courses
TSQL - Southport SQL Training Courses