ACCESS TRAINING COURSES SCUNTHORPE
About Enable Technology Scunthorpe Access Training Courses
Enable Technology provides practical Access skills based technology training. The training will be delivered by a Microsoft professional with development experience. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We are also more than happy to organise a local course at a training location in Scunthorpe. We are happy to modify the Access syllabus to match your teams training 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 Carillion PLC, Nuclear Engineering Services, Canadian High Commission, Royal & Sun Alliance Group PLC, Vodafone Group Services, Loughborough University, Cadbury PLC and GKN PLC.
Microsoft Access
- 2 day course
- Location: Scunthorpe
- 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 ... Getting to Know Access
- See Training Course Details...
Relational Database Design
Database Wellness
Modifying Forms
Navigation Pane Protection
Multi Table Queries
Querying Techniques
Aggregation Queries
Action Queries
Creating a Relational Database
Working With Records
Sorting and Filtering
Using a Navigation Form
An Introduction to VBA
Formatting Tables
Database Security
Understanding VBA
Creating and Using Macros
Designing a Lookup Database
Parameter Queries
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Scunthorpe
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding the DoCmd Object
- See Training Course Details...
Determining the Value of Expressions
Working with the Application Object
Controlling Program Execution
Calling Procedures
Creating a Standard Module
Working with Procedures and Functions
Working with Properties
Declaring Variables
Naming Procedures
Trapping Errors with the On Error Statement
Using the CacheSize Property - Optional
Understanding Classes and Objects
Understanding Constants
Introduction to Programming in Access
Using Visual Basic Help
Using Intrinsic Functions
Debugging Code
Specifying a Recordset Cursor Type
Email us about this courses
Other Scunthorpe Enable Technology Training Courses
DAX - Scunthorpe Excel Training Courses
SSAS Tabular Scunthorpe Training Courses
Power BI - Scunthorpe Microsoft Power BI Training Courses
TSQL - Scunthorpe SQL Training Courses
Excel 365 Advanced - Scunthorpe Excel Training Courses
Oracle SQL - Scunthorpe SQL Training Courses