Preview

07 - Designing queries (simple)

 1. Click the _______________ to create a query in Design view. You could also use the Query Wizard button next to it to launch the Query Wizard, however, Design view gives you more control over the query.
creating_queries_in_access_beginner1.png

  redirect button

  Query Design button

  Table Design button

  Form button

 2. The Show Table dialog allows you to choose ___________ to include in the query. You can also include other queries to use within a query.
creating_queries_in_access_beginner2.png

  which forms

  which fields

  which tables

  which data elements

 3. Searching a database of North Carolina counties by using the statement, “all counties with a population of greater than two million” will include:

  Counties with exactly two million people

  Counties with less than two million

  Counties with more than two million

  Counties with two million or more

 4. How would you find the phone number of one student from 500 names and addresses of students enrolled at your school?

  Perform a search of all boys in the database

  Sort the database in descending order

  Sort the database and scroll all records

  Perform a search using the student’s name as the criteria

 5. Query Design View allows you to specify the _____________ for the query. You can choose which tables are shown in the results, which fields to use, add filtering criteria, and more.
creating_queries_in_access_beginner3.png

  precise criteria

  exact forms

  forms used

  reports used

 6. Clicking the Run button will __________. Clicking the Datasheet view button next to it will also ______________.
creating_queries_in_access_beginner4.png

  delete the query

  run the query

  find the table specified

  create an alert so that the query does not overwrite itself

 7. You can ________________________ to modify your query. Design view allows you to specify the exact criteria for your query.

  go back and forth between Datasheet view and Design view

  click the delete query or edit query button

  click the run or datasheet button

  delete all tables in order

 8. What does this particular query do?
go back and forth between Datasheet view and Design view.png

  Filter the results to only those with a price over a certain amount (80000)

  Ensure that at least 80000 records are displayed on running the query

  Filter the results to show only the first 80000 results in the table

  Ensure that the query does not exceed a time limit of 80000 seconds

 9. What does this particular query with Is Null criteria do?
Isnull_query_whatdoesitdo.jpg

  Returns all the NULL, that is empty records, or empty lines in the database tables

  Returns all the records in the table which do not have a Customer ID

  Returns all the tables in the database that have a Customer ID that is equal to NULL (which is an ID itself)

  Returns all the Customer IDs in the table that start with 0

 10. This query will return a list of all the records that contain the city Melbourne that are NOT of the Hotel accomodation type. Only one criteria can be used in a query.
airbandb_beginner_query.png

  TRUE

  FALSE


Report an error