To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.
To create a report using the Report Wizard, click ____ on the Ribbon and then click the Report Wizard button.
If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is ____.
In Access, a(n) ____ consists of a collection of tables, each of which contains information on a specific subject.
In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.
To open a table in Design view, right-click the table in the Navigation pane and then click ____ on the shortcut menu
If a field has a Number data type, you can change the ____ property to Fixed to set a fixed number of decimal places.
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in _____.
square brackets [ ]
Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).
To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.
To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.
To find the average amount paid amount for a client, select _____ as the entry in the Total row for the Amount Paid column.
A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
To change the design of a query, right-click the query and then click ____ on the shortcut menu.
When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
To undo the most recent change to a table structure, click the ____ button on the Quick Access Toolbar.
To find all clients whose amount paid is greater than $20,000.00 and whose recruiter is recruiter 21, enter each criterion on the same line.
Backing up the database as well as compacting and repairing a database are database maintenance tasks.
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Text.
To use the Simply Query wizard to create a query, click the ____ tab on the Ribbon and then click the Query Wizard button.
To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted and then press the DELETE key.
To include calculated fields in queries, enter a name for the calculated field, a(n) _____, and then the expression in one of the columns in the Field row.
To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.
To find all clients whose amount paid is greater than $20,000.00 or whose recruiter is recruiter 21, enter each criterion on the same line.
To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet.
When tables are joined in a query, it is not possible to restrict retrieval by using criteria.
To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.
To find all clients whose names begin with Be, enter Be? in the Criteria row of the design grid.
In the accompanying figure, the key symbol that appears in the row selector for the Client Number field indicates that Client Number is the ____ for the table.
To insert a field as the last field in a table, right-click the Add New Field column heading, click ____ on the shortcut menu, type the desired field name, click the down arrow, and then ensure the correct data type is already selected.
To find all individuals whose name is Tom or Tim, enter ____ in the Criteria row of the appropriate column.