ACCESS TRAINING COURSES MANCHESTER
About Enable Technology Manchester Access Training Courses
Enable Technology specialise in succinct skills based Access training. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to 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.
Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Manchester. We are happy to modify the Access syllabus to match your teams training requirements.
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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: West Bromwich Building Society, Nuclear Engineering Services, Birmingham City Council, Total Telecommunications Limited, Dollond & Aitchison Limited, Loughborough University, Halfords Group PLC and Carillion PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Manchester
- 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 ... Trapping Errors with the On Error Statement
- See Training Course Details...
Creating a Standard Module
Specifying a Recordset Cursor Type
Debugging Code
Organizing Code and Procedures
Declaring and Creating Object Variables
Understanding Recordset Cursor Properties - Optional
Considering Variable Scope and Lifetime Together
Using Intrinsic Functions
Using Message Boxes
Using Debugging Tools
Working with Inline Error Handling
Understanding Objects
Using the With Statement
Understanding the Err Object
Working with the ADODB Recordset Object
Using the If...End If Decision Structures
Using the Object Browser
Microsoft Access
- 2 day course
- Location: Manchester
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Aggregation Queries
- See Training Course Details...
Working With Records
Designing a Lookup Database
Navigation Pane Protection
Relational Database Design
Multi Table Queries
Getting to Know Access
Using a Navigation Form
Sorting and Filtering
Modifying Forms
Macro Techniques
Database Security
Creating Queries
Adding Transactional Records
Querying Techniques
Creating and Using Forms
Modifying Table Structures
Setting Table Relationships
Action Queries
DIY Forms
Adding Records to a Table
Email us about this courses
Other Manchester Enable Technology Training Courses
JQuery Mobile - Manchester JavaScript Training Courses
Excel 365 Intermediate Manchester Training Courses
Report Builder Manchester Training Courses
Excel 365 Advanced Manchester Training Courses
Power BI - Manchester Microsoft Power BI Training Courses
SSAS Tabular Manchester Training Courses