ACCESS TRAINING COURSES MANCHESTER
About Enable Technology Manchester Access Training Courses
We are a company that provides short intensive Access training courses. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials 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 Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Manchester. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Birmingham City University, Dollond & Aitchison Limited, Yell Group PLC, Capita Group PLC, West Bromwich Building Society, Cadbury PLC, Homeserve PLC and Royal & Sun Alliance Group PLC.
Microsoft Access
- 2 day course
- Location: Manchester
- 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 ... Navigation Pane Protection
- See Training Course Details...
Action Queries
Database Wellness
Formatting Tables
Importing and Exporting Records
Database Security
Creating and Using Reports
Data Validation
Modifying Forms
Creating Queries
Working With Records
Designing a Lookup Database
Adding Transactional Records
Modifying Table Structures
Creating a Relational Database
Understanding VBA
Adding Records to a Table
Sorting and Filtering
Setting Table Relationships
Creating a Lookup Database
Macro Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Manchester
- 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 ... Considering Variable Scope and Lifetime Together
- See Training Course Details...
Locking Records for Updating
Working with Methods
Using Input Boxes
Naming Procedures
Using the Do...Loop Structure
Using Intrinsic Functions
Handling Errors
Using the For Each...Next Structure
Understanding Collections
Working with Inline Error Handling
Working with the ADODB Recordset Object
Guidelines for use of Branching Structures
Understanding Classes and Objects
Understanding Modules
Understanding VBA's Error Trapping Options
Understanding Data Types
Writing an Error-Handling Routine
Email us about this courses
Other Manchester Enable Technology Training Courses
Excel 365 Advanced Manchester Training Courses
SSIS Manchester Training Courses
Data Warehouse - Manchester SQL Training Courses
DAX - Manchester Excel Training Courses
JavaScript Manchester Training Courses
SSAS Manchester Training Courses