Question 1

Identify the letter of the choice that best matches the phrase or definition.
-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 2

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

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 4

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

Accepted Answer

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

Question 5

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

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

Identify the letter of the choice that best matches the phrase or definition.
-Field can contain only monetary data.

Accepted Answer

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

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

Identify the letter of the choice that best matches the phrase or definition.
-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 10

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 11

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

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 13

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

Accepted Answer

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

Question 14

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

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

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 17

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 18

Identify the letter of the choice that best matches the phrase or definition.
-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 19

Identify the letter of the choice that best matches the phrase or definition.
-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.

Question 20

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

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

Identify the letter of the choice that best matches the phrase or definition. -Field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.