ACCESS TRAINING COURSES MONMOUTH
About Enable Technology Monmouth Access Training Courses
Enable Technology provides practical Access skills based technology training. The tutor delivering the course will be a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite training location in Monmouth. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Unipart Group, Nationwide Building Society Limited, Loughborough University, Wolverhampton City Council, GKN PLC, Fujistu PLC, Lloyds TSB Bank PLC and Cadbury PLC.
Microsoft Access
- 2 day course
- Location: Monmouth
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Macros on Forms
- See Training Course Details...
Formatting Tables
Modifying Forms
Creating a Relational Database
Navigation Pane Protection
Database Security
Adding Records to a Table
Modifying Table Structures
Querying Techniques
Creating and Using Reports
Working With Records
Adding Transactional Records
Importing and Exporting Records
Creating Queries
Understanding VBA
Calculations in Queries
Creating and Using Macros
Sorting and Filtering
Creating a Lookup Database
Getting to Know Access
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Monmouth
- 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 ... Specifying a Recordset Cursor Type
- See Training Course Details...
Understanding Constants
Using the For Each...Next Structure
Using Intrinsic Constants
Working with Procedures and Functions
Understanding Error Handling
Navigating the Access Object Hierarchy
Using Debugging Tools
Understanding Expressions and Statements
Working with Variable Scope
Understanding the Err Object
Declaring Variables
Working with Events
Understanding Modules
Understanding Data Types
Trapping Errors with the On Error Statement
Understanding Recordset Cursor Properties - Optional
Determining the Value of Expressions
Using Break Mode during Run Mode
Email us about this courses
Other Monmouth Enable Technology Training Courses
Data Warehouse - Monmouth SQL Training Courses
Power Query Monmouth Training Courses
VBA Monmouth Training Courses
SQL Monmouth Training Courses
PL/SQL - Monmouth SQL Training Courses
DAX - Monmouth Excel Training Courses