Exam 4: Access: Querying a Database

To find records in one table that have no matching records in another table, use the _____ Query Wizard.

To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.

To create a multivalued field, create a(n)____________________ field being sure to check the Allow Multiple Values check box.

To order the records in the Client table by city in alphabetical order, use the ____ button.

The accompanying figure shows a join of the Business Analyst and Client tables.If two tables have matching fields, that is, fields with the same name, Access draws a line called a(n)____________________ line between the matching fields to indicate that the tables are related.

The property that the value in a foreign key must match another table's primary key is called _________________________.

To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.

When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

To indicate that the only allowable values for the Client Type field are NON, RET, and SER, enter ____ in the Validation Rule property box.

Maintenance of a database can involve the need to _________________________ periodically; that is, to change the database structure.

To sort records in a query, specify the sort order in the _____ row of the design grid below the field that is the sort key.

Validation rules are rules that a user must follow when entering the data.

Looking for the client whose number is GF56 is an example of searching.

Grouping means creating groups of records that share some common characteristic.

To use Filter By Selection to find all clients located in Burles, click the City field for any record where the city is Burles and then click the ____ button on the Home tab shown in the accompanying figure.

Which aggregate function will find the client with the smallest amount paid?

The only calculated fields you can create in Access are those involving addition.

In the accompanying figure, you can delete the table by right-clicking the field list and clicking ____ on the shortcut menu.

The ____________________ function finds the smallest value in a group of records.