ACCESS TRAINING COURSES POOLE
About Enable Technology Poole Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post 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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. If you prefer we can offer an offsite socially distanced training location in Poole. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Canadian High Commission, Lloyds TSB Bank PLC, TalkTalk Direct Limited, National Power PLC, Countrywide Homes Limited, Aston University, Queen's Medical Centre Nottingham and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Poole
- 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 ... Macro Techniques
- See Training Course Details...
Getting to Know Access
Creating a Relational Database
Importing and Exporting Records
Relational Database Design
Using a Navigation Form
Adding Transactional Records
Parameter Queries
Macros on Forms
Creating and Using Macros
Database Security
Querying Techniques
Modifying Table Structures
Database Wellness
Sorting and Filtering
Creating Queries
Working With Records
Setting Table Relationships
Calculations in Queries
DIY Forms
Creating a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Poole
- 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 ... Using Input Boxes
- See Training Course Details...
Using the With Statement
Understanding Data Types
Using the If...End If Decision Structures
Using the Object Browser
Locking Records for Updating
Creating a Standard Module
Specifying a Recordset Cursor Location - Optional
Using Break Mode during Run Mode
Organizing Code and Procedures
Using Visual Basic Help
Setting Breakpoints
Understanding Expressions and Statements
Calling Procedures
Stepping through Code
Using the For Each...Next Structure
Understanding the Development Environment
Working with Variable Scope
Working with the ADODB Recordset Object
Email us about this courses
Other Poole Enable Technology Training Courses
Data Warehouse - Poole SQL Training Courses
SSAS - Poole SQL Server Analysis Services Training Courses
PL/SQL - Poole SQL Training Courses
SSIS - Poole SQL Server Integration Services Training Courses
Excel 365 Basic - Poole Excel Training Courses
JQuery - Poole JavaScript Training Courses