ACCESS TRAINING COURSES HUYTON
About Enable Technology Huyton Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to 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.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Huyton. All Access courses can be customised to meet your particular 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 two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Capita Group PLC, Royal Air Force, Aston University, TalkTalk Direct Limited, Birmingham City University, Fujistu PLC, Cadbury PLC and Queen's Medical Centre Nottingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Huyton
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding the DoCmd Object
- See Training Course Details...
Using the Select Case...End Select Structure
Using Input Boxes
Using the If...End If Decision Structures
Working with Boolean Expressions
Using Visual Basic Help
Working with Variable Scope
Using the For...Next Structure
Declaring and Creating Object Variables
Understanding Procedures
Navigating the Access Object Hierarchy
Organizing Code and Procedures
Working with Inline Error Handling
Setting Break Expressions
Understanding VBA's Error Trapping Options
Using Debugging Tools
Understanding Data Types
Guidelines for use of Branching Structures
Microsoft Access
- 2 day course
- Location: Huyton
- 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 ... Modifying Forms
- See Training Course Details...
Aggregation Queries
Navigation Pane Protection
Designing a Lookup Database
Multi Table Queries
Parameter Queries
Macros on Forms
Creating a Relational Database
Calculations in Queries
Modifying Table Structures
Creating and Using Macros
Creating a Lookup Database
Sorting and Filtering
Database Wellness
Getting to Know Access
Data Validation
Querying Techniques
DIY Forms
Creating and Using Reports
Working With Records
Using a Navigation Form
Email us about this courses
Other Huyton Enable Technology Training Courses
Power Query Huyton Training Courses
TSQL Huyton Training Courses
SSAS Huyton Training Courses
SSRS - Huyton SQL Server Reporting Services Training Courses
Oracle SQL - Huyton SQL Training Courses
Excel 365 Intermediate - Huyton Excel Training Courses