ACCESS TRAINING COURSES BURY
About Enable Technology Bury Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a Access course at an alternative training site in Bury. 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.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Homeserve PLC, Lloyds TSB Bank PLC, Norwich Union PLC, Halfords Group PLC, TalkTalk Direct Limited, Wolverhampton City Council, South Staffordshire Water PLC and Keele University.
Microsoft Access
- 2 day course
- Location: Bury
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Relational Database Design
- See Training Course Details...
Aggregation Queries
Adding Transactional Records
DIY Forms
Calculations in Queries
Macros on Forms
Creating and Using Reports
Navigation Pane Protection
Using a Navigation Form
Database Wellness
Sorting and Filtering
Getting to Know Access
Creating a Lookup Database
Creating Queries
Querying Techniques
Importing and Exporting Records
Setting Table Relationships
Creating and Using Forms
Modifying Forms
An Introduction to VBA
Data Validation
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bury
- 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 ... Understanding the Order of Events
- See Training Course Details...
Working with Properties
Using Expressions, Variables, and Intrinsic Functions
Understanding the DoCmd Object
Working with the Application Object
Using the Do...Loop Structure
Understanding the Err Object
Writing an Error-Handling Routine
Creating a Sub Procedure
Understanding VBA's Error Trapping Options
Specifying a Recordset Cursor Location - Optional
Why Program in Access?
Stepping through Code
Using the If...End If Decision Structures
Trapping Errors with the On Error Statement
Working with Methods
Determining the Value of Expressions
Introduction to Programming in Access
Using Input Boxes
Email us about this courses
Other Bury Enable Technology Training Courses
Power BI - Bury Microsoft Power BI Training Courses
JavaScript - Bury JavaScript Training Courses
TSQL Bury Training Courses
Report Builder Bury Training Courses
SSAS Tabular Bury Training Courses
SSRS - Bury SQL Server Reporting Services Training Courses