Search Header Logo

QUERIES IN MS ACCESS – MULTIPLE CHOICE

Authored by H Watt

Business

10th Grade

Used 21+ times

QUERIES IN MS ACCESS – MULTIPLE CHOICE
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following can a query do?

Only display data

Only delete data

Search, sort, and filter data

Only print data

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Home

Create

External Data

Database Tools

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?