ACCESS TRAINING COURSES SCARBOROUGH
About Enable Technology Scarborough Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. We also offer the option of scheduling of Access course at a venue near you in Scarborough. We are happy to discuss customising the course content should you have particular Access training requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Countrywide Homes Limited, Shell UK Oil Products Ltd, TalkTalk Direct Limited, University of Birmingham, Keele University, Total Telecommunications Limited, Norwich Union PLC and Dollond & Aitchison Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Scarborough
- 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 ... Creating a Standard Module
- See Training Course Details...
Using Break Mode during Run Mode
Trapping Errors with the On Error Statement
Understanding Collections
Using the If...End If Decision Structures
Creating a Sub Procedure
Using Message Boxes
Understanding Expressions and Statements
Using the Select Case...End Select Structure
Using Intrinsic Functions
Declaring and Creating Object Variables
Setting Break Expressions
Understanding the Order of Events
Working with Events
Writing an Error-Handling Routine
Specifying a Recordset Cursor Type
Handling Errors
Understanding Procedures
Setting Breakpoints
Microsoft Access
- 2 day course
- Location: Scarborough
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Creating a Relational Database
- See Training Course Details...
An Introduction to VBA
Calculations in Queries
Creating Queries
Formatting Tables
Action Queries
Multi Table Queries
Data Validation
Creating and Using Reports
Working With Records
Modifying Forms
Setting Table Relationships
Understanding VBA
Sorting and Filtering
Creating and Using Macros
Designing a Lookup Database
Database Wellness
Adding Records to a Table
Modifying Table Structures
Using a Navigation Form
Relational Database Design
Email us about this courses
Other Scarborough Enable Technology Training Courses
JQuery Mobile Scarborough Training Courses
JavaScript - Scarborough JavaScript Training Courses
Excel Power Pivot - Scarborough Excel Training Courses
SSAS - Scarborough SQL Server Analysis Services Training Courses
Power Query Scarborough Training Courses
PL/SQL Scarborough Training Courses