Font size
WorksheetsMS Access
Total questions: 10
Worksheet time: 6mins
Data that is stored within a single table is known as
Relational database
Simple query
Flat file database
Dynamic table
Unique key in database is known as
Foreign key
Dynamic key
Key field
Primary key
The bracket to include dynamic parameter is
[ ]
( )
{ }
< >
Query similar to Information in a textbook
Simple Query
Complex query
Static query
Dynamic query
Query similar to live weather updates
Simple query
Complex query
Static Query
Dynamic query
Uses fixed values as criteria
Simple query
Static Query
Dynamic Query
Complex query
Changes within the query in
(a)
Asks the user to enter a formula or value
Dynamic query
Complex query
Static Query
Simple query
Choose the correct explanation for the query
A static query has been created to show all products below $75
A static query has been created to show all products below and equal to $75
A static query has been created to show all products above and equal to $75
A static query has been created to show all products over $75
Choose the correct explanation for the given query
A dynamic query has been created to show all customers in the state that will be chosen by the user
A static query has been created to show all customers in the state that will be chosen by the user
A dynamic query has been created to show all customers in the state that will be chosen by the software
A static query has been created to show all customers in the state that will be chosen by the software
