Question 1

In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

Accepted Answer

A)  principal key 
B)  foreign key 
C)  main key 
D)  primary key

Question 2

What data type should Joe use for the Social Security Number field? Why?

Accepted Answer

The answer of What data type should Joe use for...

Question 3

To save the changes to the layout of a table, tap or click the Save button on the ____.

Accepted Answer

A)  status bar 
B)  TABLE TOOLS tab 
C)  Navigation Pane 
D)  Quick Access Toolbar

Question 4

To exit Access, tap or click the ____ button on the right side of the title bar.

Accepted Answer

A)  Quit 
B)  Stop 
C)  End 
D)  Close

Question 5

A field whose data type is ____ can store text that can be used as a hyperlink address.

Accepted Answer

A)  URL 
B)  Web 
C)  Placeholder 
D)  Hyperlink

Question 6

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 7

The DATABASE TOOLS tab provides commands to save a database with another name.

Accepted Answer

A) True 
 B)False

Question 8

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  New Name 
B)  Redefine 
C)  Rename 
D)  Save Name

Question 9

In the accompanying figure, the database name, Bavant Publishing appears on the ____________________.

Accepted Answer

The answer of  
 In the accompanying figure, the...

Question 10

When you create a database, you should follow some general guidelines for database design. What are these nine guidelines?

Accepted Answer

The answer of When you create a database, you should...

Question 11

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

Accepted Answer

The answer of To define an additional field in Datasheet...

Question 12

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

Accepted Answer

A)  Datasheet View 
B)  Open 
C)  Results View 
D)  Run

Question 13

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: View that shows a report on the screen and does not allow changes to the report.

Accepted Answer

The Answer of Metadata and Short Text and Print Preview is...

Question 15

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

Accepted Answer

A)  Reserved 
B)  Restricted 
C)  Significant 
D)  Tagged

Question 16

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

Accepted Answer

A)  Customize 
B)  Manage 
C)  Options 
D)  Grammar

Question 17

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  Open 
B)  SQL 
C)  Query Window 
D)  Design View

Question 18

Critical Thinking Questions Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. What data type should Joe use for the Completion Date field?

Accepted Answer

The answer of Critical Thinking Questions Case 1-2 Now that...

Question 19

In Datasheet view, a table is represented as a collection of rows and columns called a list.

Accepted Answer

A) True 
 B)False

Question 20

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

Accepted Answer

A) True 
 B)False

Exam 3: Databases and Database Objects: an Introduction

In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

What data type should Joe use for the Social Security Number field? Why?

To save the changes to the layout of a table, tap or click the Save button on the ____.

To exit Access, tap or click the ____ button on the right side of the title bar.

A field whose data type is ____ can store text that can be used as a hyperlink address.

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

The DATABASE TOOLS tab provides commands to save a database with another name.

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

In the accompanying figure, the database name, Bavant Publishing appears on the ____________________.

When you create a database, you should follow some general guidelines for database design. What are these nine guidelines?

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

Identify the letter of the choice that best matches the phrase or definition.

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

Critical Thinking Questions Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. What data type should Joe use for the Completion Date field?

In Datasheet view, a table is represented as a collection of rows and columns called a list.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.