Question 1

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____________________ on the shortcut menu.

Accepted Answer

The answer of To insert a field between existing fields,...

Question 2

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 Joe has...

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 been asked...

Question 4

A hard copy or ____________________ is information that exists on a physical medium such as paper.

Accepted Answer

The answer of A hard copy or ____________________ is information...

Question 5

A(n) ____________________ contains a specific piece of information within a record.

Accepted Answer

The answer of A(n) ____________________ contains a specific piece of...

Question 6

Designing to omit ____________________ will help to produce good and valid database designs.

Accepted Answer

The answer of Designing to omit ____________________ will help to...

Question 7

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 8

The ____________________ data type in Access is referred to as Money in SQL Server.

Accepted Answer

The answer of The ____________________ data type in Access is...

Question 9

The rows in the tables are called ____________________.

Accepted Answer

The answer of The rows in the tables are called...

Question 10

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 Social Security Number field? Why?

Accepted Answer

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

Question 11

Society encourages users to contribute to ____________________ computing, which involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

Accepted Answer

The answer of Society encourages users to contribute to ____________________...

Question 12

____________________ refers to the process of determining the tables and fields that make up the database.

Accepted Answer

The answer of ____________________ refers to the process of determining...

Question 13

____________________ view has more functionality for creating a table than Datasheet view.

Accepted Answer

The answer of ____________________ view has more functionality for creating...

Question 14

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 Project table should be the primary key and why?

Accepted Answer