Enable Technology

ACCESS LANCASHIRE TRAINING COURSES 

ACCESS TRAINING COURSES LANCASHIRE




About Enable Technology Lancashire Access Training Courses

We offer intensive two and three days Access courses. We guarantee the training will be delivered by a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. 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.

We provide instructor led training coupled with hands on training. 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 Lancashire. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Keele University, Total Telecommunications Limited, South Staffordshire Water PLC, Boots UK Limited, Fujistu PLC, Nationwide Building Society Limited, GKN PLC and Cadbury PLC.




Microsoft Access

  • 2 day course
  • Location: Lancashire
  • 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 ...
  • Navigation Pane Protection
    Modifying Forms
    Sorting and Filtering
    Modifying Table Structures
    Setting Table Relationships
    Designing a Lookup Database
    Adding Transactional Records
    Calculations in Queries
    Database Wellness
    Getting to Know Access 
    Creating Queries
    Database Security
    Creating and Using Reports
    Creating and Using Macros
    Querying Techniques
    Aggregation Queries
    Understanding VBA
    Action Queries
    Importing and Exporting Records
    Macros on Forms
    Data Validation

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Lancashire
  • 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 ...
  • Stepping through Code
    Understanding the Err Object
    Understanding Error Handling
    Working with Methods
    Using Intrinsic Constants
    Controlling Program Execution
    Understanding Constants
    Setting Breakpoints
    Understanding Control-of-Flow Structures
    Using Input Boxes
    Understanding Collections
    Naming Procedures
    Using Break Mode during Run Mode
    Understanding the DoCmd Object
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Errors
    Setting Break Expressions
    Working with Properties
    Introduction to Programming in Access

  • See Training Course Details...



Email us about this courses



Other Lancashire Enable Technology Training Courses

DAX - Lancashire Excel Training Courses
SQL - Lancashire SQL Training Courses
TSQL Lancashire Training Courses
Excel 365 Advanced - Lancashire Excel Training Courses
VBA Lancashire Training Courses
SSIS - Lancashire SQL Server Integration Services Training Courses