
Creating a Parameter Query - GCFGlobal (11)
Passage
•
Computers
•
8th Grade
•
Practice Problem
•
Easy
Debra Morgan
Used 1+ times
FREE Resource
11 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What should you enclose the phrase in when creating a prompt for a parameter query?
Parentheses ( )
Brackets [ ]
Curly braces { }
Quotation marks " "
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Where do you select the field for the variable criteria in a parameter query?
Design tab
Criteria row
Data tab
Format row
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What command do you use to run your query in the Design tab?
Start
Execute
Run
Launch
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
11 questions
ICT Department: Computational Thinking and Programming
Passage
•
7th Grade
6 questions
Isabel Ch. 17
Passage
•
8th Grade
6 questions
Drama in the UAE 1
Passage
•
8th Grade
6 questions
Compreendendo os Tipos de Predicados
Passage
•
8th Grade
8 questions
Gateway b2 u5 p43 Au 11 ( Money in the Inca empire)
Passage
•
7th Grade
6 questions
Exploring Italy: Venice, Rome, and Cinque Terre
Passage
•
7th Grade
11 questions
La sirena malvada
Passage
•
9th Grade
8 questions
Buon Samaritano
Passage
•
8th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade