ACCESS TRAINING COURSES HYDE
About Enable Technology Hyde Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We are set up to deliver Access training courses onsite at your premises. We also offer the option of scheduling of Access course at a socially distanced venue near you in Hyde. The Access syllabus can be modified to accommodate your specific training needs.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Nuclear Engineering Services, Birmingham Heartlands Hospital, DHL Express, Yell Group PLC, South Staffordshire Water PLC, National Power PLC, Aston University and Royal & Sun Alliance Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Hyde
- 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 ... Using the Immediate Window to Call Procedures
- See Training Course Details...
Using the Do...Loop Structure
Writing an Error-Handling Routine
Creating a Standard Module
Using Intrinsic Functions
Using the For...Next Structure
Understanding Objects
Working with Variable Scope
Setting Break Expressions
Working with the ADODB Recordset Object
Working with Boolean Expressions
Debugging Code
Using Debugging Tools
Introduction to Programming in Access
Working with Recordsets
Declaring Variables
Using the If...End If Decision Structures
Microsoft Access
- 2 day course
- Location: Hyde
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Macros on Forms
- See Training Course Details...
Modifying Forms
Data Validation
Calculations in Queries
Importing and Exporting Records
Creating and Using Reports
Working With Records
Multi Table Queries
Database Wellness
Action Queries
Creating a Lookup Database
Navigation Pane Protection
Querying Techniques
Macro Techniques
Modifying Table Structures
Adding Transactional Records
Sorting and Filtering
Designing a Lookup Database
Formatting Tables
Creating and Using Forms
Relational Database Design
Email us about this courses
Other Hyde Enable Technology Training Courses
TSQL - Hyde SQL Training Courses
SSAS Tabular - Hyde SQL Server Analysis Services Training Courses
Excel 365 Advanced - Hyde Excel Training Courses
VBA Hyde Training Courses
Power Query Hyde Training Courses
Power BI Hyde Training Courses