Access Filtering Category, 10 points
What is a filter?
Access Filtering Category, 20 points
What are the two filtering methods available within Access?
Access Filtering Category, 30 points
True or False?
In Filter by Selection, you move the cursor to a specifid value within datasheet view, then click on the Filter by Selection button. This will elimiate all records from the display that do not match the specified value at the cursor location.
Access Filtering Category, 40 points
True or False?
In Filter by Form, you can not specify multiple criteria.
Access Filtering Category, 50 points
True or False?
In Filter by Selection, you are guaranteed to display at least one record.
Access Querying Category, 10 points
What is the Simple Query Wizard used for?
Access Querying Category, 20 points
What does the Show box do within the Query Design view?
Access Querying Category, 30 points
Identify three types of queries that you can build in Access.
Access Querying Category, 40 points
Can you use the Simple Query Wizard to create a query that combines two or more tables?
Access Querying Category, 50 points
What would the Criteria cell look like if we wanted to display data associated with people whose first name begins with a "B"?
Access Advanced Filtering and Querying Category, 10 points
In Filter by Form, the AND operator is assumed when you enter criteria in multiple fields. Is there another way that you can specify the AND operator in Filter by Form?
Access Advanced Filtering and Querying Category, 20 points
True or False?
The AND operator broadens the search, while the OR operator narrows the search.
Access Advanced Filtering and Querying Category, 30 points
Identify three wildcard characters and their respective use (meaning).
Access Advanced Filtering and Querying Category, 40 points
What is a join?
Access Advanced Filtering and Querying Category, 50 points
True or False?
You can create a calculated field within a query.
Access Sharing Data (Lab 5) Category, 10 points
When you use Copy and Paste to share data between applications, does changing the source of the data automatically change the copy?
Access Sharing Data (Lab 5) Category, 20 points
Describe a linked object.
Access Sharing Data (Lab 5) Category, 30 points
What is a difference between exporting data from Access and creating a linked object to Access data?
Access Sharing Data (Lab 5) Category, 40 points
When you insert Access data into Word, by creating a linked object, what does the graphic representation look like?
Access Sharing Data (Lab 5) Category, 50 points
Congratulations, you've just earned yourself 50 points!