Exam 7: Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Databases have a robust set of selection ________ that can be used to make queries well focused.

If you forget to put ________ around a date,Access will add them for you.

When you are creating a query,all the tables added to the query should be connected by relationships and have a ________.

If you have a table that has records that have no matching records in a second table or query,you can find the request using the ________ query.

When you want to describe one field in terms of two or more other fields in a table you use a(n)________.

When you sort numbers in highest to lowest order,you are using a(n)________ sorting option.

To compare the values in a table or query to a specific criteria value you set up in the query,you use ________ operators.

A single table query pulls data from two or more tables.

To switch between a filtered table and a whole table,use the ________ or the Filtered indicator.

An Access tool that helps you format your calculated fields correctly is called ________.

A query based on ONLY one table in your database is called a(n)________ query.

To create a query that will return all invoices that include and fall within January 1,2012 and January 1,2014,you would use the BETWEEN special operator.

When you suspect that you have multiple instances of a record in a table,you should use the ________ query wizard.

When you add a total row to a table or a query in datasheet view,you are using a(n)________.

When a data entry clerk types the name "Smith" as "Smyth" the table will have ________ data.

If you think you may have duplicate records in a table,you should run the ________ query.

A(n)________ query makes trouble-shooting more difficult if the query does not work.

Sorting is the process of pulling matching records from several different tables.

The ________ logical operator is true if ALL the criteria are met.