ACCESS TRAINING COURSES LEIGH
About Enable Technology Leigh Access Training Courses
We have a twenty year history of providing skills based Access industry training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a local training venue in Leigh. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Dollond & Aitchison Limited, Unipart Group, Birmingham City University, Total Telecommunications Limited, Carillion PLC, Yell Group PLC, Norfolk Police Constabulary and Queen's Medical Centre Nottingham.
Microsoft Access
- 2 day course
- Location: Leigh
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Getting to Know Access
- See Training Course Details...
Working With Records
Data Validation
Macro Techniques
Database Security
Adding Transactional Records
Macros on Forms
Parameter Queries
Creating a Relational Database
Modifying Forms
Calculations in Queries
Using a Navigation Form
Understanding VBA
Querying Techniques
Adding Records to a Table
Database Wellness
Creating Queries
DIY Forms
Creating and Using Macros
Creating and Using Forms
Navigation Pane Protection
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leigh
- 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 ... Using Intrinsic Constants
- See Training Course Details...
Using the For...Next Structure
Why Program in Access?
Understanding Control-of-Flow Structures
Using the If...End If Decision Structures
Using the For Each...Next Structure
Using the Do...Loop Structure
Understanding the Form Object
Using Input Boxes
Working with Methods
Using Expressions, Variables, and Intrinsic Functions
Introduction to Programming in Access
Using the Select Case...End Select Structure
Declaring and Creating Object Variables
Using the Object Browser
Setting Break Expressions
Handling Errors
Understanding Modules
Using Intrinsic Functions
Email us about this courses
Other Leigh Enable Technology Training Courses
SQL - Leigh SQL Training Courses
Data Warehouse - Leigh SQL Training Courses
Excel Power Pivot - Leigh Excel Training Courses
PL/SQL - Leigh SQL Training Courses
JQuery Mobile - Leigh JavaScript Training Courses
Excel 365 Advanced Leigh Training Courses