ACCESS TRAINING COURSES WEDNESBURY
About Enable Technology Wednesbury Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. We provide every candidate with Access training materials which they keep after the course. 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. If you prefer we can offer an offsite socially distanced training location in Wednesbury. Every Access course can be modified to meet your bespoke 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 guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Nationwide Building Society Limited, West Bromwich Building Society, Nuclear Engineering Services, South Staffordshire Water PLC, Wolverhampton City Council, National Power PLC, DHL Express and Norfolk Police Constabulary.
Microsoft Access
- 2 day course
- Location: Wednesbury
- 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 ... Importing and Exporting Records
- See Training Course Details...
Sorting and Filtering
Relational Database Design
Macros on Forms
Modifying Table Structures
Creating and Using Forms
Database Wellness
Creating Queries
An Introduction to VBA
Action Queries
DIY Forms
Data Validation
Creating and Using Macros
Modifying Forms
Creating a Relational Database
Formatting Tables
Creating and Using Reports
Querying Techniques
Navigation Pane Protection
Aggregation Queries
Creating a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wednesbury
- 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 ... Handling Errors
- See Training Course Details...
Understanding Constants
Understanding the Form Object
Understanding the DoCmd Object
Guidelines for use of Branching Structures
Using the For Each...Next Structure
Considering Variable Scope and Lifetime Together
Understanding Error Handling
Using Debugging Tools
Understanding Data Types
Using the Do...Loop Structure
Naming Procedures
Locking Records for Updating
Declaring Variables
Understanding Control-of-Flow Structures
Working with Properties
Working with Boolean Expressions
Understanding the Order of Events
Using the Select Case...End Select Structure
Email us about this courses
Other Wednesbury Enable Technology Training Courses
Report Builder Wednesbury Training Courses
TSQL - Wednesbury SQL Training Courses
Oracle SQL Wednesbury Training Courses
Excel 365 Basic - Wednesbury Excel Training Courses
Excel Power Pivot - Wednesbury Excel Training Courses
Power BI Wednesbury Training Courses