Enable Technology

ACCESS WINSFORD TRAINING COURSES 

ACCESS TRAINING COURSES WINSFORD




About Enable Technology Winsford Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the Access course at a socially distanced local training venue in Winsford. We are happy to discuss customising the course content should you have particular Access 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.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Nuclear Engineering Services, Unipart Group, Loughborough University, Countrywide Homes Limited, Queen's Medical Centre Nottingham, Total Telecommunications Limited, Birmingham Heartlands Hospital and Norfolk Police Constabulary.




Microsoft Access

  • 2 day course
  • Location: Winsford
  • Telephone on 01952 938014
  • 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 ...
  • Relational Database Design
    Creating and Using Reports
    DIY Forms
    Adding Records to a Table
    Macros on Forms
    Modifying Forms
    Multi Table Queries
    Modifying Table Structures
    Database Security
    Creating a Lookup Database
    Getting to Know Access 
    Data Validation
    Designing a Lookup Database
    Action Queries
    Creating a Relational Database
    Setting Table Relationships
    Importing and Exporting Records
    Adding Transactional Records
    Creating and Using Macros
    Working With Records
    Using a Navigation Form

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Winsford
  • 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 Expressions, Variables, and Intrinsic Functions
    Using Intrinsic Constants
    Working with Inline Error Handling
    Using the If...End If Decision Structures
    Locking Records for Updating
    Using the For Each...Next Structure
    Understanding the Err Object
    Writing an Error-Handling Routine
    Debugging Code
    Using Visual Basic Help
    Understanding Classes and Objects
    Understanding the Form Object
    Understanding Expressions and Statements
    Organizing Code and Procedures
    Specifying a Recordset Cursor Location - Optional
    Using the Do...Loop Structure
    Creating a Function Procedure
    Understanding Recordset Cursor Properties - Optional
    Introduction to Programming in Access
    Setting Break Expressions

  • See Training Course Details...



Email us about this courses



Other Winsford Enable Technology Training Courses

Excel 365 Intermediate - Winsford Excel Training Courses
SSAS Winsford Training Courses
VBA - Winsford Excel Training Courses
Power Query Winsford Training Courses
TSQL - Winsford SQL Training Courses
Excel Power Pivot Winsford Training Courses