Access

Question 1

Allows you to select a subject of fields or records from one or more tables queries

Answer 1

Query

Question 2

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

Answer 2

Table

Question 3

is a field that uniquely identifies a record within a database.

Answer 3

primary key

Question 4

can consist of up to 64 characters including letters, numbers except for the period.

Answer 4

Field Name

Question 5

Provides an easy-to- use data entry screen.

Answer 5

Form

Question 6

Records in the separate tables are connected though a common field

Answer 6

Common Field

Question 7

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

Answer 7

Field

Question 8

Contains all of the information about a single entity

Answer 8

Record

Question 9

is a collection of related tables.

Answer 9

Relational data base

Question 10

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

Answer 10

foreign Key

Question 11

a professional printout of data that can contain enhancements such as headers,footers,and calculation on groups of records.

Answer 11

Report

Question 12

used to search for any number of characters

Answer 12

Asterisk *

Question 13

Used to search for a single character

Answer 13

Question mark ?

Question 14

is a equation that uses more than one type of arithmetic operator.

Answer 14

complex formula

Question 15

is predefined worksheet formula that makes it easy to perform a complex calculation

Answer 15

function

Question 16

temporarily stores information that you copy or cut

Answer 16

clipboard

Question 17

when you want to preserve the relationship to the formula location

Answer 17

relative cell reference

Question 18

when u want to preserve the exact cell address in a formula

Answer 18

absolute cell reference

Question 19

combines both relative and absolute cell referencing

Answer 19

mixed reference

Question 20

any one criterion must be true for the record to be selected

Answer 20

OR criteria