Enable Technology



Microsoft Access

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • 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 ...
  • Adding Records to a Table
    Designing a Lookup Database
    Navigation Pane Protection
    Multi Table Queries
    Sorting and Filtering
    Action Queries
    Setting Table Relationships
    Macros on Forms
    Creating Queries
    Working With Records
    Relational Database Design
    Data Validation
    Calculations in Queries
    DIY Forms
    Formatting Tables
    An Introduction to VBA
    Adding Transactional Records
    Creating and Using Reports
    Parameter Queries
    Modifying Forms
    Creating a Relational Database

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • 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 ...
  • Setting Break Expressions
    Declaring and Creating Object Variables
    Using the Immediate Window to Call Procedures
    Understanding VBA's Error Trapping Options
    Determining the Value of Expressions
    Creating a Function Procedure
    Understanding Classes and Objects
    Using the CacheSize Property - Optional
    Understanding Errors
    Locking Records for Updating
    Using Input Boxes
    Understanding the Err Object
    Working with Methods
    Creating a Sub Procedure
    Understanding Control-of-Flow Structures

  • See Training Course Details...

Email us about this courses

Other Uk Enable Technology Training Courses

SSAS 2008 Uk Training Courses
Excel Power Pivot Uk Training Courses
Power Graphics - Uk Data Analytics Training Courses
JQuery Mobile - Uk JavaScript Training Courses
HTML Uk Training Courses
HTML Uk Training Courses