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

  Form button

  redirect button

  Table Design button

  Query Design 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 tables

  which data elements

  which forms

  which fields

 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 less than two million

  Counties with two million or more

  Counties with exactly two million people

  Counties with more than two million

 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 using the student’s name as the criteria

  Perform a search of all boys in the database

  Sort the database and scroll all records

  Sort the database in descending order

 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

  exact forms

  reports used

  precise criteria

  forms used

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

  find the table specified

  delete the query

  run the query

  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.

  delete all tables in order

  click the delete query or edit query button

  click the run or datasheet button

  go back and forth between Datasheet view and Design view

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

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

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

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

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

 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 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

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

 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

  FALSE

  TRUE


Report an error