Have an account?
Skip to Content
14 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any questions.
What Query view is shown in this image?Datasheet ViewDesign View - Multiple ChoicePlease save your changes before editing any questions.What Query view is shown in this image?Datasheet ViewDesign View
- Multiple ChoicePlease save your changes before editing any questions.What 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
- Multiple ChoicePlease save your changes before editing any questions.What 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
- Multiple ChoicePlease save your changes before editing any questions.What 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
- Multiple ChoicePlease save your changes before editing any questions.A _______ query displays a dialog box that prompts the user to enter criteria when the query is run.Top ValuesPattern MatchList of ValuesParameter
- Multiple ChoicePlease save your changes before editing any questions.A 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.
- Multiple ChoicePlease save your changes before editing any questions.Which Boolean operator will narrow your resultsANDORNOTBUT
- Multiple ChoicePlease save your changes before editing any questions.Which Boolean operator will expand your resultsANDORNOTBUT
- Multiple ChoicePlease save your changes before editing any questions.A 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
- Multiple ChoicePlease save your changes before editing any questions.8. Sorting from A-Z is also called a descending sort.TrueFalse
- Multiple ChoicePlease save your changes before editing any questions.Wildcard that represents any collection of charactersAsteriskQuestion MarkQueryEqual Sign
- Multiple ChoicePlease save your changes before editing any questions.A 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
- Multiple ChoicePlease save your changes before editing any questions.A 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