ACCESS TRAINING COURSES OLDHAM
About Enable Technology Oldham Access Training Courses
Enable Technology provides practical Access skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in Oldham. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Boots UK Limited, Barclays Bank PLC, Birmingham City University, Canadian High Commission, Carillion PLC, Royal Air Force, Fujistu PLC and Homeserve PLC.
Microsoft Access
- 2 day course
- Location: Oldham
- 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 ... DIY Forms
- See Training Course Details...
Aggregation Queries
Parameter Queries
Adding Transactional Records
Calculations in Queries
Creating Queries
Multi Table Queries
Macros on Forms
Creating and Using Reports
Understanding VBA
Macro Techniques
Importing and Exporting Records
Designing a Lookup Database
Modifying Table Structures
Relational Database Design
Working With Records
Data Validation
Creating a Lookup Database
Creating and Using Macros
Setting Table Relationships
Creating a Relational Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Oldham
- 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 ... Understanding the Development Environment
- See Training Course Details...
Using the Immediate Window to Call Procedures
Working with the Code Editor
Working with Boolean Expressions
Using Input Boxes
Controlling Program Execution
Creating a Function Procedure
Working with Variable Scope
Understanding Error Handling
Understanding the Err Object
Determining the Value of Expressions
Creating a Standard Module
Working with the ADODB Recordset Object
Using Expressions, Variables, and Intrinsic Functions
Understanding Recordset Cursor Properties - Optional
Working with Properties
Using Intrinsic Functions
Working with Events
Working with Methods
Email us about this courses
Other Oldham Enable Technology Training Courses
SSIS Oldham Training Courses
JQuery Mobile Oldham Training Courses
Report Builder Oldham Training Courses
Data Warehouse - Oldham SQL Training Courses
Excel 365 Intermediate - Oldham Excel Training Courses
SSAS Oldham Training Courses