Access Filtering Category, 10 points

A restriction you place on records in the open datasheet or form to quickly isolate and display a subset of records.
Access Filtering Category, 20 points

Filter by Selction
Filter by Form
Access Filtering Category, 30 points

True.
Access Filtering Category, 40 points

False.
Access Filtering Category, 50 points

True.
Access Querying Category, 10 points

The Simple Query Wizard is used to create a query that is based on one table or query.
Access Querying Category, 20 points

The Show box (in the Query Design view) allows you to indicate whether the field should be displayed when running the query.
Access Querying Category, 30 points
Select QueryRetrieves the specifid data from one or more tables.
Crosstab QuerySummarizes data in a row-and-column format.
Parameter QueryPrompts user for information, such as criteria for retrieving certain data.
Action QueryMakes changes to one or more records.
SQL QueryCreated using Structured Query Language.
Access Querying Category, 40 points

No. You must use the Query Design view to create a query that uses two or more tables.
Access Querying Category, 50 points

The Criteria cell would contain
Like "B*"
Access Advanced Filtering and Querying Category, 10 points

In Filter by Form, you can also type AND between criteria in the same field. For example, "Syracuse" AND "Rochester" may be criteria associated with a City field.
Access Advanced Filtering and Querying Category, 20 points

False.
The AND operator narrows the search, since a record must meet both conditions to be included. The OR operator broadens the seach since any record meeting either condition is included.
Access Advanced Filtering and Querying Category, 30 points
SymbolUseExample
*Matches any number of characters."Smit*" finds "Smitt", "Smith", "Smithers", etc.
?Matches any single character."Smit?" finds "Smitt", "Smith" but not "Smithers".
[]Matches any single character within the brackets."b[iu]g" finds "big", "bug" but not "bag".
!Matches any character not in the brackets."b[!iu]g" finds "bag", "bog" but not "big", "bug".
-Matches any one of a range of characters that you specify."[a-m]ag" finds "bag", "gag", "lag" but not "nag", "rag", "sag", "tag".
#Matches any single numeric character."1#3" finds "123", "143" but not "1223", "1453".
Access Advanced Filtering and Querying Category, 40 points

A join is an association that tells Access how data between tables is related. A relationship is defined between two tables, usually through at least one common field.
Access Advanced Filtering and Querying Category, 50 points

True. Refer to pages DB124 through DB126 for details.
Access Sharing Data (Lab 5) Category, 10 points

No.
Access Sharing Data (Lab 5) Category, 20 points

A linked object is a graphic representation of the data that is contained in the source file. The data is stored only in the source file.
Access Sharing Data (Lab 5) Category, 30 points

Exporting data will save data in another format, to be inserted into another application. Once the data is exported, any changes to the Access data will not automatically change the exported data.

Creating a linked object allows any changes in the source data (in Access) to be automatically updated in the other application.
Access Sharing Data (Lab 5) Category, 40 points

When you insert Access data into Word, by creating a linked object, the Access data looks like a Word table or a spreadsheet. However, its really a graphic representation of the Access data.
Access Sharing Data (Lab 5) Category, 50 points

Hurray!