skillstopaythebills

MS Access 2010 - Level 1

Course Length: 8 Hours (Three sessions)

Description: This course is designed for beginners to Microsoft Access.

The course starts with an overview of database theory, and covers the process used to design and create Access tables to store data. It also covers creating simple input forms, reports, filters and queries.

Please note that this course is most effective if students can practice on their own computer between classes.

Prerequisites: Prospective students should be very familiar with Microsoft Word and/or Microsoft Excel.

Next Start Date: September 2013

Registration Deadline:  tba

Tuition: $184.00 (tax not included)

Manual: $70.00 (Required - tax not included)

Topics:

  • Database Structure & Terms
  • Create Tables
  • Primary Keys
  • Table Navigation
  • Enter and Edit Table Data
  • Import and Export Table Data
  • Sorting
  • Filtering
  • Create, Modify and Run Queries
  • Calculated Fields
  • Relationships
  • Referential Integrity
  • Cascade Update / Delete
  • Modify Properties

Login Form