ACCESS TRAINING COURSES BARRY
About Enable Technology Barry Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We provide instructor led training coupled with hands on training. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a training location in Barry. We are happy to modify the Access syllabus to match your teams 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are National Power PLC, Total Telecommunications Limited, Lloyds TSB Bank PLC, Halfords Group PLC, University of Birmingham, Norfolk Police Constabulary, Norwich Union PLC and Royal & Sun Alliance Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Barry
- 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 ... Setting Break Expressions
- See Training Course Details...
Debugging Code
Understanding Collections
Working with the Code Editor
Setting Breakpoints
Using the With Statement
Using the For Each...Next Structure
Understanding Error Handling
Why Program in Access?
Using Input Boxes
Working with Methods
Handling Errors
Working with Boolean Expressions
Using the Object Browser
Using the CacheSize Property - Optional
Declaring and Creating Object Variables
Using Intrinsic Functions
Working with Properties
Understanding Procedures
Microsoft Access
- 2 day course
- Location: Barry
- 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 ... DIY Forms
- See Training Course Details...
Navigation Pane Protection
Calculations in Queries
Creating a Relational Database
Modifying Forms
Action Queries
Setting Table Relationships
Multi Table Queries
Creating a Lookup Database
An Introduction to VBA
Database Wellness
Relational Database Design
Sorting and Filtering
Getting to Know Access
Database Security
Creating and Using Forms
Parameter Queries
Using a Navigation Form
Importing and Exporting Records
Working With Records
Macro Techniques
Email us about this courses
Other Barry Enable Technology Training Courses
Excel 365 Advanced Barry Training Courses
SSAS Tabular - Barry SQL Server Analysis Services Training Courses
Power BI - Barry Microsoft Power BI Training Courses
Data Warehouse Barry Training Courses
PL/SQL - Barry SQL Training Courses
Power Query Barry Training Courses