1) You can find specific data quickly and accurately by using the __________ facility. a) Query b) Design c) Create d) Form 2) Many databases are made up of __________________ (which are vertical) and rows (which are horizontal). a) colons b) columns c) clauses 3) Search for all restaurants with an average lunch price of £10 or less a) >=10 b) >10 c) <10 d) <=10 4) Search for Italian food with an average lunch price of less than £20 a) <=20 b) >20 c) <20 d) >=20 5) To specify your query, you should insert the key word into the cell labelled ________________. a) Field b) Table c) Sort d) Criteria 6) To run the query, you should click on the _________________________________. a) Save button b) red Exclamation Mark c) Create Query Design d) MS Access 7) We can sort two fields in alphabetical order by ___________________________ a) clicking ascending in the Sort box of both fields  b) clicking decending in the Sort box of both fields 8) If you must include the full name of the person, enter a) First name only b) First name and surname c) Title, first name and surname

S3 AIT Databases

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?