ACCESS TRAINING COURSES PRESTATYN
About Enable Technology Prestatyn Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The training will be delivered by a Microsoft professional with development experience. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local venue in Prestatyn. All Access courses can be customised to meet your particular 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Nationwide Building Society Limited, Vodafone Group Services, EDF Energy PLC, Royal & Sun Alliance Group PLC, Loughborough University, Keele University, GKN PLC and Queen's Medical Centre Nottingham.
Microsoft Access
- 2 day course
- Location: Prestatyn
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Adding Records to a Table
- See Training Course Details...
Using a Navigation Form
Creating a Relational Database
Navigation Pane Protection
Aggregation Queries
Data Validation
Sorting and Filtering
DIY Forms
Creating and Using Reports
Calculations in Queries
Modifying Forms
Modifying Table Structures
An Introduction to VBA
Setting Table Relationships
Creating and Using Forms
Parameter Queries
Importing and Exporting Records
Macros on Forms
Designing a Lookup Database
Database Security
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Prestatyn
- 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 the Err Object
- See Training Course Details...
Understanding VBA's Error Trapping Options
Using Visual Basic Help
Working with Procedures and Functions
Using the Object Browser
Working with Recordsets
Using Message Boxes
Debugging Code
Stepping through Code
Working with Methods
Working with the ADODB Recordset Object
Locking Records for Updating
Understanding Error Handling
Understanding Data Types
Understanding the Development Environment
Organizing Code and Procedures
Setting Breakpoints
Using Expressions, Variables, and Intrinsic Functions
Email us about this courses
Other Prestatyn Enable Technology Training Courses
Oracle SQL - Prestatyn SQL Training Courses
Excel Power Pivot Prestatyn Training Courses
TSQL Prestatyn Training Courses
JavaScript - Prestatyn JavaScript Training Courses
JQuery Prestatyn Training Courses
SSIS - Prestatyn SQL Server Integration Services Training Courses