Enable Technology

ACCESS NEWCASTLE UPON TYNE TRAINING COURSES 

ACCESS TRAINING COURSES NEWCASTLE UPON TYNE




About Enable Technology Newcastle Upon Tyne Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Enable Technology training courses are delivered as instructor led courses. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Another way we could deliver the Access course is at a local training site. Every Access course can be modified to meet your bespoke requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: University of Birmingham, Nationwide Building Society Limited, Lloyds TSB Bank PLC, Aston University, Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, Loughborough University and DHL Express.




Microsoft Access

  • 2 day course
  • Location: Newcastle Upon Tyne
  • 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 ...
  • Importing and Exporting Records
    Using a Navigation Form
    Relational Database Design
    Adding Transactional Records
    Creating and Using Macros
    Querying Techniques
    Macro Techniques
    Creating and Using Reports
    Adding Records to a Table
    Modifying Table Structures
    Working With Records
    DIY Forms
    Action Queries
    An Introduction to VBA
    Creating and Using Forms
    Multi Table Queries
    Sorting and Filtering
    Designing a Lookup Database
    Parameter Queries
    Database Wellness
    Understanding VBA

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Newcastle Upon Tyne
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Understanding Constants
    Using the With Statement
    Trapping Errors with the On Error Statement
    Working with the ADODB Recordset Object
    Using the Select Case...End Select Structure
    Using the Object Browser
    Working with Events
    Declaring and Creating Object Variables
    Working with the Code Editor
    Debugging Code
    Organizing Code and Procedures
    Creating a Sub Procedure
    Working with the Application Object
    Controlling Program Execution
    Understanding Classes and Objects
    Working with Boolean Expressions
    Understanding Modules
    Using Intrinsic Constants
    Understanding Procedures
    Using Input Boxes

  • See Training Course Details...



Email us about this courses



Other Newcastle Upon Tyne Enable Technology Training Courses

Oracle SQL - Newcastle Upon Tyne SQL Training Courses
DAX - Newcastle Upon Tyne Excel Training Courses
Excel 365 Intermediate - Newcastle Upon Tyne Excel Training Courses
JavaScript Newcastle Upon Tyne Training Courses
Excel 365 Advanced Newcastle Upon Tyne Training Courses
Report Builder Newcastle Upon Tyne Training Courses