ACCESS TRAINING COURSES ASHTON-UNDER-LYNE
About Enable Technology Ashton-under-lyne Access Training Courses
We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given Access courseware which they can refer to 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.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of Access course at a socially distanced venue near you in Ashton-under-lyne. All Access courses can be customised to meet your particular requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have operated primarily in the West Midlands for twenty years. Our clients include: Vodafone Group Services, Shell UK Oil Products Ltd, Keele University, Homeserve PLC, Birmingham City University, Birmingham Heartlands Hospital, Norfolk Police Constabulary and Countrywide Homes Limited.
Microsoft Access
- 2 day course
- Location: Ashton-under-lyne
- Telephone on 01952 305730
- 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 ... DIY Forms
- See Training Course Details...
Database Wellness
Designing a Lookup Database
Aggregation Queries
Database Security
Data Validation
Getting to Know Access
Importing and Exporting Records
Modifying Table Structures
Sorting and Filtering
Relational Database Design
Formatting Tables
Setting Table Relationships
Querying Techniques
Working With Records
Creating Queries
Adding Transactional Records
Navigation Pane Protection
Creating a Relational Database
Calculations in Queries
Using a Navigation Form
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ashton-under-lyne
- Telephone on 01952 305730
- 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 Message Boxes
- See Training Course Details...
Working with Boolean Expressions
Determining the Value of Expressions
Using the CacheSize Property - Optional
Understanding Error Handling
Understanding Data Types
Creating a Function Procedure
Using the Do...Loop Structure
Working with Variable Scope
Using the Select Case...End Select Structure
Using the Object Browser
Stepping through Code
Navigating the Access Object Hierarchy
Working with Variable Lifetime
Understanding Classes and Objects
Working with the Application Object
Using the Immediate Window to Call Procedures
Using Expressions, Variables, and Intrinsic Functions
Declaring and Creating Object Variables
Email us about this courses
Other Ashton-under-lyne Enable Technology Training Courses
Data Mining Ashton-under-lyne Training Courses
Crystal XI - Ashton-under-lyne Crystal Reports Training Courses
Excel Basic - Ashton-under-lyne Excel Training Courses
CSS Ashton-under-lyne Training Courses
Microsoft Project Level 3 - Ashton-under-lyne Microsoft Project Training Courses
Excel Power Pivot Ashton-under-lyne Training Courses