Access Chapter Review 5.2

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

What does a find unmatched query do?

It finds all records in a table or query that have no related records in a second table or query.

What are the four query wizards you can use to create a new query?

Simple Query Wizard, Crosstab Query Wizard, Find Duplicates Query Wizard, Find Unmatched Query Wizard.

What happens if you set a query's Top Value property to 2, and the first five records have the same value for the primary sort fields.?

Access displays the first five records.

What is a find duplicates query?

A query that finds duplicate records in a table or query based on the values in one or more fields.

What is the purpose of a crosstab query?

It performs aggregate function calculations on the values of one database field and displays.

What happens when you set a query's Top Values Property?

You limit the number of records displayed in the query results.


संबंधित स्टडी सेट्स

Orientation: canvas student orientation quiz

View Set

Networking + 6 edition Chapter 4

View Set

AICPA Code of Professional Conduct: Conceptual Framework Part 1: Members in Public Practice (1B1 Video 2)

View Set