ACCESS TRAINING COURSES LEICESTERSHIRE
About Enable Technology Leicestershire Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in Leicestershire. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time 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 Barclays Bank PLC, Homeserve PLC, Aston University, Shell UK Oil Products Ltd, Canadian High Commission, Royal Air Force, Vodafone Group Services and Royal & Sun Alliance Group PLC.
Microsoft Access
- 2 day course
- Location: Leicestershire
- 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 ... Parameter Queries
- See Training Course Details...
Macros on Forms
Navigation Pane Protection
Action Queries
Using a Navigation Form
Setting Table Relationships
Adding Records to a Table
Modifying Table Structures
Relational Database Design
Adding Transactional Records
Sorting and Filtering
Creating and Using Reports
Creating Queries
Importing and Exporting Records
Data Validation
Database Wellness
Multi Table Queries
Aggregation Queries
Querying Techniques
Formatting Tables
Getting to Know Access
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leicestershire
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Navigating the Access Object Hierarchy
- See Training Course Details...
Working with Variable Scope
Why Program in Access?
Working with Procedures and Functions
Using the If...End If Decision Structures
Understanding Errors
Stepping through Code
Using Input Boxes
Understanding the DoCmd Object
Creating a Sub Procedure
Using Expressions, Variables, and Intrinsic Functions
Using Intrinsic Constants
Using the Object Browser
Using the Immediate Window to Call Procedures
Working with Events
Using Debugging Tools
Creating a Standard Module
Working with Properties
Calling Procedures
Setting Breakpoints
Email us about this courses
Other Leicestershire Enable Technology Training Courses
Excel 365 Advanced Leicestershire Training Courses
Power BI - Leicestershire Microsoft Power BI Training Courses
Excel 365 Intermediate - Leicestershire Excel Training Courses
TSQL Leicestershire Training Courses
VBA - Leicestershire Excel Training Courses
SSRS Leicestershire Training Courses