Question 1

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

This is correct as each customer can only have one book rep assigned to them, but each book rep can have multiple customers. This relationship is known as a one-to-many relationship.

Question 2

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

Accepted Answer

The DATABASE TOOLS tab in Microsoft Access is primarily used for database management tasks such as running queries, linking tables, and managing relationships, not for saving a database with another name. To save a database with another name, you would use the "Save As" feature found under the File tab.

Question 3

To delete a field,press and hold or right-click the column heading for the field,and then tap or click Remove Field on the shortcut menu.____________________

Accepted Answer

Delete

Question 4

The term list database describes a database that consists of a collection of tables,each of which contains information on a specific subject.____________________

Accepted Answer

relational

Question 5

A(n)____________________ is software that can be used to create a database;add,change,and delete data in the database;ask and answer questions concerning the data in the database;and create forms and reports using the data.

Accepted Answer

The answer of A(n)____________________ is software that can be used...

Question 6

A unique identifier also is called a(n)____________________.

Accepted Answer

The answer of A unique identifier also is called a(n)____________________....

Question 7

The rows in the tables are called ____________________.

Accepted Answer

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

Question 8

Landscape orientation means the printout is across the length (height)of the page.

Accepted Answer

Landscape orientation means the printout is across the width (length) of the page, not the height.

Question 9

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

Accepted Answer

The layout view does show the report on the screen and allows the user to make changes to it.

Question 10

Changing the column width in a datasheet changes the structure of a table.

Accepted Answer

Changing the column width in a datasheet view affects only the display or how the data is viewed, not the underlying structure or schema of the table.

Question 11

To preview and then print the contents of a table,use Table Preview.

Accepted Answer

To preview and then print the contents of a table, you typically use "Print Preview" or a similar feature depending on the software, not "Table Preview."

Question 12

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 Insert Column on the shortcut menu.____________________

Accepted Answer

Field

Question 13

To print a wide database table,a table whose contents do not fit on the screen,you will need portrait orientation.

Accepted Answer

To print a wide database table, you will need landscape orientation, which allows more horizontal space for the table's contents. Portrait orientation would limit the width of the table and make it difficult to read.

Question 14

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

Accepted Answer

Redundancy is the practice of storing the same information in multiple locations to ensure reliability and consistency of the information.

Question 15

Form view displays a single record at a time.

Accepted Answer

Form view is used to display a single record at a time, typically for editing or adding new data. It is distinct from datasheet view or continuous form view, which display multiple records at once.

Question 16

-In the accompanying figure,the ____________________ Pane contains a list of all the objects in the database.

Accepted Answer

The answer of 
-In the accompanying figure,the ____________________ Pane contains...

Question 17

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record.____________________

Accepted Answer

AutoNumber

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

This statement is true. To change the name of a field, one needs to press and hold or right-click the column heading for the field and then tap or click Rename Field on the shortcut menu.

Quiz 15: Access: Databases and Database Objects: an Introduction