ACCESS TRAINING COURSES PYLE
About Enable Technology Pyle Access Training Courses
Enable Technology provides practical Access skills based technology training. All Enable Technology tutors are Microsoft certified experts. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can deliver at your premises. We can provide the equipment. The Access course could also be scheduled at a socially distanced site near you in Pyle. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Birmingham City Council, Barclays Bank PLC, Aston University, Fujistu PLC, Birmingham Heartlands Hospital, Vodafone Group Services, Boots UK Limited and Loughborough University.
Microsoft Access
- 2 day course
- Location: Pyle
- 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 ... Sorting and Filtering
- See Training Course Details...
Working With Records
Modifying Table Structures
Creating a Lookup Database
Macro Techniques
Getting to Know Access
Aggregation Queries
Importing and Exporting Records
Creating and Using Macros
Creating and Using Reports
Multi Table Queries
Creating Queries
An Introduction to VBA
Formatting Tables
Setting Table Relationships
Navigation Pane Protection
Creating and Using Forms
Using a Navigation Form
Modifying Forms
Understanding VBA
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Pyle
- 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 ... Why Program in Access?
- See Training Course Details...
Understanding the DoCmd Object
Specifying a Recordset Cursor Type
Using the CacheSize Property - Optional
Understanding Expressions and Statements
Writing an Error-Handling Routine
Understanding Error Handling
Working with Recordsets
Working with Variable Lifetime
Understanding Control-of-Flow Structures
Setting Break Expressions
Working with the Code Editor
Considering Variable Scope and Lifetime Together
Using the With Statement
Understanding VBA's Error Trapping Options
Organizing Code and Procedures
Using Expressions, Variables, and Intrinsic Functions
Creating a Sub Procedure
Understanding Collections
Email us about this courses
Other Pyle Enable Technology Training Courses
Excel 365 Intermediate Pyle Training Courses
Power Query Pyle Training Courses
Excel Power Pivot Pyle Training Courses
SSRS Pyle Training Courses
SQL - Pyle SQL Training Courses
SSAS - Pyle SQL Server Analysis Services Training Courses