Implement a relational database

Assignment Help Accounting Basics
Reference no: EM13756010

The Beach Dude (BD) employs a legion of current and former surfers as salespeople who push its surfing-oriented products to various customers (usually retail outlets). This case describes BD's sales and collection process.

Each BD salesperson works with a specific group of customers throughout the year. In fact, they often surf with their customers to try out the latest surf gear. The BD salespeople act laid-back, but they work hard for their sales. Each sale often involves hours of surfing with their customers while the customers sample all the latest surf wear. Since BD makes the best surfing products, the customers look forward to the visits from the BD salespeople. And, they often buy a lot of gear. Each sale is identified by unique invoice# and usually involves many different products. Customers pay for each sale in full within 30 days, but they can combine payments for multiple sales.

BD manages their clothing inventory by item (e.g., XL BD surfer logo t-shirts), identified by product #, but it also classifies the items by clothing line (the lines are differentiated by price points as well as the intended use of the clothing, e.g., surfing products, casual wear, etc.).

a. Draw a business process model that describes the Beach Dudes sales and collection process.  Use either Powerpoint, Visio, or Word.  Your model should be similar to Figure 8.5 in the Perry and Newmark Access book (page 327). You can insert your diagram on the following page.

b. Using Microsoft Access, implement a relational database from your model.  Identify at least 3 fields per table.   Your database should have tables, forms and at least one query.  Please submit your Access files to the final exam folder.

Reference no: EM13756010

Questions Cloud

Create a software requirement specification : A detailed description of both user and system requirements. At least four (4) user requirements and four (4) system requirements should be provided.
Journal entry to record the issuance of the bonds : Prepare the journal entry to record the issuance of the bonds on July 1, 2011. Prepare an amortization table through December 31, 2012 (3 interest periods) for this bond issue.
How do they relate to the practice of accounting : How do they relate to the practice of accounting and its uses in business?
How would you respond to and rebut views : Your task is to take the other side of the debate: How would you respond to and rebut this view? In the first chapter of Living with Art, Getlein lists six roles.
Implement a relational database : Using Microsoft Access, implement a relational database from your model.  Identify at least 3 fields per table.   Your database should have tables, forms and at least one query.  Please submit your Access files to the final exam folder.
Write application to retrieve the telephone number : Consider a program to enter codes of one to eight characters along with an associated telephone number and associated notes. A code can represent a person's name, a person's initials, a place, or anything.
Describe how the influence of the west changed : Describe how the influence of the West changed with regards to economic, political, and cultural influence.
What types of licensure and accreditation do they have : Identify a facility in your area (Maryland preferred) by looking on the Internet. What types of licensure and accreditation do they have? Do they provide ambulatory care or acute care? Did your findings surprise you
Disapprove of dobbs manner of deciding : Do you approve or disapprove of Dobbs's manner of deciding when to ship goods to customers and record the sales revenue? If you approve, give your reason. If you disapprove, identify a better way to decide when to ship goods. Is there an accountin..

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Baldwin corp began the year with cash of 35000 and a

baldwin corp. began the year with cash of 35000 and a computer that cost 20000. during the year baldwin earned sales

  What is the balance in cash

During February 2008, its first month of operations, the Rutwing Enterprises issued stock in exchange for cash of $25,000. Rutwing had cash revenues of $4,000 and paid expenses of $7,000. Assuming no other transactions impacted the cash account, w..

  What should the company establish as the sales price per

what should the company establish as the sales price per unit if it sets a target of earning an operating income of

  Each of the following statements may or may not describe

listed below are nine technical accounting termscost volume profit analysiscontribution margin ratio variable cost

  Present journal entries to record the following selected

present journal entries to record the following selected transactions of masterson corporationpurchased 600 shares of

  Prepare the liabilities section of pedricks balance sheet

Identify which of the above liabilities are likely current and which are likely longterm. Say if an item fits in neither category. Explain the reasoning for your selection.

  Kyle inc has collected the following data on one of its

kyle inc. has collected the following data on one of its products direct materials standard 4 per finished unit total

  Felon company expects a total of 20000 sales in june of

felon company expects a total of 20000 sales in june. of these credit sales are expected to be 12000. collections are

  Igloo inc owns 30 of jack co and applies the equity method

igloo inc. owns 30 of jack co. and applies the equity method. during the current year igloo bought inventory costing

  Shares in raven products are selling for 90 per share there

shares in raven products are selling for 90 per share. there are 1 million shares outstanding. what will be the share

  Long-term debt in the capital structure

Preferred stock is used much less than long-term debt in the capital structure of most industrial and merchandising companies principally because

  What is the purpose of cafr what are the components of

what is the purpose of cafr? what are the components of cafr? why is the federal government not subject to gasb 34? how

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd