ACCESS TRAINING COURSES MANCHESTER
About Enable Technology Manchester Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued Access training manuals they can refer to 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 courses are taught by a Microsoft Certified Solutions Expert. We can bring the equipment necessary to deliver Access courses at your site. Another option is we can organise a local socially distanced training site in Manchester. Every Access course can be modified to meet your bespoke requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are South Staffordshire Water PLC, Birmingham City Council, Canadian High Commission, West Bromwich Building Society, Royal & Sun Alliance Group PLC, Homeserve PLC, Keele University and Royal Air Force.
Microsoft Access
- 2 day course
- Location: Manchester
- 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 ... Getting to Know Access
- See Training Course Details...
Querying Techniques
Creating and Using Macros
Setting Table Relationships
Designing a Lookup Database
Calculations in Queries
Parameter Queries
Using a Navigation Form
Adding Transactional Records
Relational Database Design
Importing and Exporting Records
Action Queries
Understanding VBA
DIY Forms
Working With Records
Modifying Forms
Data Validation
Sorting and Filtering
Navigation Pane Protection
Database Security
Aggregation Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Manchester
- 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 the Immediate Window to Call Procedures
- See Training Course Details...
Understanding Collections
Specifying a Recordset Cursor Type
Working with Inline Error Handling
Working with Variable Scope
Using Message Boxes
Naming Procedures
Working with Procedures and Functions
Understanding Classes and Objects
Creating a Function Procedure
Declaring Variables
Determining the Value of Expressions
Using Expressions, Variables, and Intrinsic Functions
Understanding the Order of Events
Working with the Code Editor
Working with Properties
Trapping Errors with the On Error Statement
Understanding Error Handling
Email us about this courses
Other Manchester Enable Technology Training Courses
DAX Manchester Training Courses
Excel 365 Basic Manchester Training Courses
Excel 365 Advanced - Manchester Excel Training Courses
Report Builder - Manchester SQL Server Reporting Services Training Courses
Power BI - Manchester Microsoft Power BI Training Courses
Excel Power Pivot Manchester Training Courses