Question 1

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

Accepted Answer

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

Question 2

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.

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

- Simple Query Wizard: creates a select

Question 5

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

Accepted Answer

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

Question 6

Please identify the letter of the choice that best matches the numbered definitions below.
-Unique sequential number assigned by Access for each record entered

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 ____.

Accepted Answer

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

Question 9

You can create a report based on a ____.

Accepted Answer

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

Question 10

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 ____.

Accepted Answer

A)  Phone Number field within a record 
B)  Phone Number record within a field 
C)  either a. or b. 
D)  neither a. nor b. 
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 11

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

Accepted Answer

The answer of When creating a database, you can use...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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?

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

You use forms to enter data into a table.

Accepted Answer

A) True 
 B)False

Question 17

The ____ in the table are called records.

Accepted Answer

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

Question 18

The ____ Query Wizard locates records with duplicate field values.

Accepted Answer

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

Question 19

A database developer creates and modifies databases.

Accepted Answer

A) True 
 B)False

Question 20

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?

Accepted Answer

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

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

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.

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

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

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

Please identify the letter of the choice that best matches the numbered definitions below. -Unique sequential number assigned by Access for each record entered

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

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 ____.

You can create a report based on a ____.

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 ____.

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

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

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 field asks a question about the data stored in the table. _________________________

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

You use forms to enter data into a table.

The ____ in the table are called records.

The ____ Query Wizard locates records with duplicate field values.

A database developer creates and modifies databases.

Understanding Computers and Computer Literacy

The Internet and the World Wide Web

The Internet and Research

How a Computer Processes Data

Input, Output, and Storage

Operating Systems and Software

Networks Unit

Windows and File Management

Email and Electronic Communication

Word Processing

Presentation Graphics

Spreadsheets

Integration Feature Unit

Evaluating Electronic Information

Creating a Web Page

Technology, the Workplace, and Society

Filters

Exam 13: Databases

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

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.

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

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

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

Please identify the letter of the choice that best matches the numbered definitions below. -Unique sequential number assigned by Access for each record entered

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

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 ____.

You can create a report based on a ____.

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 ____.

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

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

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 field asks a question about the data stored in the table. _________________________

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

You use forms to enter data into a table.

The ____ in the table are called records.

The ____ Query Wizard locates records with duplicate field values.

A database developer creates and modifies databases.

Understanding Computers and Computer Literacy

The Internet and the World Wide Web

The Internet and Research

How a Computer Processes Data

Input, Output, and Storage

Operating Systems and Software

Networks Unit

Windows and File Management

Email and Electronic Communication

Word Processing

Presentation Graphics

Spreadsheets

Integration Feature Unit

Evaluating Electronic Information

Creating a Web Page

Technology, the Workplace, and Society

Filters