Database Queries

Last week you created an Access database with a single table and did a few queries. This week, I want you to continue querying the database. If the data in the database does not give you meaningful results when you do your queries, then you should add some records to the table. Please include the number of the query when you name the query.

  1. Do a query where you only show some of the fields. This query should show all of the records but just the fields you decide to show.
  2. Do a query that only shows some of the fields and where there is one criteria. This would be like testing for state of MA.
  3. Do a query that shows all of the fields and set up three criteria all in an AND relationship.
  4. Do a query that shows all of the fields and set up two criteria in an OR relationship.
  5. Do a query where either two criteria are true OR where one criteria is true. For example code1 is A and amt is > 100 or just code2 is B.
  6. Do a query where one thing has to be true and also either of two other things has to be true.
  7. Do a query where you are testing for three things to be true or you are testing for two different things to be true.
  8. Do a query where you test one field for two different criteria. For example state is MA or state is RI.