Deck 11: Using Databases

Question 1

The results of multiplying the Hours field times the Rate field would be stored in a(n) ________ field.

Answer 1

calculated

Question 2

A(n) ________ is a collection of related data that can be stored, organized, and queried.

Answer 2

database

Question 3

________ fields hold things such as pictures and video clips.

Answer 3

OLE Object

Question 4

A group of related fields is called a ________.

A) record
B) table
C) query
D) hyperlink

Question 5

In a table, if you need to store the extended price (number of units sold times the price per unit) of an order, you would store the data in a ________ field.

A) text
B) calculated
C) media
D) hyperlink

Question 6

To ensure that there are no duplicate records in a database table, you need to establish a ________.

A) query
B) primary key
C) relationship
D) foreign key

Question 7

The information about a single student would be stored in a ________.

A) record
B) field
C) list
D) table

Question 8

Match each of the following terms to its definition:
I. field
II. relationship
III. record
IV. table
V. primary key
A. a group of related fields
B. a category of information in a database
C. a link between tables that defines how the data is connected
D. a field that has a value unique to each record
E. a group of related records

Question 9

Which of the following is NOT a database component?

A) Field
B) List
C) Record
D) Table

Question 10

A category of information about students, such as their phone numbers, would be stored in a(n) ________.

Question 11

A(n) ________ database stores data in more than two dimensions.

Question 12

Most small businesses use ________ databases as they are reliable and less costly.

A) object oriented
B) relational
C) multidimensional
D) hierarchical

Question 13

A group of related records is called a(n) ________.

Question 14

What is the Access object that organizes data into fields and records?

A) Query
B) Form
C) Table
D) Report

Question 15

In a database, a text field capable of holding complete paragraphs has a ________ data type.

A) long text
B) document
C) paragraph
D) hypertext

Question 16

In terms of databases, a table is also referred to as a(n) ________.

Question 17

To combine data from more than one table, you need to create a(n) ________ between the tables.

Question 18

To establish a relationship between two tables, the primary key in one table is associated with the ________ in the other table.