QUERIES IN MS ACCESS – MULTIPLE CHOICE

What is the main purpose of a query in MS Access?

• To create tables for storing data.

• To design the layout of forms and reports

• To ask questions about the data in your tables and retrieve specific information

• To automatically enter data into your database.

Which of the following is the first step in creating a new query in MS Access?

• Running the query.

• Selecting the "Create" tab and then clicking "Query Design" or "Query Wizard".

• Entering data into the query grid.

• Saving the query.

What is a query in Microsoft Access?

• A type of table

• A request to retrieve or manipulate data from a database

• A form to enter data

• A kind of report

Which of the following can a query do?

• Only display data

• Only delete data

• Search, sort, and filter data

• Only print data

Which tab in Access would you click to create a new query?

• Home

• Create

• External Data

• Database Tools

What does the "Criteria" row in the query design grid allow you to do?

• Arrange the order in which records are displayed.

• Set conditions to filter the records that are included in the query results.

• Choose which fields are visible in the query results.

• Assign a new name to a field in the query results.

What is a criteria in a query?

• A field name

• A condition that data must meet to be shown

• A type of form

• A query name

Which of the following operators would you use in the "Criteria" row to find records where a field's value is greater than 10?

• = 10

• <= 10

• > 10

• <> 10

If you wanted to find all customers from London, where would you type “London” in the query design grid?

• In the Field row

• In the Table row

• In the Criteria row

• In the Sort row

What does the "Sort" row in the query design grid allow you to do?

• Filter records based on specific conditions.

• Arrange the order of the records in the query results (e.g., alphabetically or numerically).

• Choose which fields are displayed in the query.

• Calculate totals or averages.