ACCESS TRAINING COURSES WALSALL
About Enable Technology Walsall Access Training Courses
We offer intensive two and three days Access courses. We guarantee the training will be delivered by a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. We can also deliver the Access course at a local training venue in Walsall. Every Access course can be modified to meet your bespoke requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: South Staffordshire Water PLC, TalkTalk Direct Limited, Lloyds TSB Bank PLC, Dollond & Aitchison Limited, Halfords Group PLC, Loughborough University, Keele University and Norfolk Police Constabulary.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Walsall
- Telephone on 01952 938014
- 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 ... Controlling Program Execution
- See Training Course Details...
Organizing Code and Procedures
Working with Procedures and Functions
Declaring and Creating Object Variables
Understanding Control-of-Flow Structures
Calling Procedures
Understanding the Development Environment
Working with the Code Editor
Navigating the Access Object Hierarchy
Trapping Errors with the On Error Statement
Working with Methods
Declaring Variables
Using Break Mode during Run Mode
Using Intrinsic Functions
Working with Boolean Expressions
Understanding Recordset Cursor Properties - Optional
Using the Do...Loop Structure
Working with the Application Object
Using Message Boxes
Writing an Error-Handling Routine
Microsoft Access
- 2 day course
- Location: Walsall
- 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 ... Database Security
- See Training Course Details...
Formatting Tables
Multi Table Queries
Creating a Lookup Database
Creating and Using Forms
Relational Database Design
Designing a Lookup Database
Data Validation
Importing and Exporting Records
Getting to Know Access
Navigation Pane Protection
Adding Transactional Records
Adding Records to a Table
Setting Table Relationships
Querying Techniques
Using a Navigation Form
Macro Techniques
Understanding VBA
Creating and Using Reports
Action Queries
DIY Forms
Email us about this courses
Other Walsall Enable Technology Training Courses
Excel 365 Intermediate Walsall Training Courses
DAX - Walsall Excel Training Courses
Excel 365 Advanced Walsall Training Courses
JQuery Walsall Training Courses
Excel Power Pivot - Walsall Excel Training Courses
SQL - Walsall SQL Training Courses