Deck 13: Databases

Question 1

You use forms to enter data into a table.

Answer 1

True

Question 2

All of these objects-tables, forms, queries, and reports-are stored in separate files, which together make up the database.

Answer 2

False

Question 3

Double-click the column separator to adjust the column width of any column to the widest entry in the datasheet.

Answer 3

True

Question 4

You cannot print a table from Datasheet view.

Question 5

A database developer creates and modifies databases.

Question 6

When you create a form, you are adding a new sort sequence to the database.

Question 7

Using the Form tool, you can create a form from a table formatted as a datasheet.

Question 8

The order in which you select the fields will determine the order in which the information is displayed in the query results.

Question 9

A ____ is a software program that is used to create, maintain, and provide controlled access to data.

A) DBML
B) DBMC
C) DBMS
D) DBMP

Question 10

Unlike Word, Excel, and PowerPoint, Access does not have a ____.

A) title bar
B) Ribbon
C) status bar
D) standard document view

Question 11

The ____ in the table are called records.

A) rows
B) columns
C) cells
D) borders

Question 12

A(n) ____ is a format used to display and work with various objects.

A) view
B) theme
C) window
D) instance

Question 13

____ are specifications that allow you to customize the data type settings.

A) Object settings
B) Object properties
C) Field settings
D) Field properties

Question 14

In ____ view, Access displays a row-and-column view of the data in tables, forms, and queries.

A) Datasheet
B) Normal
C) Form
D) Report

Question 15

A ____ provides options to change the data that a form or report displays without altering the form or report design.

A) parameter
B) function
C) formula
D) filter

Question 16

Please use the figure below to answer the following two questions.
FIGURE 13-1


-Referring to Figure 13-1, which of the following is the primary key?

A) Contact ID
B) First Name
C) Last Name
D) Company

Question 17

Please use the figure below to answer the following two questions.
FIGURE 13-1


-Referring to Figure 13-1, Jerry Smith's phone number, 813-555-5512, is an example of a ____.

A) Phone Number field within a record
B) Phone Number record within a field
C) either a. or b.
D) neither a. nor b.

Question 18

To sort, in ____ view, click the field name that you want sorted; the column is highlighted. Click the arrow to the right of the column name to display the shortcut menu. Select Sort A to Z or Sort Z to A.

A) Datasheet
B) Normal
C) Report
D) Form

Question 19

Using the ____ tool, you can create a form from a table formatted as a datasheet.

A) Table
B) Datasheet
C) Format
D) Form

Question 20

A ____ enables you to locate records that match specified criteria by providing a way for you to ask a question about the information stored in a database table or tables.

A) query
B) request
C) question
D) quest

Question 21

The ____ Query Wizard locates records with duplicate field values.

A) Find Matches
B) Find Duplicates
C) Find Doubles
D) Find Records

Question 22

The ____ Query Wizard locates records in one table that have no related records in another table.

A) Find Unmatched
B) Find Matched
C) Find Single
D) Find Orphan

Question 23

Although you can produce a report manually, the ____, similar to the Query Wizard, provides an easy and fast way to design and create one.

A) Report Helper
B) Report Wizard
C) Query Helper
D) Report Generator

Question 24

You can create a report based on a ____.

A) table
B) query
C) either a. or b.
D) neither a. nor b.

Question 25

You can add a record by clicking in the last field of the last record and then pressing ____ or Enter.

A) Tab
B) Ctrl
C) Ctrl+Tab
D) Shift+Tab

Question 26

Danny is the new database administrator for a small pet supply business. Please answer the questions below.

-Danny wants to create a database of all the pet food that they keep in inventory. He does NOT want to start the database from scratch. What would you recommend?

A) He use a template
B) He use a scheme
C) He use a form
D) He use a report

Question 27

Danny is the new database administrator for a small pet supply business. Please answer the questions below.

-Danny has recruited three students from a nearby high school to help him input the information about the pet food. To help make sure they enter the correct information, in the correct location, what would you recommend?

A) He use a template
B) He use a scheme
C) He use a form
D) He use a report

Question 28

JoAnn is a jewelry salesperson. She is assigning data types to various fields in her inventory database. Please answer the two questions below.

-One of the fields in the Jewelry Inventory Database asks whether or not JoAnn has the customer's e-mail address or not. A reasonable data type for this field would be ____.

A) Yes/No
B) On/Off
C) Either/Or
D) Date/Time

Question 29

JoAnn is a jewelry salesperson. She is assigning data types to various fields in her inventory database. Please answer the two questions below.

-One of the fields asks for the "Date of First Purchase." A reasonable data type for this field would be ____.

A) Memo
B) Number
C) Date/Time
D) AutoNumber

Question 30

____________________ is unorganized text, graphics, sound, or video.

Question 31

When creating a database, you can use an Access ____________________, a sample database that is contained within the Access program.

Question 32

In addition to adding and viewing records in Datasheet view, you also can create and use a data-entry ____________________, which provides a convenient way to enter and view records in a table.

Question 33

The ____________________ Query Wizard displays data in a spreadsheet format.

Question 34

The rows in a table are called fields. _________________________

Question 35

A field asks a question about the data stored in the table. _________________________

Question 36

In Report view you can create a table, form, query, and report. _________________________

Question 37

Please identify the letter of the choice that best matches the numbered definitions below.

-Unique sequential number assigned by Access for each record entered

A) Number
B) AutoNumber
C) Hyperlink
D) Memo
E) OLE object

Question 38

Please identify the letter of the choice that best matches the numbered definitions below.

-Used for more advanced features, such as storing or linking objects in a table

A) Number
B) AutoNumber
C) Hyperlink
D) Memo
E) OLE object

Question 39

Please identify the letter of the choice that best matches the numbered definitions below.

-Stores a hyperlink to an URL, other document, or other object

A) Number
B) AutoNumber
C) Hyperlink
D) Memo
E) OLE object

Question 40

Please identify the letter of the choice that best matches the numbered definitions below.

-Numeric data used in mathematical calculations

A) Number
B) AutoNumber
C) Hyperlink
D) Memo
E) OLE object

Question 41

Please identify the letter of the choice that best matches the numbered definitions below.

-Used for alphanumeric data with more than 255 characters

A) Number
B) AutoNumber
C) Hyperlink
D) Memo
E) OLE object

Question 42

Please name and describe each of the four query wizard options that Access provides.