Search Header Logo

Access Database Quiz

Authored by sravani sunkara

Computers

8th Grade

Used 6+ times

Access Database Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is a query in Access primarily used for?

Storing data permanently

Displaying and filtering specific information from tables

Designing user interfaces

Backing up the database

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In a relational database, a primary key in one table and a foreign key in another table are used to:

Encrypt data

Establish a relationship between tables

Normalize a table

Create a backup

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which tab in Access would you use to create or edit relationships between tables?

Home

Relationships

Design

View

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In a relation, the field used to join two tables is typically:

A non-key field

The foreign key only

A matching field such as Roll_No

A calculated field

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following statements about a foreign key is true?

It is always the primary key in the same table

It must match the primary key in another table

It can be any random value

It cannot be indexed

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In Design View of a query, what is the purpose of the Show row?

To specify which tables are displayed in the query results

To select fields that should be visible in the output

To set sorting order for the results

To enter criteria for filtering

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Criteria in a query design grid are used to:

Determine the color of the output

Specify the condition to filter records

Add new fields to the table

Create relationships

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?