Access (Intermediate)


North East Scotland College

Course details

Course description

Learn how to create and manipulate an Access database.

Microsoft Access Distance Learning units have been specifically designed to provide you with the knowledge and techniques needed for the successful creation and manipulation of an Access Database. The accompanying data files provided are designed to help demonstrate the features as you work through the unit step-by-step.

What you will experience

This course covers the following topics:

  • Replacing, Cutting & Copying Text
  • Calculating Fields
  • Relationships
  • Lookup Fields
  • Default Values
  • Validation Rules
  • Sub-forms & Linking Forms
  • Combo & List Boxes
  • Tab Control
  • Label & Chart Wizard
  • Importing & Exporting Data
  • Advanced Queries
  • Database Objects
  • Assessment for this course comprises of an end of course test to test your knowledge.

    What you will need

    You will require access to/use of the Microsoft Office Access Package.

    Learning outcome

    Progression:

    Whether you wish to progress in your studies or enter the world of work, North East Scotland College has excellent progression opportunities, with links to eight universities across Scotland and great relationships with industry employers.

    Education at NESCol:

    On successful completion of this course, you can progress to the following course at North East Scotland College:

    Provided by

    North East Scotland College

    enquiry@nescol.ac.uk

    0300 330 5550

    Provider website

    Gallowgate

    Aberdeen

    AB25 1BN

    Entry requirements

    There are no formal entry requirements for this course.

    Course options

    Course details

    Online

    Check with the course provider for dates.

    Cost: Visit the provider's website for details.

    Venue details

    Gallowgate

    Aberdeen

    AB25 1BN

    This is the main contact address for the provider. This may not be the location where this course is presented.