State the steps you would take to execute the following query using the form: List all the African countries whose currency name is the pound and population greater than 20 millions. Order the result by country name.
Assuming that a single-row form is created on the following Country table:
Country(countryId, countryName, currencyName, continent, population)
Run the form. Press the icon Enter Query or select Enter from the Query menu;
Type colon ( : ) in any of the fields and press Execute Query icon or select Execute from the Query menu;
In the Query Where dialog box type the following expression:
currencyName = ‘pound’ AND continent = ‘Africa’ AND population > 20
ORDER BY countryName
(a) Press OK button. Scroll through the result using the arrow key.
You might also like to view...
Slots are numbered 1, 2, 3 ... or a, b, c ... on the ________
Fill in the blank(s) with correct word
In a slide using Title and Content layout, press ________ to move the insertion point from the title placeholder to the text placeholder
A) Alt + Tab B) Ctrl + Tab C) Ctrl + Enter D) Alt + Enter