View the step-by-step solution to:

MBA 6400: MS Access Assignment (Due before class in week 7) Problem Overview: Scenario: You have been asked to create an application to support the...

This is for an information management class. Please see attached assingment and datafile. Thank you.

MBA 6400: MS Access Assignment (Due before class in week 7)
Background image of page 1
Problem Overview: Scenario: You have been asked to create an application to support the sales and marketing  functions of a company that manufactures and sells edible arrangements. As part of that application, you will create a Microsoft Access database that will support recording sales transactions. As a proof of concept, you will create some sample forms and queries that will demonstrate how  this application might function as a decision support system for the Sales and Marketing  Departments.  Step 1: Create Tables Using MS Access, create a product table, a customer table, and an order according to the  following specifications.  Use the names, datatypes, and descriptions as indicated.  (Hint: If  you have questions about specific fields, look at the data that is going to be entered into the  tables.) Product Table Attribute Name Data Type Description prodno Number  The primary key - used to uniquely  identify each product desc Text Product name or description  price Currency Current price of the product   Customer Table (continues on next page) Attribute Name Data Type Description custno Number  The primary key - a unique customer  number to identify each customer cust name text Customer' s name - including first and  last name addr text Customer's street address
Background image of page 2
Show entire document
AUTHOR (There is NO Author number 9, skip it) Author Number Author Name 1Archer Jeffrey 2Christie Agatha 3Clarke Arthur C. 4Francis Dick 5Cussler Clive 6King Stephen 7Pratt Philip 8Adamski Joseph 10Harmon Willis 11Rheingold Howard 12Owen Barbara 13Williams Peter 14Kafka Franz 15Novalis 16Lovecraft H. P. 17Paz Octavio 18Camus Albert 19Caslteman Riva 20Zinbardo Philip 21Gimferrer Pere 22Southwort Rod 23Wray Robert BOOK
Background image of page 1
Book Code Book Title Publisher Code Book Type Book Price Paper back? 0180 Shyness BB ART $7.65Yes 0189 Kane and Abel PB FIC $5.55Yes 0200 The Stranger BB FIC $8.75Yes 0378 The Dunwich Horror and Others PB HOR $19.75No 079X Smoke-Screen PB MYS $4.55Yes 0808 Knockdown PB MYS $4.75Yes 1351 Cujo SI HOR $6.65Yes 1382 Marcel Duchamp PB ART $11.25Yes 138X Death of the Nile BB MYS $3.95Yes 2226 Ghost from the Grand Banks BB SFI $19.95No 2281 Prints of the 20th Century PB ART $13.25Yes 2766 The Prodigal Daughter PB FIC $5.45Yes 2908 Hymns to the Night BB POE $6.75Yes 3350 Higher Creativity PB PSY $9.75Yes 3743 First Among Equals PB FIC $3.95Yes 3906 Vortex BB SUS $5.45Yes 5163 The Organ SI MUS $16.95Yes 5790 Database Systems BF CS $54.95No 6128 Evil Under the Sun PB MYS $4.45Yes 6328 Vixen 07 BB SUS $5.55Yes 669X A Guide to SQL BF CS $23.95Yes 6908 DOS Essentials BF CS $20.50Yes 7405 Night Probe BB SUS $5.65Yes 7443 Carrie SI HOR $6.75Yes 7559 Risk PB MYS $3.95Yes 7947 dBASE Programming BF CS $39.90Yes 8092 Magritte SI ART $21.95No 8720 The Castle BB FIC $12.15Yes 9611 Amerika BB FIC $10.95Yes INVENT
Background image of page 2
Show entire document

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question