Access 2007: Locating Specific Information

What is the purpose of designing and running queries in Access 2007?

• To delete data from a database

• To create a new database

• To update the database schema

• The purpose is to retrieve specific data from a database based on certain criteria or conditions.

How can you specify multiple criteria in a query?

• Use logical operators like AND or OR to combine multiple conditions in a query.

• Use the NOT operator to combine multiple conditions in a query.

• Specify each condition separately in a separate query.

• Use mathematical operators like + or - to combine multiple conditions in a query.

What is the purpose of creating reports in Access 2007?

• To store data in a database.

• To create animations and graphics.

• To perform calculations and analysis on data.

• To present data in a structured and organized format.

How can you in Access 2007 rearrange the records in alphabetical order in a table on a specific fields ?

• Set the 'Sort Order' property to 'Ascending' in the Sort & Filter Group.

• Change the field type to 'Text' and then sort the records alphabetically.
• Click on the 'Sort' button in the toolbar.
• Use the 'Filter' option to sort the records alphabetically.

How can you reverse the sort order of a field in Access 2007?

• Use the DESC keyword in the SQL query
• Use the ASC keyword in the SQL query
• Click on the 'Sort Descending' button in the Sort & Filter Group.

• Change the field's data type to 'Descending'

To sort more than one filed in Access 2007 the fields must be adjacent.

• False
• True

In Access 2007 what is the more effective way to locate only the records containing (or not containing)

specific information?

• Filter
• Delete
• Sort
• Copy

If you want to locate records containing certain information but aren't sure of all

the characters, or want your search to return multiple variations of a base character you can include _________in your search criteria.

• Variables

• Filter

• Wildcard characters

• #

The ______ represents any number of characters in a search criteria.

• • + (plus sign)

• # (number sign)

• ? (question mark)

• * (asterisk)

How in Access 2007 you create a filter in a field for a specific word ?

• Select the specific word, then on the Home tab, in the Sort & Filter group, click the Selection button, and then

  in the list, click Equals

• Select the specific word, then on the home tab use the Filter by Selection feature

• Select the specific word, then on the home tab use the Filter by Query feature

• Select the specific word, then on the home tab use the Filter by Report feature