ACCESS TRAINING COURSES SHROPSHIRE
About Enable Technology Shropshire Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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 training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If delivery onsite is an issue we will organise a venue near you in Shropshire. 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 EDF Energy PLC, Total Telecommunications Limited, Vodafone Group Services, Birmingham City Council, Dollond & Aitchison Limited, DHL Express, Norfolk Police Constabulary and GKN PLC.
Microsoft Access
- 2 day course
- Location: Shropshire
- 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 ... Database Security
- See Training Course Details...
Data Validation
Creating Queries
Sorting and Filtering
Setting Table Relationships
Aggregation Queries
Database Wellness
Action Queries
Modifying Table Structures
Multi Table Queries
DIY Forms
Creating and Using Forms
Navigation Pane Protection
Importing and Exporting Records
Using a Navigation Form
An Introduction to VBA
Querying Techniques
Macros on Forms
Working With Records
Creating a Lookup Database
Creating a Relational Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Shropshire
- 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 ... Using Visual Basic Help
- See Training Course Details...
Calling Procedures
Handling Errors
Organizing Code and Procedures
Declaring Variables
Working with the ADODB Recordset Object
Working with Variable Lifetime
Using Expressions, Variables, and Intrinsic Functions
Debugging Code
Stepping through Code
Using the Immediate Window to Call Procedures
Using the CacheSize Property - Optional
Creating a Sub Procedure
Working with Properties
Using Intrinsic Constants
Naming Procedures
Specifying a Recordset Cursor Type
Specifying a Recordset Cursor Location - Optional
Controlling Program Execution
Understanding Data Types
Email us about this courses
Other Shropshire Enable Technology Training Courses
JQuery Shropshire Training Courses
JavaScript Shropshire Training Courses
Excel 365 Basic Shropshire Training Courses
SSAS Tabular - Shropshire SQL Server Analysis Services Training Courses
JQuery Mobile Shropshire Training Courses
Oracle SQL - Shropshire SQL Training Courses