Creating a Parameter Query - GCFGlobal (11)

What is a parameter query?

• A complex query that requires coding

• A simple query that can be easily updated with a new search term

• A query that cannot be modified

• A query that only works with numbers

What role do search terms play in parameter queries?

• They are fixed and do not change

• They act as variable criteria that change each time you run the query

• They are used only for sorting data

• They are optional and not necessary

What happens when you run a parameter query in Access?

• Access automatically generates a report

• Access prompts you for a search term and shows results based on it

• Access closes the database

• Access deletes the query

What is the first step in creating a parameter query?

• Write a complex script

• Create a query as you normally would, selecting fields and adding criteria

• Delete all existing queries

• Export the database to a new format

What should you enclose the phrase in when creating a prompt for a parameter query?

• Parentheses ( )

• Brackets [ ]

• Curly braces { }

• Quotation marks " "

Where do you select the field for the variable criteria in a parameter query?

• Design tab

• Criteria row

• Data tab

• Format row

What command do you use to run your query in the Design tab?

• Start

• Execute

• Run

• Launch

What does a parameter query allow you to do in a database?

• Search for exact text entered in the prompt.

• Automatically update data entries.

• Sort data in ascending order.

• Delete duplicate entries.

How can you create a variable criteria in a query?

• By typing the prompt text in brackets.

• By using a drop-down menu.

• By selecting a checkbox.

• By entering a password.

What is an example of a parameter criteria for date range?

• Between [Enter the start date:] And [Enter the end date:]

• From [Start date] To [End date]

• Date range: [Start] - [End]

• Select dates: [Start] & [End]