ACCESS TRAINING COURSES ROWLEY
About Enable Technology Rowley Access Training Courses
Enable Technology specialise in succinct skills based Access training. The course will always be taught by a Microsoft Certified Professional (MCP). 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.
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. The Access course could also be scheduled at a socially distanced site near you in Rowley. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Yell Group PLC, Total Telecommunications Limited, Countrywide Homes Limited, Birmingham City University, Norfolk Police Constabulary, Capita Group PLC, Wolverhampton City Council and Queen's Medical Centre Nottingham.
Microsoft Access
- 2 day course
- Location: Rowley
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Calculations in Queries
- See Training Course Details...
Setting Table Relationships
Action Queries
Creating and Using Macros
Designing a Lookup Database
Multi Table Queries
Sorting and Filtering
Querying Techniques
Formatting Tables
Adding Transactional Records
Creating Queries
Macro Techniques
Data Validation
Database Security
Creating and Using Reports
Creating a Lookup Database
Relational Database Design
Parameter Queries
Understanding VBA
Aggregation Queries
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rowley
- 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 Constants
- See Training Course Details...
Creating a Sub Procedure
Understanding the DoCmd Object
Understanding the Form Object
Using the With Statement
Working with the Application Object
Controlling Program Execution
Understanding Data Types
Creating a Standard Module
Working with Inline Error Handling
Working with Events
Using Debugging Tools
Understanding Objects
Setting Breakpoints
Working with Methods
Using the Do...Loop Structure
Understanding Errors
Understanding the Err Object
Working with Procedures and Functions
Working with Variable Scope
Email us about this courses
Other Rowley Enable Technology Training Courses
Report Builder - Rowley SQL Server Reporting Services Training Courses
SSAS - Rowley SQL Server Analysis Services Training Courses
SSIS - Rowley SQL Server Integration Services Training Courses
Power Query - Rowley Excel Training Courses
JavaScript Rowley Training Courses
SSRS - Rowley SQL Server Reporting Services Training Courses