Access Queries Quiz

What is the purpose of creating queries in Access?

• To make searches more efficient

• To make the database grow bigger

• To slow down database searches

• To complicate database management

Where can you find the option to create queries in Access?

• Create tab

• Query tab

• Design tab

• Home tab

What does the asterisk symbol (*) represent in a query design?

• All fields from all tables

• A specific field

• A calculation

• No fields selected

What does the 'Show' row in query design allow you to do?

• Apply filters to the results

• Change the font size

• Display all fields in the results

• Hide certain fields from the results

What is the purpose of using 'and' in a query criteria?

• Exclude results that meet any condition

• Include results that meet all conditions

• Exclude results that meet both conditions

• Include results that meet any condition

How can you refine a query to show only specific data?

• Add more tables to the query

• Use the 'Refine' button

• Apply criteria to the fields

• Change the font style

What does the 'or' condition do in a query criteria?

• Excludes certain conditions

• Requires any condition to be true

• Requires all conditions to be true

• Sorts the results

How can you show results that belong to multiple categories?

• Use 'all' condition

• Use 'or' condition

• Use 'not' condition

• Use 'and' condition

What happens if you run a query without any criteria?

• It shows all results

• It shows no results

• It prompts for criteria

• It crashes the database

How can you save a query in Access?

• Run the query

• Close the query window

• Press Ctrl + S

• Click 'Save Query'