ACCESS TRAINING COURSES WETHERBY
About Enable Technology Wetherby Access Training Courses
We have a twenty year history of providing skills based Access industry training. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and Access course resources that can be referenced post training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Wetherby. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: South Staffordshire Water PLC, Norwich Union PLC, Countrywide Homes Limited, Cadbury PLC, Shell UK Oil Products Ltd, Total Telecommunications Limited, Dollond & Aitchison Limited and Yell Group PLC.
Microsoft Access
- 2 day course
- Location: Wetherby
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Calculations in Queries
- See Training Course Details...
Importing and Exporting Records
Modifying Forms
Working With Records
Designing a Lookup Database
DIY Forms
Setting Table Relationships
Adding Records to a Table
Macros on Forms
Relational Database Design
Getting to Know Access
Action Queries
Creating and Using Macros
Database Wellness
Adding Transactional Records
Creating a Relational Database
Creating and Using Reports
Creating and Using Forms
Aggregation Queries
Database Security
Understanding VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wetherby
- 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 ... Using the With Statement
- See Training Course Details...
Using the If...End If Decision Structures
Handling Errors
Setting Breakpoints
Using Visual Basic Help
Trapping Errors with the On Error Statement
Why Program in Access?
Understanding Procedures
Understanding the Err Object
Using the Do...Loop Structure
Using Intrinsic Constants
Locking Records for Updating
Working with Methods
Using the CacheSize Property - Optional
Understanding the Order of Events
Working with Variable Lifetime
Organizing Code and Procedures
Declaring and Creating Object Variables
Using the Select Case...End Select Structure
Email us about this courses
Other Wetherby Enable Technology Training Courses
SSIS - Wetherby SQL Server Integration Services Training Courses
TSQL Wetherby Training Courses
Excel 365 Basic Wetherby Training Courses
Excel Power Pivot - Wetherby Excel Training Courses
Report Builder - Wetherby SQL Server Reporting Services Training Courses
Data Warehouse - Wetherby SQL Training Courses