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

AIT Databases Revision

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?