Have an account?
Skip to Content
Build your own quiz
Suggestions for you
.png)
14 questions
Show Answers
See Preview
- 1. Multiple Choice
What Query view is shown in this image?Datasheet ViewDesign View - 2. Multiple ChoiceWhat Query view is shown in this image?Datasheet ViewDesign View
- 3. Multiple ChoiceWhat is letter "A" showing?Where to configure the Join propertiesWhere to Run the queryWhere to configure which fields and criteria are used for the Query
- 4. Multiple ChoiceWhat is letter "B" showing?Where to click to Run the QueryWhere to Configure the Fields returned and criteria to be usedWhere to click to configure the Join propertiesWhere to click to Save this Query
- 5. Multiple ChoiceWhat is letter "C" showing?Where to click to Run the QueryWhere to Click to Save the QueryWhere to configure the Fields returned and the criteria to be usedWhere to configure the Join properties
- 6. Multiple ChoiceA _______ query displays a dialog box that prompts the user to enter criteria when the query is run.Top ValuesPattern MatchList of ValuesParameter
- 7. Multiple ChoiceA query can get its data froma. one or more tables.b. existing queries.c. a combination of a and b.d. all of the above.
- 8. Multiple ChoiceWhich Boolean operator will narrow your resultsANDORNOTBUT
- 9. Multiple ChoiceWhich Boolean operator will expand your resultsANDORNOTBUT
- 10. Multiple ChoiceA football team keeps a database about its players. Which query would allow them to produce a query showing players who are strikers and who have scored 20 goals or more?Position = "Striker" OR Goals = 20Position = "Striker" AND Goals = 20Position = "Striker" or Goals >=20Position = "Striker" AND Goals >= 20
- 11. Multiple Choice8. Sorting from A-Z is also called a descending sort.TrueFalse
- 12. Multiple ChoiceWildcard that represents any collection of charactersAsteriskQuestion MarkQueryEqual Sign
- 13. Multiple ChoiceA teacher keeps pupil test results in a database. Each pupil has sat multiple tests. The teacher wants to run a query that shows each student and the average score they have achieved across the year. What would be the correct query to use:Parameter QueryGroupByWildcardSelection
- 14. Multiple ChoiceA bookshop owner is using the shop's database to help a customer. The customer is looking for a particular author but cannot remember their full name. The customer remembers that the surname of the author starts with the letters "Co". What kind of query could the bookshop owner use to find this information?ParameterGroupByWildcardSelection
- Answer choicesTagsAnswer choicesTags