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

Question 2

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 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Field can contain only monetary data.

Accepted Answer

Currency fields are specifically designed to contain monetary data, which matches the description given.

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

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-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

Long Text (formerly known as Memo in some database systems) is the data type specifically designed to store a variable amount of text or combinations of text and numbers, where the total number of characters may exceed 255. This makes it suitable for storing large amounts of text such as comments, descriptions, or any form of unstructured text data.

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Field can store a unique sequential number that Access assigns to the record.

Accepted Answer

AutoNumber is a data type in Microsoft Access that automatically generates a unique number for each record as it is added to a table, which matches the description given.

Question 7

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

Accepted Answer

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

Question 8

The Short Text data type replaces the ____________________ data type in previous editions of Access.

Accepted Answer

The answer of The Short Text data type replaces the...

Question 9

The determination of database requirements is part of a process known as ____________________.

Accepted Answer

The answer of The determination of database requirements is part...

Question 10

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 11

____________________ 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 12

-In the accompanying figure,____________________ for the open objects appear at the top of the work area.

Accepted Answer

The answer of 
-In the accompanying figure,____________________ for the open...

Question 13

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 14

-In the accompanying figure,the buttons at the bottom-right edge of the screen are ____________________ buttons,which you use to change the view that is currently displayed.

Accepted Answer

The answer of 
-In the accompanying figure,the buttons at the...

Question 15

-In the accompanying figure,the entire area that displays on the screen is called the ____________________ work area.

Accepted Answer

The answer of 
-In the accompanying figure,the entire area that...

Question 16

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

Accepted Answer

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

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Field can contain any characters and the total numbers of characters cannot exceed 255.

Accepted Answer

Short Text fields in databases are designed to store alphanumeric data, including letters and numbers, and are typically limited in length, making them suitable for data that does not exceed 255 characters, such as names, addresses, or small descriptions.

Question 18

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

Accepted Answer

The answer of 
-In the accompanying figure,the database name,Bavant Publishing...

Question 19

-In the accompanying figure,the words Datasheet View at the lower left of the screen appear on the ____________________.

Accepted Answer

The answer of 
-In the accompanying figure,the words Datasheet View...

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.

Accepted Answer

The status bar in a software application, including database systems, is designed to display information about the current state of the program, the progress of ongoing tasks, and the status of certain commands and keys, matching the description provided.

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