Answered step by step
Verified Expert Solution
Question
1 Approved Answer
15-16. BSI'iI Bicycles ll {Creating ueries in Access} Business has been growing at BEN Bicycles, and the store owners have been using their Access database
15-16. BSI'iI Bicycles ll {Creating ueries in Access} Business has been growing at BEN 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. It" you have not already done so, create a database [or BEN and the customer's table described in Case 15-17. Be sure to create at least it] customer records for the company, including one with your name. Several of the customers should live in the states of Texas (TI-Z) and Massachusetts {MA}. and several Customers should have zip code "12545." The customers in TX and MP. and the customers with zip code 12345 do not have to be the same. . It' you have not already done so, create several invoices for your customers. . Create a query that selects all customers living in TX or MA. . Create a query that selects all customers living in zip code 12545. . Create a query that selects all customers living in TX who also have zip code 12545. EWQ'UN . Create a query that selects all credit customers. (Hint: Use the word "Yes" for the criteria in this query.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started