Business has been growing at BSN Bicycles, and the store

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, create a database for BSN and the customer’s table described in Case 4–25 in Chapter 4. Be sure to create at least 10 customer records for the company, including one with your name. Several of the customers should also live in the state of Virginia (VA) and several customers should have zip code ‘‘12345.’’ The

Virginia customers 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. Create a query that selects all customers living in Virginia. Print your results.

4. Create a query that selects all customers living in zip code 12345. Print your results.

5. Create a query that selects all customers living in Virginia who also have zip code 12345. Print your results.

6. Create a query that selects all credit customers. (Hint: use the word ‘‘Yes’’ for the criteria in this query.) Print your results.


Members

  • Access to 2 Million+ Textbook solutions
  • Ask any question from 24/7 available
    Tutors
$9.99
VIEW SOLUTION

OR

Non-Members

Get help from Accounting Tutors
Ask questions directly from Qualified Online Accounting Tutors .
Best for online homework assistance.