Office Jeopardy - Access Edition

1
Beyond the Basics
Tables and Forms
Table Properties
Access 101
Queries
2
One set of all of the fields in a table

• What is a record?

3
The field that makes a record unique

• What is a primary key?

4
A set of records organized into fields

• What is a table?

5
The view of a table in which you add, edit, and
delete records

• What is the Datasheet View?

6
Provides a friendlier interface through which to
add, edit, and delete records

• What is a Form?

7
Every database must have at least one of these
objects.

• What is a table?

8
Recommended field data type for phone numbers and
zip codes when defining the fields for your table

• What is a Text field?

9
Field type whose value is created automatically
for each record

• What is an AutoNumber field?

10
List three types of database objects.

• What are Tables, Queries, Forms, Reports, Pages,
  Macros, or Modules?

11
The term for the data entered into a field.

• What is data value or entry?

12
Appears at the bottom of the very last page when
printing a query report.

• What is a page footer?

13
T or False A query automatically displays all
fields from a table.

• What is False?

14
Which view displays the results of a query

• What is query datasheet view?

15
The language that all databases speak and which
Access translates your data.

• What is SQL?

16
The 3 pieces of information you must supply when
making a query.

• What is the fields you want to search for, what
  you are searching for (the search criteria), and
  what fields you want to display with the results?

17
What every table must have in a database.

• What is a Primary Key?

18
Requires that tables in a database be consistent
with one another, and is the box you check when
you are creating a relationship between 2 tables.

• What is Referential Integrity?

19
When a Primary Key appears in another table it is
called a ...

• What is Foreign Key?

20
When a database has tables that reference each
other the database is called a
____________________.

• What is Referential Database?

21
The two views of a table.

• What is Datasheet View and Design View?

22
Access stores all of your objects in one big file
with the file extension of...

• What is .mdb?

23
A header for a column in a database is a
_____________

• What is a field?

24
This data value provides a drop-down menu for the
user so that when they are entering data they can
choose from a list.

• What is the Look-up Wizard?

25
When creating a table in design view you can
enter a description for a field, the description
does this in datasheet view.

• What is give the user info at the bottom of the
  screen, describing what data should go into the
  field currently selected.?

26
When you use an Autonumber as the primary key for
one table and then relate a second table using
this primary key as a foreign key, the foreign
key in the second table must be this data type.

• What is Number?