Question 1

Match between columns
                        Premises: Field can store a unique sequential number that Access assigns to the record.

Accepted Answer

The Answer of Layout view and status bar and Print is...

Question 2

Discuss the difference between the way Access saves a record and the way Excel saves a row in a worksheet.

Accepted Answer

The answer of Discuss the difference between the way Access...

Question 3

Critical Thinking Questions Case 1-1 Joe has been asked to create a Special Projects database for his company. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal Code, Hourly Pay Rate, Project Code) Project (Project Code, Project Name, Total Hours, Completion Date) Which field in the Employee table should be the primary key and why?

Accepted Answer

The answer of Critical Thinking Questions Case 1-1 Joe has...

Question 4

Match between columns
                        Premises: Field can contain only monetary data.

Accepted Answer

The Answer of Short Text and Report view and Long is...

Question 5

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 6

Match between columns
                        Premises: Field can contain any characters and the total numbers of characters cannot exceed 255.

Accepted Answer

The Answer of status bar and Layout view and Currency is...

Question 7

Which field in the Project table should be the primary key and why?

Accepted Answer

The answer of Which field in the Project table should...

Question 8

Match between columns
                        Premises: Presents information about the database object, the progress of current tasks, and the status of certain commands and keys.

Accepted Answer

The Answer of Print Preview and status bar and Short is...

Question 9

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 10

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 11

Match between columns
                        Premises: Field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

Accepted Answer

The Answer of DBDL and Layout view and Metadata and is...

Question 12

In the accompanying figure, book rep names appear more than once in the table. Storing this data on multiple records is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?

Accepted Answer

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

Quiz 3: Databases and Database Objects: an Introduction

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

Discuss the difference between the way Access saves a record and the way Excel saves a row in a worksheet.

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

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

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

Which field in the Project table should be the primary key and why?

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

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?

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

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

In the accompanying figure, book rep names appear more than once in the table. Storing this data on multiple records is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?