ACCESS TRAINING COURSES PUDSEY
About Enable Technology Pudsey Access Training Courses
We offer intensive two and three days Access courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with Access training materials which they keep after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local training site in Pudsey. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can 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. Our clients include: DHL Express, TalkTalk Direct Limited, Homeserve PLC, Norfolk Police Constabulary, Keele University, Wolverhampton City Council, Nuclear Engineering Services and Birmingham Heartlands Hospital.
Microsoft Access
- 2 day course
- Location: Pudsey
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Database Wellness
- See Training Course Details...
Data Validation
Using a Navigation Form
Creating a Relational Database
Creating a Lookup Database
DIY Forms
Understanding VBA
Creating and Using Macros
Getting to Know Access
Action Queries
Modifying Forms
Relational Database Design
Calculations in Queries
Sorting and Filtering
Multi Table Queries
Macros on Forms
Adding Records to a Table
Modifying Table Structures
Importing and Exporting Records
Formatting Tables
Parameter Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Pudsey
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Expressions and Statements
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Working with Properties
Working with the ADODB Recordset Object
Working with Boolean Expressions
Naming Procedures
Understanding Errors
Setting Breakpoints
Creating a Function Procedure
Understanding Data Types
Using Input Boxes
Navigating the Access Object Hierarchy
Working with Methods
Trapping Errors with the On Error Statement
Using Break Mode during Run Mode
Using Intrinsic Functions
Setting Break Expressions
Understanding the DoCmd Object
Declaring Variables
Using the For...Next Structure
Email us about this courses
Other Pudsey Enable Technology Training Courses
Oracle SQL - Pudsey SQL Training Courses
PL/SQL - Pudsey SQL Training Courses
TSQL Pudsey Training Courses
SSIS - Pudsey SQL Server Integration Services Training Courses
SQL - Pudsey SQL Training Courses
Power BI Pudsey Training Courses