Database - Queries

what is a query?

• An object that is used for calculations

• A database object that is used to retrieve specific data based on a criteria

• An object for entering data

• None of the above

When creating a query, under the query tab, what do you select?

• Query design

• table design

• form design

• query builder

How do you add fields in a query when in the query design window?

• pressing enter

• clicking escape button

• double clicking on each field

• selecting the records

To run a query and view its results, you click on the______________ button.

• Run

• Select

• view

• Ask

What is the name of the button you click on when you want to save your query?

In specifying the criteria in a query, which row is the criteria specified?

• Or

• Criteria

• Sort

• Field

To hide a field in a query, which row do we uncheck?

• Show

• Or

• Criteria

• Sort

When deleting a field in a query, which button on the keyboard will you press?

What is the meaning of this logical operator?

<>

• larger than or less than

• less than or larger than

• not equal to

• not less than

More fields can be added to the query from the ________ view.

• Sheet

• Sort

• Design

• Create