15-16. BSN Bicycles II (Creating Queries in Access)

Business has been growing at BSN Bicycles, and the store owners have been using their Access database to store information about their customers. Now that the store is a little more established, the owners are thinking more about how best to attract more customers to their store. One idea is to see where their current customers live. The owners also want a complete list of their credit customers.

Requirements

1. If you have not already done so, database for BSN and the customer's table described inCase 15-17. Be sure to least 10 customer records for the company, including one with your name. Several of the customers should live in the states of Texas (TX) and Massachusetts (MA), and several customers should have zip code "12345." The customers in TX and MA and the customers with zip code 12345 do not have to be the same.
2. If you have not already done so, create several invoices for your customers.
3. Query that selects all customers living in TX or MA.
4. Query that selects all customers living in zip code 12345.
5. Query that selects all customers living in TX who also have zip code 12345.
6. Query that selects all credit customers. (Hint: Use the word "True" for the criteria in this query.)

Just having trouble creating these queries, thank you.