Matching
Match the shortcut keystrokes to the correct action.
Premises:
Last field of the current record
Current field of the next record
Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary sort field.
Current field of the previous record
First field of the current record
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?
Last field of the last record
Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?
Previous field of the current record
Lauren wants to create an Access database of the musical instruments she owns. She 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?
First field of the first record
A query allows the selection of several fields and records from one or more tables, then presents the selected data as a single datasheet.
Next field of the current record
Responses:
It's easier to set up a relational database than a spreadsheet
Multiuser capability
False
More reporting features
Number
[Ctrl][End]
Currency
[left arrow]
[Ctrl][Home]
Monetary
[down arrow]
[End]
Date/Time
[Tab]
[up arrow]
[Home]
More data storage
Memo
d. Number
d. Number
Text
True
Correct Answer:
Premises:
Responses:
It's easier to set up a relational database than a spreadsheet
Multiuser capability
False
More reporting features
Number
[Ctrl][End]
Currency
[left arrow]
[Ctrl][Home]
Monetary
[down arrow]
[End]
Date/Time
[Tab]
[up arrow]
[Home]
More data storage
Memo
d. Number
d. Number
Text
True
Premises:
It's easier to set up a relational database than a spreadsheet
Multiuser capability
False
More reporting features
Number
[Ctrl][End]
Currency
[left arrow]
[Ctrl][Home]
Monetary
[down arrow]
[End]
Date/Time
[Tab]
[up arrow]
[Home]
More data storage
Memo
d. Number
d. Number
Text
True
Responses:
Related Questions
Q3: When you add a new field to
Q24: A specific category of data such as
Q45: Compare the capabilities of queries and filters.
Q53: Once you have created and named a
Q53: In a(n) _ form, the upper pane
Q54: This control displays a list of possible
Q71: Values in an AutoNumber field are automatically
Q183: Clicking the _ button sums the adjacent
Q190: The COUNTA function is used to count
Q191: You can apply a chart type to