Access - Lesson 7

What ensures that a query result appears in a specific order?

• Filtering
• Sorting
• Ordering
• Placing

Marci is searching a Planet Database. She wants to find out how manymoons Saturn has and the names. Which comparison operator would she use?

• and
• equal
• not
• or

Joe wants to modify the query he created to incorporate various colors,fonts, and styles to create a custom look. Which query would he use?

• Design View
• Simple Query Wizard
• Query Design View
• Query Wizard

Beth needs to determine the seniors with a GPA of 4.0 or higher. Whichobject would allow her to create a saved search to find this informationin the database?

• Form
• Table
• Query
• Report

After a query is created, which action must take place to display theresults of the query?

• Go
• Run
• Get
• Retrieve

Taylor wants to query the airline database to find out how many seats are open on Flight 33. What type of query would she use?

• Crosstab Query
• Multiple Query
• Simple query
• Find

Marci has a database of all the planets. She needs to know what planetshave moons or rings. Which comparison operator would she use to perform the query?

• moons and rings
• moons equal to rings
• moons not ring
• moons or rings

Donna's Bakery lost a customer named Dingin' Donuts. What actionshould be taken to remove all records from her database for Dingin'Donuts?

• Delete Query
• Update Query
• Append Query
• Make Table Query

Keisha created a database of her music. She wants to locate only thesongs by Beyoncé. What tool should she use in order to view thisinformation and save it for later use?

• Filter
• Form
• Query
• Report

Before creating a query from multiple tables, you must first ensure that the tables have which of the following?

• Unmatched records

• A defined relationship

• A filter applied

• No related records