ACCESS TRAINING COURSES ROCHDALE
About Enable Technology Rochdale Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All Enable Technology tutors are Microsoft certified experts. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. 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 Access course at an alternative training site in Rochdale. We will work with you prior to the course to tailor the Access syllabus to match your 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 TalkTalk Direct Limited, Birmingham Heartlands Hospital, Shell UK Oil Products Ltd, National Power PLC, Dollond & Aitchison Limited, Aston University, Norfolk Police Constabulary and Capita Group PLC.
Microsoft Access
- 2 day course
- Location: Rochdale
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Formatting Tables
Getting to Know Access
Adding Transactional Records
Aggregation Queries
Querying Techniques
Using a Navigation Form
Data Validation
Creating and Using Forms
Setting Table Relationships
An Introduction to VBA
Action Queries
Database Wellness
Creating and Using Macros
Parameter Queries
Calculations in Queries
Multi Table Queries
Sorting and Filtering
DIY Forms
Macros on Forms
Macro Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rochdale
- 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 ... Using the If...End If Decision Structures
- See Training Course Details...
Understanding the Err Object
Using Break Mode during Run Mode
Declaring and Creating Object Variables
Using the Select Case...End Select Structure
Working with Boolean Expressions
Understanding Expressions and Statements
Understanding Modules
Using Input Boxes
Specifying a Recordset Cursor Type
Understanding the Form Object
Working with Variable Lifetime
Understanding Classes and Objects
Working with Properties
Using Visual Basic Help
Using Debugging Tools
Trapping Errors with the On Error Statement
Organizing Code and Procedures
Guidelines for use of Branching Structures
Understanding Constants
Email us about this courses
Other Rochdale Enable Technology Training Courses
SSAS Rochdale Training Courses
TSQL - Rochdale SQL Training Courses
JQuery - Rochdale JavaScript Training Courses
Data Warehouse Rochdale Training Courses
Power Query Rochdale Training Courses
JQuery Mobile Rochdale Training Courses