Enable Technology

ACCESS ABERYSTWYTH TRAINING COURSES 

ACCESS TRAINING COURSES ABERYSTWYTH




About Enable Technology Aberystwyth 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 will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another way we could deliver the Access course is at a local training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Boots UK Limited, Fujistu PLC, Royal Air Force, Shell UK Oil Products Ltd, National Power PLC, Loughborough University, Countrywide Homes Limited and Norfolk Police Constabulary.




Microsoft Access

  • 2 day course
  • Location: Aberystwyth
  • 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 ...
  • Calculations in Queries
    Creating a Lookup Database
    Database Wellness
    Adding Records to a Table
    Designing a Lookup Database
    Modifying Table Structures
    Understanding VBA
    Macros on Forms
    Multi Table Queries
    Creating a Relational Database
    Using a Navigation Form
    Getting to Know Access 
    Relational Database Design
    Sorting and Filtering
    Navigation Pane Protection
    Database Security
    Formatting Tables
    Adding Transactional Records
    Setting Table Relationships
    Modifying Forms
    Querying Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Aberystwyth
  • 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 ...
  • Working with Boolean Expressions
    Understanding Objects
    Working with the Application Object
    Understanding the Form Object
    Considering Variable Scope and Lifetime Together
    Working with Methods
    Understanding Constants
    Understanding the DoCmd Object
    Understanding the Order of Events
    Working with the ADODB Recordset Object
    Using Intrinsic Functions
    Calling Procedures
    Specifying a Recordset Cursor Location - Optional
    Declaring Variables
    Working with Variable Scope
    Controlling Program Execution
    Understanding VBA's Error Trapping Options
    Setting Breakpoints
    Using the Do...Loop Structure
    Setting Break Expressions
    Using the Object Browser

  • See Training Course Details...



Email us about this courses



Other Aberystwyth Enable Technology Training Courses

Report Builder Aberystwyth Training Courses
VBA Aberystwyth Training Courses
SQL Aberystwyth Training Courses
SSAS Tabular Aberystwyth Training Courses
TSQL Aberystwyth Training Courses
Excel 365 Basic Aberystwyth Training Courses