Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting

Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren

23rd Edition

978-0324662962

More Books

Students also viewed these Accounting questions