Enable Technology

ACCESS ASHTON-UNDER-LYNE TRAINING COURSES 

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
    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

  • See Training Course Details...


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
    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

  • See Training Course Details...



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