Access Database Quiz

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

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

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

• Home

• Relationships

• Design

• View

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

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

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

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

Which feature allows you to create a query by answering a series of prompts rather than building the SQL manually?

• Query Design

• Query Wizard

• Design View

• Datasheet View

When saving a query, which option is typically used?

• File > Open

• File > Save

• File > Export

• File > Compile

In a form, Form View is primarily used for:

• Designing the structure of the form

• Entering, editing, and viewing data

• Creating charts

• Managing relationships