Question 1

Use the ____ data type for fields that contain variable length data, such as comments, notes, and reviews.

Accepted Answer

A) Text 
B) Memo 
C) Number 
D) Date & Time 
A) Text 
B) Memo 
C) Number 
D) Date & Time

Question 2

When Access creates a new database, it creates an empty table called ____ for you to modify.

Accepted Answer

A) Table1 
B) Database1 
C) Datasheet1 
D) Form1 
A) Table1 
B) Database1 
C) Datasheet1 
D) Form1

Question 3

A(n) ____________________ is a field that uniquely identifies each record.

Accepted Answer

The answer of A(n) ____________________ is a field that uniquely...

Question 4

Case 17-1
Sam is working in an Access table listing all of the hockey equipment that he has for sale on eBay. Please answer the questions below.
-Sam receives an e-mail from Sara Harmon asking for her money back.To easily find the details of her order, Sam sorts the records alphabetically by ____ the column that holds the data for the last name.

Accepted Answer

A) right-clicking 
B) left-clicking 
C) double-clicking 
D) highlighting 
A) right-clicking 
B) left-clicking 
C) double-clicking 
D) highlighting

Question 5

New records are always added at the end of the database.

Accepted Answer

A) True 
 B)False

Question 6

To further refine a search, you can specify query ____.

Accepted Answer

A) parameters 
B) tools 
C) criteria 
D) facts 
A) parameters 
B) tools 
C) criteria 
D) facts

Question 7

All tables in a database are stored in the same database file.

Accepted Answer

A) True 
 B)False

Question 8

Case 17-1
Sam is working in an Access table listing all of the hockey equipment that he has for sale on eBay. Please answer the questions below.
-Sam finds himself referring to the SKU column of the table often and decides to move that field to the left.To move the column, Sam selects the column that he wants to move, and ____.

Accepted Answer

A) selects Move Column on the Home tab and enters in the new column coordinates 
B) selects Move Column on the Datasheet tab and enters in the new column coordinates 
C) drags it vertically to the desired location 
D) drags it horizontally to the desired location 
A) selects Move Column on the Home tab and enters in the new column coordinates 
B) selects Move Column on the Datasheet tab and enters in the new column coordinates 
C) drags it vertically to the desired location 
D) drags it horizontally to the desired location

Question 9

To add query criteria, right-click the query tab at the top of the window, then click ____ View on the shortcut menu.

Accepted Answer

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

Question 10

The databases you create with Access are technically referred to as "record databases." _________________________

Accepted Answer

A) True 
 B)False

Question 11

When you start Access, the File tab appears.You can use this tab to connect to Microsoft Office Online.

Accepted Answer

A) True 
 B)False

Question 12

The elements that make up an Access database include all of the following EXCEPT ____.

Accepted Answer

A) reports 
B) forms 
C) charts 
D) queries 
A) reports 
B) forms 
C) charts 
D) queries

Question 13

Use the ____ data type for fields that contain words and symbols of up to 255 characters in length.

Accepted Answer

A) Text 
B) Memo 
C) Number 
D) Date & Time 
A) Text 
B) Memo 
C) Number 
D) Date & Time

Question 14

The data type for telephone numbers should be defined as Text._________________________

Accepted Answer

A) True 
 B)False

Question 15

To add query criteria, right-click the query tab at the top of the window, then click Datasheet View on the shortcut menu._________________________

Accepted Answer

A) True 
 B)False

Question 16

-Referring to the figure above, in a database containing information about movies, the name of the movie's director would be a(n) ____ in an Access table.

Accepted Answer

A) field 
B) record 
C) query 
D) index 
A) field 
B) record 
C) query 
D) index

Question 17

To search, right-click the title of the column that is likely to hold the data you seek.Select Find from the shortcut menu.Enter the data you seek in the ____ dialog box.Click the Find Next button.

Accepted Answer

A) Find 
B) Replace 
C) Find and Replace 
D) Fields 
A) Find 
B) Replace 
C) Find and Replace 
D) Fields

Question 18

-Referring to the figure above, in a database containing information about movies, the name of the actual movie would identify a(n) ____ in an Access table.

Accepted Answer

A) field 
B) record 
C) query 
D) index 
A) field 
B) record 
C) query 
D) index

Question 19

Each record consists of one or more tables._________________________

Accepted Answer

A) True 
 B)False

Question 20

After a query is saved, you can run it repeatedly to display ____ that match the criteria you've specified.

Accepted Answer

A) all the records 
B) new data 
C) updated data 
D) all of the above 
A) all the records 
B) new data 
C) updated data 
D) all of the above

Use the ____ data type for fields that contain variable length data, such as comments, notes, and reviews.

When Access creates a new database, it creates an empty table called ____ for you to modify.

A(n) ____________________ is a field that uniquely identifies each record.

New records are always added at the end of the database.

To further refine a search, you can specify query ____.

All tables in a database are stored in the same database file.

To add query criteria, right-click the query tab at the top of the window, then click ____ View on the shortcut menu.

The databases you create with Access are technically referred to as "record databases." _________________________

When you start Access, the File tab appears.You can use this tab to connect to Microsoft Office Online.

The elements that make up an Access database include all of the following EXCEPT ____.

Use the ____ data type for fields that contain words and symbols of up to 255 characters in length.

The data type for telephone numbers should be defined as Text._________________________

To add query criteria, right-click the query tab at the top of the window, then click Datasheet View on the shortcut menu._________________________

-Referring to the figure above, in a database containing information about movies, the name of the movie's director would be a(n) ____ in an Access table.

To search, right-click the title of the column that is likely to hold the data you seek.Select Find from the shortcut menu.Enter the data you seek in the ____ dialog box.Click the Find Next button.

-Referring to the figure above, in a database containing information about movies, the name of the actual movie would identify a(n) ____ in an Access table.

Each record consists of one or more tables._________________________

After a query is saved, you can run it repeatedly to display ____ that match the criteria you've specified.

Computer Hardware

Peripheral Devices

System and Application Software

Installing Software

Getting Started With Windows 7

Working With Windows Settings and Accounts

Working With Files

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Creating a Worksheet

Formatting a Worksheet

Finalizing a Worksheet

Creating a Presentation

Finalizing a Presentation

Finalizing a Database

Networks

Working With E-Mail

Browsing the Web

Computer Benefits and Risks

Filters

Exam 17: Creating a Database

Use the ____ data type for fields that contain variable length data, such as comments, notes, and reviews.

When Access creates a new database, it creates an empty table called ____ for you to modify.

A(n) ____________________ is a field that uniquely identifies each record.

New records are always added at the end of the database.

To further refine a search, you can specify query ____.

All tables in a database are stored in the same database file.

To add query criteria, right-click the query tab at the top of the window, then click ____ View on the shortcut menu.

The databases you create with Access are technically referred to as "record databases." _________________________

When you start Access, the File tab appears.You can use this tab to connect to Microsoft Office Online.

The elements that make up an Access database include all of the following EXCEPT ____.

Use the ____ data type for fields that contain words and symbols of up to 255 characters in length.

The data type for telephone numbers should be defined as Text._________________________

To add query criteria, right-click the query tab at the top of the window, then click Datasheet View on the shortcut menu._________________________

-Referring to the figure above, in a database containing information about movies, the name of the movie's director would be a(n) ____ in an Access table.

To search, right-click the title of the column that is likely to hold the data you seek.Select Find from the shortcut menu.Enter the data you seek in the ____ dialog box.Click the Find Next button.

-Referring to the figure above, in a database containing information about movies, the name of the actual movie would identify a(n) ____ in an Access table.

Each record consists of one or more tables._________________________

After a query is saved, you can run it repeatedly to display ____ that match the criteria you've specified.

Computer Hardware

Peripheral Devices

System and Application Software

Installing Software

Getting Started With Windows 7

Working With Windows Settings and Accounts

Working With Files

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Creating a Worksheet

Formatting a Worksheet

Finalizing a Worksheet

Creating a Presentation

Finalizing a Presentation

Finalizing a Database

Networks

Working With E-Mail

Browsing the Web

Computer Benefits and Risks

Filters