ACCESS TRAINING COURSES HARROGATE
About Enable Technology Harrogate Access Training Courses
Enable Technology specialise in succinct skills based Access training. The tutor delivering the course will be a Microsoft certified expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. 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 offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local training site. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: National Power PLC, Yell Group PLC, Keele University, Fujistu PLC, Queen's Medical Centre Nottingham, West Bromwich Building Society, Birmingham City University and EDF Energy PLC.
Microsoft Access
- 2 day course
- Location: Harrogate
- 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 ... Parameter Queries
- See Training Course Details...
Modifying Forms
Creating and Using Reports
Modifying Table Structures
Creating and Using Macros
Multi Table Queries
Adding Transactional Records
Creating and Using Forms
Navigation Pane Protection
DIY Forms
Sorting and Filtering
Calculations in Queries
Aggregation Queries
Adding Records to a Table
Getting to Know Access
Macro Techniques
Setting Table Relationships
Creating a Lookup Database
Designing a Lookup Database
Working With Records
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Harrogate
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Expressions and Statements
- See Training Course Details...
Understanding Procedures
Understanding Recordset Cursor Properties - Optional
Writing an Error-Handling Routine
Understanding the Order of Events
Specifying a Recordset Cursor Location - Optional
Using Message Boxes
Using the For...Next Structure
Working with Inline Error Handling
Naming Procedures
Specifying a Recordset Cursor Type
Setting Break Expressions
Using the Select Case...End Select Structure
Understanding Data Types
Using the Do...Loop Structure
Working with Procedures and Functions
Using Break Mode during Run Mode
Introduction to Programming in Access
Email us about this courses
Other Harrogate Enable Technology Training Courses
SSRS Harrogate Training Courses
TSQL Harrogate Training Courses
Excel 365 Advanced - Harrogate Excel Training Courses
PL/SQL Harrogate Training Courses
DAX - Harrogate Excel Training Courses
SSIS Harrogate Training Courses