Upgrade to remove ads
Only $35.99/year

Access III

Terms in this set (34)

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.
query design grid
How can you list the records in a query datasheet in A-Z order by CustomerName?
Click a value in the CustomerName field, and then click the Ascending button
What are you doing when you enter data into a subdatasheet?
You are entering records in the related table.
. In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table?
the positions offered by each employer
If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?
to the right of the City field
To replace "coffee" with "beverage" in any part of a field, you click the ____ in the Find and Replace dialog box.
Match arrow
To create a banded rows effect in a report, you _____
set the alternate row color of a report section
Which of the following can you change when formatting a table?
background color
How do you display the results of a query listed in the Navigation Pane?
Double-click the query.
To filter for comparative data, use the _____ feature
Filter By Form
What should you do before applying a new filter to a datasheet?
Clear all previous filters
What expression would you use to create a calculated field that determines the discount price by subtracting 10 from the value in the Price field?
DiscountPrice: [Price]-10
You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.
criteria
A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?
Find and Replace
A _____ is a saved object within the database, whereas a _____ is temporary.
query; filter
What can you add to a query datasheet to display statistics for a group of records?
Total row
Which of the following criteria uses the correct syntax for a Date/Time field in a query?
#5/7/2021#
When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field?
Modify Expression
What happens if you hide the Bonus column in the Employees table in Table Datasheet view?
The Bonus column no longer appears in the datasheet, but is still part of the Employees table.
You can add fields to a form in Design view or _____
Layout view
Query Design view presents the fields you can use for a query in small windows called field _____
lists
To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.
field selector
What criterion would you use to find numbers greater than or equal to 100?
>=100
To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____
Sum
The easiest way to filter the records for an exact match is to use the _____ feature.
Filter By Selection
To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.
summary query
To apply the last filter you selected to a datasheet, you click the _____ button.
Toggle Filter
How do you display the records in a subdatasheet?
You click the expand button in the datasheet.
What does the criterion <=200 mean?
less than or equal to 200
What might you need to do after increasing the font size in a table datasheet?
Widen the columns.
What happens when you run a query from Query Design view?
Access displays a datasheet containing the query results.
In Table Datasheet view, a(n) _____ shows the records on the "many" side of a one-to-many relationship.
subdatasheet
What button do you use on the Query Tools Design tab to add a field list to a query?
Show Table button
What data type is most appropriate for a field named PaymentAmt?
Currency
Students also viewed