ACCESS TRAINING COURSES PUDSEY
About Enable Technology Pudsey Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training Access resources which they can continue to use after the training. 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a training location in Pudsey. We are happy to modify the Access syllabus to match your teams training 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Vodafone Group Services, Nationwide Building Society Limited, Birmingham Heartlands Hospital, Norwich Union PLC, Yell Group PLC, Wolverhampton City Council, Total Telecommunications Limited and Queen's Medical Centre Nottingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Pudsey
- 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 Do...Loop Structure
- See Training Course Details...
Understanding Procedures
Working with Recordsets
Using the Immediate Window to Call Procedures
Working with the Application Object
Creating a Function Procedure
Using Visual Basic Help
Using the For Each...Next Structure
Understanding Modules
Controlling Program Execution
Understanding the Order of Events
Locking Records for Updating
Understanding Expressions and Statements
Understanding the Development Environment
Working with Properties
Working with Procedures and Functions
Specifying a Recordset Cursor Location - Optional
Using Break Mode during Run Mode
Understanding VBA's Error Trapping Options
Understanding Collections
Microsoft Access
- 2 day course
- Location: Pudsey
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Creating and Using Reports
- See Training Course Details...
Formatting Tables
Relational Database Design
Navigation Pane Protection
Adding Transactional Records
Parameter Queries
Sorting and Filtering
Macro Techniques
Querying Techniques
Data Validation
Modifying Forms
DIY Forms
Creating and Using Forms
Creating a Lookup Database
Getting to Know Access
Calculations in Queries
Macros on Forms
Working With Records
Creating and Using Macros
Modifying Table Structures
Using a Navigation Form
Email us about this courses
Other Pudsey Enable Technology Training Courses
Power BI Pudsey Training Courses
Data Warehouse Pudsey Training Courses
Excel 365 Intermediate Pudsey Training Courses
Oracle SQL - Pudsey SQL Training Courses
TSQL - Pudsey SQL Training Courses
DAX Pudsey Training Courses