ACCESS TRAINING COURSES MACCLESFIELD
About Enable Technology Macclesfield Access Training Courses
We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology offers instructor led training taught by technology specialists. We are set up to deliver Access training courses onsite at your premises. If delivery onsite is an issue we will organise a venue near you in Macclesfield. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Dollond & Aitchison Limited, Birmingham City Council, GKN PLC, South Staffordshire Water PLC, Countrywide Homes Limited, TalkTalk Direct Limited, Wolverhampton City Council and Vodafone Group Services.
Microsoft Access
- 2 day course
- Location: Macclesfield
- 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 ... Macro Techniques
- See Training Course Details...
Setting Table Relationships
Database Security
Using a Navigation Form
Macros on Forms
Creating and Using Reports
An Introduction to VBA
Creating and Using Macros
Creating Queries
Adding Records to a Table
Adding Transactional Records
DIY Forms
Multi Table Queries
Navigation Pane Protection
Sorting and Filtering
Modifying Forms
Aggregation Queries
Action Queries
Database Wellness
Importing and Exporting Records
Creating a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Macclesfield
- 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 ... Declaring and Creating Object Variables
- See Training Course Details...
Understanding Modules
Using Expressions, Variables, and Intrinsic Functions
Working with the Code Editor
Understanding the DoCmd Object
Setting Breakpoints
Why Program in Access?
Using the Do...Loop Structure
Organizing Code and Procedures
Working with Procedures and Functions
Using Intrinsic Functions
Calling Procedures
Working with Properties
Declaring Variables
Locking Records for Updating
Creating a Function Procedure
Understanding Classes and Objects
Using the With Statement
Determining the Value of Expressions
Naming Procedures
Understanding Expressions and Statements
Email us about this courses
Other Macclesfield Enable Technology Training Courses
DAX Macclesfield Training Courses
Power Query Macclesfield Training Courses
JQuery Mobile - Macclesfield JavaScript Training Courses
VBA Macclesfield Training Courses
TSQL - Macclesfield SQL Training Courses
Excel 365 Advanced - Macclesfield Excel Training Courses