Question 1

What data type should you assign to a WeeklySalary field?
A) Currency
B) Salary
C) Number
D) Date/Time

Accepted Answer

The weekly salary is typically expressed in a monetary value, which makes the Currency data type the most appropriate choice.

Question 2

How do you rename a table?
A) Right-click the object tab in the Access window,and then click Rename.
B) Right-click the table in the Navigation Pane,and then click Rename.
C) Click the table in the Navigation Pane,and then click the Rename button.
D) Open the table in Table Datasheet view,and then click the Rename button.

Accepted Answer

Right-clicking the table in the Navigation Pane and selecting Rename is the easiest and most direct way to rename a table in Access. It can also be done by clicking on the table in the Navigation Pane and then clicking on the Rename button in the Ribbon, but the right-click method is quicker.

Question 3

What Field Size should you set for a State field that stores two-character state abbreviations?
A) 255
B) 5
C) 2
D) 0

Accepted Answer

As two-character state abbreviations are always going to be two characters long, a field size of 2 will suffice. It is not necessary to allocate any extra space, such as the 255 or the 5, as this would be an inefficient use of storage resources. A field size of 0 would not allow any characters to be entered into the field.

Question 4

To delete a field in Table Datasheet view,you click _____.
A) any value in the field
B) the first value in the column
C) the record selector for any record
D) the column heading for the field

Accepted Answer

To delete a field in Table Datasheet view, you click on the column heading for the field you want to delete.

Question 5

Which of the following properties can you apply to a Number field in Report Design view? Select all the options that apply.
A) Format = Currency
B) Decimal Places = 0
C) Decimal Places = 1
D) Format = Conditional

Accepted Answer

A) Format = Currency: This property is useful if you want the number to be displayed in currency format, with a currency symbol and the appropriate number of decimal places.
B) Decimal Places = 0: This property is useful if you want the number to be displayed as a whole number, without any decimal places.
C) Decimal Places = 1: This property is useful if you want the number to be displayed with one decimal place.

D) Format = Conditional: This property is not applicable to a Number field in Report Design view. It is used for formatting based on certain conditions, but not for formatting numbers specifically.

Question 6

Which of the following are possible entries for the Field Size property of a Number field? Select all the options that apply.
A) Currency
B) Long Integer
C) Byte
D) Single

Accepted Answer

A) Currency is not a valid choice for Field Size property of a Number field.
B) Long Integer is a valid choice for Field Size property of a Number field and can store numbers from -2,147,483,648 to 2,147,483,647.
C) Byte is a valid choice for Field Size property of a Number field and can store numbers from 0 to 255.
D) Single is a valid choice for Field Size property of a Number field and can store numbers with decimals up to 7 digits long.

Question 7

To rename a table,you must use the Navigation Pane.

Accepted Answer

To rename a table, you must select it in the Navigation Pane and then right-click and choose "Rename".

Question 8

To decrease the decimal places in a Number field in Report Design view,you can use the Decrease Decimals button or the Decimal Places property.

Accepted Answer

Both options can be used to decrease decimal places in a Number field in Report Design view.

Question 9

Changing the _____ property for a field does not change the actual data stored in the field.
A) Short Text
B) Primary Key
C) Decimal Places
D) Number

Accepted Answer

Changing the Decimal Places property for a field only affects how many decimal places are displayed, but does not change the actual data stored in the field. The other properties listed can potentially change the data stored in the field.

Question 10

If a field contains the value 1.204 but displays the value 1.2,what can you do to show the entire value?
A) Decrease the number of decimal places.
B) Increase the number of decimal places.
C) Apply the Percent format to the field.
D) Apply the Comma Number format to the field.

Accepted Answer

Increasing the number of decimal places will allow the entire value of 1.204 to be displayed.

Question 11

For a State field that stores two-letter state abbreviations,you can set the _____ property for the field in Table Datasheet view.
A) Default Value
B) Format
C) Field Size
D) Lookup

Accepted Answer

The Field Size property is used to specify the maximum number of characters a text field can store, which in this case would be set to 2 for two-letter state abbreviations.

Question 12

Access sets the number of decimal places in a Number field,and you cannot change it.

Accepted Answer

In Access, you can change the number of decimal places in a Number field by adjusting the field's properties, specifically the "Decimal Places" property, to suit your needs.

Question 13

You cannot set the Field Size property for Short Text fields in Table Datasheet view.

Accepted Answer

You can set the Field Size property for Short Text fields in Table Datasheet view in Access by selecting the field, opening the Field Properties, and adjusting the Field Size property there.

Question 14

The _____ property controls how many characters can be entered into the field.
A) Format
B) Required
C) Input Mask
D) Field Size

Accepted Answer

Field Size property controls how many characters can be entered into the field.

Question 15

Which of the following are properties you can set for a Currency field? Select all the options that apply.
A) Format
B) Decimal Places
C) Default Value
D) Field Size

Accepted Answer

A) Format: You can set the currency format to display the symbol before or after the value and choose the currency symbol.
B) Decimal Places: You can specify the number of decimal places to display for the currency.
C) Default Value: You can set a default value for the field to populate automatically when a new record is created. 
D) Field Size: Currency fields have a standard size of 16 bytes and cannot be changed. However, this is not a property that can be set for a Currency field.

Question 16

What happens if you delete a field from a table that contains data?
A) Access stores the deleted data in a new table.
B) Access stores the deleted data in a new field in the same table.
C) You can append the deleted data to an existing table.
D) You delete all the data in the field.

Accepted Answer

Deleting a field from a table that contains data will delete all the data in the field.

Question 17

If a field named Price displays values with three decimal places,what should you do to display the values accurately?
A) Increase the number of decimal places.
B) Re-enter the field values.
C) Change the data type of the field.
D) Decrease the number of decimal places.

Accepted Answer

The answer of If a field named Price displays values...

Question 18

You typically increase the decimal places from 1 to 2 for a(n)_____ field.
A) Currency
B) AutoNumber
C) Long Text
D) Money

Accepted Answer

Currency fields typically require two decimal places to accurately represent amounts of money.

Question 19

In Table Datasheet view,you must use a property sheet to increase the decimal places in a Number field.

Accepted Answer

In Table Datasheet view, you can directly adjust the format of a Number field, including decimal places, by selecting the field, accessing the Field Properties, and then adjusting the Format property or using the Increase Decimals/Decrease Decimals buttons in the ribbon, without necessarily using a property sheet.

Question 20

If you set the Decimal Places property to 0 for a Price field,and then enter 750.25 in the field,what does Access display in the datasheet?
A) 750.25
B) 750.2
C) 750
D) 751

Accepted Answer

When the Decimal Places property is set to 0, Access will truncate any decimal values and display only the whole number, so the field will display 750.

Quiz 2: Formatting Workbook Text and Data

What data type should you assign to a WeeklySalary field?

How do you rename a table?

What Field Size should you set for a State field that stores two-character state abbreviations?

To delete a field in Table Datasheet view,you click _____.

Which of the following properties can you apply to a Number field in Report Design view? Select all the options that apply.

Which of the following are possible entries for the Field Size property of a Number field? Select all the options that apply.

To rename a table,you must use the Navigation Pane.

To decrease the decimal places in a Number field in Report Design view,you can use the Decrease Decimals button or the Decimal Places property.

Changing the _____ property for a field does not change the actual data stored in the field.

If a field contains the value 1.204 but displays the value 1.2,what can you do to show the entire value?

For a State field that stores two-letter state abbreviations,you can set the _____ property for the field in Table Datasheet view.

Access sets the number of decimal places in a Number field,and you cannot change it.

You cannot set the Field Size property for Short Text fields in Table Datasheet view.

The _____ property controls how many characters can be entered into the field.

Which of the following are properties you can set for a Currency field? Select all the options that apply.

What happens if you delete a field from a table that contains data?

If a field named Price displays values with three decimal places,what should you do to display the values accurately?

You typically increase the decimal places from 1 to 2 for a(n) _____ field.

In Table Datasheet view,you must use a property sheet to increase the decimal places in a Number field.

If you set the Decimal Places property to 0 for a Price field,and then enter 750.25 in the field,what does Access display in the datasheet?