Expert Answer:CPSC 285 Database design and programming – Visual

  

Solved by verified expert: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 IDCompany Name Contact NameCityPhone Number Number of Orders Total number of detail linesTotal 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 IDFreight Company (Carrier) Name Date Shipped (Formatted like February 20)Freight CostProduct Cost (after taking into account the discount)# of Items in the orderFor 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 IDUnit PriceDiscount %Unit Price After DiscountQuantityTotal/final Price After DiscountWhen 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 labelA 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 HeadingsFor each detail line for each order for this customer display the following information:Order IDProduct IDQuantityFinal Cost (after discount)Total Cost (total up the fourth column)Your nameUse 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 grayedNumbers must be right aligned in text boxesThe text boxes should be of appropriate sizesYou only need to display information on customers that have ordersYour 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 queriesScreen printouts:The form for customer Antonio Moreno Taquería with order # 10507The form for customer Alfreds Futterkiste with his first orderThe 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 FutterkisteBottom-Dollar MarketsZip 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.
assignment_6___dot_net_with_sql_views.docx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Expert Answer:CPSC 285 Database design and programming – Visual
Just from $10/Page
Order Essay

CPSC 285 – DATABASE DESIGN & PROGRAMMING
Spring 2019
Assignment 6
Date: 02-20-19
Due On: 03-13-19
This assignment should use the NorthWind Small database that is saved on the shared (S) drive
and on Canvas. 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:
1) Customer ID
2) Company Name
3) Contact Name
4) City
5) Phone Number
6) Number of Orders
7) Total number of detail lines
8) Total Product Cost – (Total Amount Due for Orders without freight charges)
9) Total Freight Cost for Orders
10) Total Cost (product + freight cost)
11) For each order the current customer has, the following information should be displayed in a
Grid (should change when the customer changes):
a) Order ID
b) Freight Company (Carrier) Name
c) Date Shipped (Formatted like February 20)
d) Freight Cost
e) Product Cost (after taking into account the discount)
f) # of Items in the order
g) 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):
i) Product ID
ii) Unit Price
iii) Discount %
iv) Unit Price After Discount
v) Quantity
vi) 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:
1) Your name should be displayed in a label
CPSC 285 – Spring 2019 – Assignment 6
Page 1 of 4
2) A Print List Button. This button should create and display an Excel spreadsheet with the
following information for the current customer:
a) A Title Rows (Customer Report, the Customer ID and Customer Company Name)
b) Column Headings
c) For each detail line for each order for this customer display the following information:
i) Order ID
ii) Product ID
iii) Quantity
iv) Final Cost (after discount)
d) Total Cost (total up the fourth column)
e) Your name
f) Use an SQL query to get the data. The query should be in your program.
g) The report should be ordered by Order ID. Within an order it should be ordered by the
Final Cost in descending order.
h) 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:
1) A printout of your program.
2) A Printout of the SQL code used for your queries
3) Screen printouts:
a) The form for customer Antonio Moreno Taquería with order # 10507
b) The form for customer Alfreds Futterkiste with his first order
c) The form with the sample given to you (Around The Horn with order # 10707)
4) A printout of the spreadsheet created by the Print List command button for:
a) Alfreds Futterkiste
b) Bottom-Dollar Markets
5) Zip and electronically submit the entire project folder to Canvas. Your folder must be called
A6_LastNameFirstInitial, where LastName is your last name.
CPSC 285 – Spring 2019 – Assignment 6
Page 2 of 4
NorthWind Small.mdb Database
Table: Customers
Name
CustomerID
CompanyName
ContactName
ContactTitle
Address
City
Region
PostalCode
Country
Phone
Fax
Type
Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
Size
5
40
30
30
60
15
15
10
15
24
24
Type
Long Integer
Text
Long Integer
Date/Time
Date/Time
Date/Time
Long Integer
Currency
Text
Text
Text
Text
Text
Text
Size
4
5
4
8
8
8
4
8
40
60
15
15
10
15
Type
Long Integer
Long Integer
Currency
Integer
Single
Size
4
4
8
2
4
Type
Long Integer
Text
Text
Size
4
40
24
Table: Orders
Name
OrderID
CustomerID
EmployeeID
OrderDate
RequiredDate
ShippedDate
ShipVia
Freight
ShipName
ShipAddress
ShipCity
ShipRegion
ShipPostalCode
ShipCountry
Table: Order Details
Name
OrderID
ProductID
UnitPrice
Quantity
Discount
Table: Shippers
Name
ShipperID
CompanyName
Phone
CPSC 285 – Spring 2019 – Assignment 6
Page 3 of 4
Sample Form
CPSC 285 – Spring 2019 – Assignment 6
Page 4 of 4

Purchase answer to see full
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP