Question 1

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2017 as: ____.
A) 09/06/2017
B) 9/6/2017
C) 9/6/17
D) 09/06/17

Accepted Answer

The mm/dd/yyyy format displays the month as a number with a leading zero (09), the day as a number with a leading zero (06), and the full year (2017). This format would display September 6, 2017 as 09/06/2017.

Question 2

You can enter optional field descriptions in Table ____ View.
A) SQL
B) Query
C) Design
D) Layout

Accepted Answer

In Design View of a table, field descriptions can be added as a way to provide additional information about each field in the table. These descriptions are optional and are not necessary for the table to function properly, but they can be helpful for other users who will be working with the table. SQL, Query, and Layout Views do not have the option to enter field descriptions.

Question 3

Which of the following is NOT defined in Table Design View?
A) field names
B) field entries
C) data types
D) field properties

Accepted Answer

Field entries are not defined in Table Design View. Instead, they are entered in Datasheet View, where data can be added, edited, and deleted within the fields established in Table Design View.

Question 4

The ____ property determines whether users can add or edit the list of items in a Lookup field.
A) Row Source
B) Limit to List
C) Allow Value List Edits
D) Display Control

Accepted Answer

The "Allow Value List Edits" property is specifically designed to control whether users can add or edit the list of items in a Lookup field. This property enables or disables the ability for users to directly modify the list of values available in the field.

Question 5

The ____ property provides a label used to describe the field.
A) Format
B) Caption
C) Input Mask
D) Default Value

Accepted Answer

The Caption property is used to provide a label or description for a field in a table or a form. It can be used to specify how the field should be displayed to the user. The Format property is used to specify the format of the data in the field, the Input Mask property is used to control the input format of the data, and the Default Value property is used to provide a default value for the field when a new record is created.

Question 6

Byte, Long Integer, Single, and Double are examples of entries for which property?
A) Field Size
B) Format
C) Input Mask
D) Validation Rule

Accepted Answer

Byte, Long Integer, Single, and Double are all examples of different data types with different field sizes. Field size refers to the number of bits or bytes that the field can store. For example, a Byte field has a field size of 1 byte, while a Long Integer field has a field size of 4 bytes. Therefore, the best choice for the property these entries belong to is Field Size (option A).

Question 7

The Field Properties pane displays information for how many fields at the same time?
A) Only the selected field.
B) However many are visible in the window.
C) All of the fields in that particular table.
D) All of the fields in the entire database.

Accepted Answer

The Field Properties pane only displays information for the selected field, not all fields in the table or database.

Question 8

Which of the following is NOT shown on a Relationship report?
A) table names
B) field names
C) primary key field data values
D) one-to-many relationship lines

Accepted Answer

Relationship reports show the relationships between tables, including the type of relationship and the fields involved in the relationship. They do not show specific data values for primary key fields.

Question 9

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?
A) Format
B) Caption
C) Default Value
D) Input Mask

Accepted Answer

Input Mask controls both the values that users can enter into a text box and provides a visual guide as users enter data. The input mask property forces users to enter data in a specific format such as phone numbers or social security numbers. It also provides a visual guide for users, such as hyphens in phone numbers or slashes in dates, as they enter data into the text box.

Question 10

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.
A) Row Source
B) Limit to List
C) Allow Value List Edits
D) Display Control

Accepted Answer

The "Limit to List" property determines whether a user can enter a value not already in the list for a field with Lookup properties. If set to Yes, only values already in the list can be entered, preventing new values from being added directly through the field.

Question 11

(999)000-000;1;_ would be a possible entry for which field property?
A) Format
B) Input Mask
C) Caption
D) Validation Rule

Accepted Answer

This entry is defining an input mask for a phone number with the format of (999)000-0000. An input mask is used to control the format of data input in a field.

Question 12

A good Field Size property value for a state abbreviation field is ____.
A) 2
B) 10
C) 50
D) 255

Accepted Answer

A state abbreviation is typically two characters long (e.g. CA for California), so a field size of 2 is sufficient to store this type of data.

Question 13

Which Short Text field property should you use to specify whether an entry was required for the field?
A) Default Value
B) Default
C) Required
D) Test

Accepted Answer

The "Required" property should be used to specify whether an entry was required for the field. This property will ensure that users cannot submit the form without providing a value for the field. A default value or default property may be used to pre-populate the field with a value, but it does not enforce that a value must be entered. The "Test" property is not relevant to this question.

Question 14

The Input Mask property contains how many parts?
A) 1
B) 2
C) 3
D) 4

Accepted Answer

The Input Mask property in database systems like Microsoft Access consists of three parts: the mask itself, a semicolon (;), and a character indicating how to store the data.

Question 15

Where do you modify field properties?
A) In Table Layout View.
B) In Table Design View.
C) In Database Design View
D) As you are entering data in a form.

Accepted Answer

In Table Design View, you can add, remove, or modify fields and their properties such as data type, default value, validation rules, and more. In Table Layout View, you can only modify certain visual properties such as column width and row height. In Database Design View, you can modify overall database properties such as relationships between tables and indexes. As you are entering data in a form, you can only modify data for existing fields, not their underlying properties.

Question 16

The process of removing and fixing orphan records is often called ____.
A) scrubbing the database
B) enforcing rules
C) applying syntax
D) adding criteria

Accepted Answer

Scrubbing the database involves identifying and removing any unwanted or unnecessary data, such as orphan records.

Question 17

____ properties allow you to supply a drop-down list of values for a field.
A) Key
B) Relationship
C) Lookup
D) Junction

Accepted Answer

Lookup properties allow you to supply a drop-down list of values for a field.

Question 18

>=#1/1/93# is an example of an entry for which property for a Date/Time field?
A) Format
B) Default Value
C) Validation Rule
D) Input Mask

Accepted Answer

>=#1/1/93# is a Validation Rule that sets the minimum allowed value for the Date/Time field to January 1st, 1993.

Question 19

Which of the following is NOT a possible entry for the Field Size property of a Number field?
A) Currency
B) Byte
C) Long Integer
D) Single

Accepted Answer

Currency is a valid data type in Access, but it is not a valid option for the Field Size property of a Number data type. The valid options for Field Size are Byte, Integer, Long Integer, Single, and Double.

Question 20

Which of the following is NOT true about field properties?
A) Modifying them helps ensure database accuracy.
B) Some are required, and some are optional.
C) They are the same for each data type.
D) They can be used to change the way data is displayed.

Accepted Answer

Field properties are not the same for each data type. Different data types have different applicable properties.

Quiz 5: Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2017 as: ____.

You can enter optional field descriptions in Table ____ View.

Which of the following is NOT defined in Table Design View?

The ____ property determines whether users can add or edit the list of items in a Lookup field.

The ____ property provides a label used to describe the field.

Byte, Long Integer, Single, and Double are examples of entries for which property?

The Field Properties pane displays information for how many fields at the same time?

Which of the following is NOT shown on a Relationship report?

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

(999) 000-000;1;_ would be a possible entry for which field property?

A good Field Size property value for a state abbreviation field is ____.

Which Short Text field property should you use to specify whether an entry was required for the field?

The Input Mask property contains how many parts?

Where do you modify field properties?

The process of removing and fixing orphan records is often called ____.

____ properties allow you to supply a drop-down list of values for a field.

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

Which of the following is NOT a possible entry for the Field Size property of a Number field?

Which of the following is NOT true about field properties?