Enable Technology

ACCESS BURY TRAINING COURSES 

ACCESS TRAINING COURSES BURY




About Enable Technology Bury Access Training Courses

We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a Access course at an alternative training site in Bury. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Homeserve PLC, Lloyds TSB Bank PLC, Norwich Union PLC, Halfords Group PLC, TalkTalk Direct Limited, Wolverhampton City Council, South Staffordshire Water PLC and Keele University.




Microsoft Access

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

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bury
  • 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 ...
  • Understanding the Order of Events
    Working with Properties
    Using Expressions, Variables, and Intrinsic Functions
    Understanding the DoCmd Object
    Working with the Application Object
    Using the Do...Loop Structure
    Understanding the Err Object
    Writing an Error-Handling Routine
    Creating a Sub Procedure
    Understanding VBA's Error Trapping Options
    Specifying a Recordset Cursor Location - Optional
    Why Program in Access?
    Stepping through Code
    Using the If...End If Decision Structures
    Trapping Errors with the On Error Statement
    Working with Methods
    Determining the Value of Expressions
    Introduction to Programming in Access
    Using Input Boxes

  • See Training Course Details...



Email us about this courses



Other Bury Enable Technology Training Courses

Power BI - Bury Microsoft Power BI Training Courses
JavaScript - Bury JavaScript Training Courses
TSQL Bury Training Courses
Report Builder Bury Training Courses
SSAS Tabular Bury Training Courses
SSRS - Bury SQL Server Reporting Services Training Courses