Microsoft Access

Help Center Microsoft Access

A Few Terms

These words are used often in Access so you should familiarize yourself with them before using the program and this tutorial.

  • A database is a collection of related information.
  • A table is the organization of data in to fields and records. The relationships between data can be determined by tables using the same fields. Multiple tables can be saved in the same database.
  • A field defines the type of data for the values in a table. A table for an address book might include fields for first name, last name, address and telephone number.
  • A record is a set of values defined by fields. For an address book table, each record would contain the data for one person as specified by the associated fields.