Access Project 1 Ashton James College

Concepts:

• database - a collecton of data organized to allow ease of entry, storage, access, manipulation, and update.
  • Table
    • record = rows
    • field = column
    • unique identifier or primary key
    • field name - unique name for each field
    • data type
    • field properties
      • field size
    • datasheet view
    • design view
• DBMS - Database Management System - a software tool like access
  • Query
    • criterion
  • Form - Form View - an alternative way to see and enter data
  • Reports
  • Using the Help
  • Database design
    • accuracy
    • integrity
    • redundancy