MS Access

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