WorksheetsAccess Queries Quiz
Total questions: 20
Worksheet time: 40mins
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'
What is the benefit of using queries in a growing database?
Increases database size
Makes searches more efficient
Adds complexity to searches
Slows down searches
Is a .csv file an Excel file?
Yes
No
To create a Relationship, you would go in the bar menu to:
Create
Database Tools
External Data
Home
What is a suitable data type for usage?
Text
Number
Currency
Yes/No
Which data type would be most suitable for the 'Age' field?
Currency
Date & Time
Number
Memo
What is the primary key field for the 'm2017 boards' table?
Tree ID
Location Code
Year Milled
Board ID
Which data type should be used for the 'Year Milled' field in the 'm2017 trees' table?
Text
Date
Integer
Boolean
What is the primary key field for the 'locations' table?
Tree ID
Tree Type
Telephone
Location Code
