Question 1

Case 1-2 
Lauren wants to create an Access database of the musical instruments she owns. 
-Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?
A) Paragraph
B) Comment
C) Long Text
D) System

Accepted Answer

The Long Text data type allows for the storage of large amounts of text, making it the best choice for storing the paragraph descriptions of Lauren's inventory items.

Question 2

Match between columns
                        Premises: Previous field of the current record

Accepted Answer

The Answer of [Ctrl][Home] and [End] and [Tab] and [Up is...

Question 3

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

Accepted Answer

double-click

Question 4

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

Accepted Answer

If Access assumes that you are attempting to make changes to a field value, you are in Edit mode. Navigation mode is when you are moving through the different fields and records without making changes.

Question 5

Match between columns
                        Premises: Last field of the current record

Accepted Answer

The Answer of [End] and [Home] and [Up Arrow] and is...

Question 6

Match between columns
                        Premises: Next field of the current record

Accepted Answer

The Answer of [Ctrl][End] and [Home] and [Left Arrow] and is...

Question 7

Match between columns
                        Premises: First field of the current record

Accepted Answer

The Answer of [Ctrl][Home] and [End] and [Down Arrow] and is...

Question 8

Match between columns
                        Premises: Current field of the next record

Accepted Answer

The Answer of [End] and [Ctrl][Home] and [Home] and [Left is...

Question 9

In Access, two users can edit the same record at the same time.

Accepted Answer

The answer of In Access, two users can edit the...

Question 10

Match between columns
                        Premises: First field of the first record

Accepted Answer

The Answer of [Left Arrow] and [Home] and [Ctrl][Home] and is...

Question 11

You can use the Calendar Box to enter dates in a Date/Time field.

Accepted Answer

Picker

Question 12

Match between columns
                        Premises: Current field of the previous record

Accepted Answer

The Answer of [Home] and [Left Arrow] and [Up Arrow] is...

Question 13

Case 1-2 
Lauren wants to create an Access database of the musical instruments she owns. 
-A Purchase Price field should be which data type?
A) Text
B) Number
C) Monetary
D) Currency

Accepted Answer

The Purchase Price field should be of the Currency data type to ensure that it only accepts numerical values with decimal points and currency symbols. This also allows for easy formatting and calculations of monetary values in queries and reports.

Question 14

Case 1-1 
Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. Her crew manager will also be using the system. Hannah is considering whether to use Excel or Access. 
-Which one of the following is NOT a benefit of using Access?
A) More data storage
B) Multiuser capability
C) Easier setup
D) Additional reporting features

Accepted Answer

While Access does offer more data storage, multiuser capability, and additional reporting features, it is generally more complex to set up compared to Excel. Therefore, the option that is NOT a benefit of using Access is easier setup.

Question 15

Match between columns
                        Premises: Last field of the last record

Accepted Answer

The Answer of [Down Arrow] and [End] and [Ctrl][Home] and is...

Quiz 5: Module 1 Getting Started With Access

Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. -Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

Match the shortcut keystrokes to the correct action.

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

Match the shortcut keystrokes to the correct action.

Match the shortcut keystrokes to the correct action.

Match the shortcut keystrokes to the correct action.

Match the shortcut keystrokes to the correct action.

In Access, two users can edit the same record at the same time.

Match the shortcut keystrokes to the correct action.

You can use the Calendar Box to enter dates in a Date/Time field.

Match the shortcut keystrokes to the correct action.

Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. -A Purchase Price field should be which data type?

Match the shortcut keystrokes to the correct action.