CPSC 285 Database design and programming – Visual studio microsoft

Programming

This assignment should use the attached database The program should be designed so that the database is expected in the bin/debug directory of your project, wherever your project may be.

Create a form that displays information about customers. The form would display the information for one customer at a time. It should resemble the form you have been given. For the current customer the form should display:

  • Customer ID
  • Company Name
  • Contact Name
  • City
  • Phone Number
  • Number of Orders
  • Total number of detail lines
  • Total Product Cost – (Total Amount Due for Orders without freight charges)
  • Total Freight Cost for Orders
  • Total Cost (product + freight cost)
  • For each order the current customer has, the following information should be displayed in a Grid (should change when the customer changes):
    • Order ID
    • Freight Company (Carrier) Name
    • Date Shipped (Formatted like February 20)
    • Freight Cost
    • Product Cost (after taking into account the discount)
    • # of Items in the order
    • For the current order, there should be another grid that has the following information in it (should change when the user goes to a new customer or order):
      • Product ID
      • Unit Price
      • Discount %
      • Unit Price After Discount
      • Quantity
      • Total/final Price After Discount

When the user goes to a different customer/order the above should automatically change.

The form should also include the following controls:

  • Your name should be displayed in a label
  • A Print List Button. This button should create and display an Excel spreadsheet with the following information for the current customer:
    • A Title Rows (Customer Report, the Customer ID and Customer Company Name)
    • Column Headings
    • For each detail line for each order for this customer display the following information:
      • Order ID
      • Product ID
      • Quantity
      • Final Cost (after discount)
    • Total Cost (total up the fourth column)
    • Your name
    • Use an SQL query to get the data. The query should be in your program.
    • The report should be ordered by Order ID. Within an order it should be ordered by the Final Cost in descending order.
    • The sheet must be well formatted (see sample)

The program should have the following features:

  • The form must be professional looking and look like the one you have been given.
  • All dollar figures MUST be displayed as currency in the text boxes and grids.
  • All elements in the grids must be formatted as displayed.
  • The grid should have alternate rows grayed
  • Numbers must be right aligned in text boxes
  • The text boxes should be of appropriate sizes
  • You only need to display information on customers that have orders
  • Your database MUST be in the appropriate folder so that the program runs when you transfer the project to Canvas.

The input to your dataset should come from queries. Create your queries in Access. Use these queries to generate the data needed for the program.

Submit the following:

  • A printout of your program.
  • A Printout of the SQL code used for your queries
  • Screen printouts:
    • The form for customer Antonio Moreno Taquería with order # 10507
    • The form for customer Alfreds Futterkiste with his first order
    • The form with the sample given to you (Around The Horn with order # 10707)
  • A printout of the spreadsheet created by the Print List command button for:
    • Alfreds Futterkiste
    • Bottom-Dollar Markets
  • Zip and electronically submit the entire project folder to Canvas. Your folder must be called A6_LastNameFirstInitial, where LastName is your last name.
    —————
  • the database can be found here:
    https://drive.google.com/open?id=13ZjZzLQbswnxCmBX…
  • I will send you the last year solution once it’s sent to me.
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational