Question 1

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu.

Accepted Answer

A) True 
 B)False

Question 2

In the accompanying figure, the small box or bar to the left of each field is called the ____.

Accepted Answer

A)  row selector 
B)  field selector 
C)  field bar 
D)  current field bar

Question 3

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

Accepted Answer

A)  Memo 
B)  Long Text 
C)  Variable 
D)  Character

Question 4

In Access, field names cannot contain digits.

Accepted Answer

A) True 
 B)False

Question 5

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.

Accepted Answer

A)  CREATE 
B)  INSERT 
C)  NEW OBJECT 
D)  REPORT

Question 6

Redundancy means storing the same fact in more than one place.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Question 10

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

Accepted Answer

A) True 
 B)False

Question 11

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

Accepted Answer

A)  Change Column 
B)  Rename Column 
C)  Change Field 
D)  Rename Field

Question 12

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 13

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

Accepted Answer

A)  Restore 
B)  Fix 
C)  Compaction 
D)  Compact & Repair

Question 14

To import data to a table, tap or click the ____ tab on the ribbon.

Accepted Answer

A)  DATABASE TOOLS 
B)  FILE 
C)  EXTERNAL DATA 
D)  IMPORT

Question 15

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

Accepted Answer

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

Question 16

To define an additional field in Datasheet view, tap or click the ____ column heading.

Accepted Answer

A)  New Field 
B)  Add Field 
C)  Click to Add 
D)  Insert Field

Question 17

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 18

The Navigation Pane contains a list of all the objects in the database.

Accepted Answer

A) True 
 B)False

Question 19

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

Accepted Answer

A) True 
 B)False

Question 20

Layout view shows a report on the screen and allows the user to make changes to the report.

Accepted Answer

A) True 
 B)False

Exam 3: Databases and Database Objects: an Introduction

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu.

In the accompanying figure, the small box or bar to the left of each field is called the ____.

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

In Access, field names cannot contain digits.

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.

Redundancy means storing the same fact in more than one place.

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

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

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?

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

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

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

To import data to a table, tap or click the ____ tab on the ribbon.

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

To define an additional field in Datasheet view, tap or click the ____ column heading.

The Navigation Pane contains a list of all the objects in the database.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

Layout view shows a report on the screen and allows the user to make changes to the report.