Font size
WorksheetsDatabase Queries and Reports
Total questions: 10
Worksheet time: 8mins
The picture shows some features of a database. Which of the following are queries? (multiple answers allowed)
teachRpt
qryIT
Teacher
qryDegree
Looking at the picture of the database, which of the following is the report?
Subjects
teachRpt
qrySubjects
Teacher Report
What is the criteria for the query shown in the image
Teacher
No Degree
No
Yes Degree
The image shows two database tables. Which of these queries below show fields that came from both tables? (You can have multiple answers)
Which of the following is used to extract information from a database?
tables
queries
relationships
keys
Which of the following is used to store data in a database?
reports
queries
tables
relationships
The __________ is used to present information in a format that is attractive and easy to follow.
table
report
query
key
Data in a report can be arranged in ascending order?
True
False
For the query shown in the image, what criteria was used to produce the result?
no degree
yes degree
name
females
A query can always be created before tables.
true
false
