Access Chaper 1

Question 1

Field

Answer 1

a host, hold or store a piece of information such as single characteristic or attribute of a person, place, object, event, or idea

Question 2

Record

Answer 2

contains all of the information about a single entity

Question 3

Table

Answer 3

contains all the raw data (records) within the database in a spreadsheet like view

Question 4

Query

Answer 4

Allows you to select a subset of fields or records from one or more tables, queries are created when you have a question about the data

Question 5

Form

Answer 5

Provides easy-to-use data entry screen

Question 6

Report

Answer 6

Provides a professional print out of data that can contain enhancements such as headers, footers, graphics, and calculations on groups of records

Question 7

Relational Database

Answer 7

a collection of related tables

Question 8

Primary Key

Answer 8

a field the uniquely identifies a record within a database

Question 9

Common Field

Answer 9

Connected records in separate tables

Question 10

Foreign Key

Answer 10

Including the primary key from one table as a field in a second table to form a relationship between the two