Simple Access Queries

What is the purpose of creating a query in Access?

• To create new tables in the database

• To delete records from the database

• To analyze data by asking the database a question

• To modify data in the database

How many tables can a query retrieve data from?

• Only from a single table

• Only from two tables

• From multiple tables depending on the complexity

• Queries cannot retrieve data from tables

What is a simple query that uses a single table sometimes called?

• A basic search

• A complex filter

• A single table query

• An advanced filter

Where do you go to create a query in Access?

• The Home tab

• The Create tab

• The Design tab

• The Database Tools tab

Which view do you use to see the results of a query?

• Datasheet View

• Layout View

• Design View

• Object View

What is the area called where the table fields appear when creating a query?

• The Table View

• The Design Grid

• The Field List Pane

• The Object Relationship Pane

How do you add fields to a query in Design View?

• By typing the field names

• By dragging the fields

• By double-clicking each field

• By selecting from a list

How can you sort the results of a query?

• By using the Sort row in the Design Grid

• By rearranging the fields in the Object Relationship Pane

• Sorting is not possible in queries

• By sorting the table before creating the query

What do you type in the Criteria row to filter records?

• A mathematical formula

• The name of the field

• The specific value you are looking for

• Any text for a broad search

What is the final step after designing a query?

• Reviewing the query design

• Closing Access

• Running the query

• Saving the query