Discount Get BMIS 208 ALL WEEKS Solution ONLY $157.01 $237.89
BMIS 208 Assignment 1 Week 1 - Create a Visual Basic form like th... [$15.99]
BMIS 208 Assignment 2 Week 2 - Create a Visual Basic program that... [$19.99]
BMIS 208 Assignment 3 Week 2 - Create a Visual Basic program to a... [$19.99]
BMIS 208 Assignment 4 Week 3 - A furniture manufacturer makes two... [$19.99]
BMIS 208 Assignment 5 Week 3 - For tax purposes, an item may be d... [$19.99]
BMIS 208 Assignment 5 Week 3 Caffeine Absorption - Write a progra... [$19.99]
BMIS 208 Assignment 6 Week 4 - Visual Basic program that displays... [$19.99]
BMIS 208 Assignment 7 Week 5 - Write a Visual Basic program to cr... [$19.99]
BMIS 208 Assignment 8 Week 6 - Write a menu-driven multiform inve... [$25.99]
BMIS 208 Assignment 9 Week 7 - The database Microland.accdb is ma... [$29.99]
BMIS 208 Assignment 10 Week 8 - Write a Visual Basic program to i... [$15.99]
BMIS 208 Course Project - CMS Systems, Inc. is a company that pro... [$29.99]
BMIS 208 Final Class Project - Grading System [$35.99]
Get Selected Weeks Solution with ONLY NOT Add Selected Tutorials To Cart
BMIS208 BMIS/208 BMIS 208 - Programming Assignment 9 - Week 7 - The database Microland.accdb is maintained by the Microland Computer Warehouse
    BMIS208 BMIS/208 BMIS 208 - Programming Assignment 9 - Week 7 - The database Microland.accdb is maintained by the Microland Computer Warehouse BMIS208 BMIS/208 BMIS 208 - Programming Assignment 9 - Week 7 - The database Microland.accdb is maintained by the Microland Computer Warehouse BMIS208 BMIS/208 BMIS 208 - Programming Assignment 9 - Week 7 - The database Microland.accdb is maintained by the Microland Computer Warehouse

BMIS208 BMIS/208 BMIS 208 - Programming Assignment 9 - Week 7 - The database Microland.accdb is maintained by the Microland Computer Warehouse

$29.99

The database Microland.accdb is maintained by the Microland Computer Warehouse, a mail-order computer-supply company. The tables below show data in the three tables in the database. The table Customers identifies each customer by an ID number and gives, in addition to the name and address, the total amount of purchases during the current year prior to today. The table Inventory identifies each product in stock by an ID number and gives, in addition to its description and price (per unit), the quantity in stock at the beginning of the day. The table Orders gives the orders received today. Assume that it is now the end of the day. Write a Visual Basic program that uses the three tables to do the following two tasks:

  1. Display in a listbox the items that are out of stock and those that must be reordered to satisfy today’s orders.
  2. Display in a listbox bills for all customers who ordered during the day. Each bill should show the customer’s name, address, items ordered (with costs), and total cost of the order.

Design your form based on the diagram below.

The database that contains the tables for this assignment is contained within your Instructions folder and should be placed in your project’s bin\debug folder.
Below are the data that are contained in the tables in the database.
(Note: you do not have to reproduce these tables in your Visual Basic program. You should only create the screens shown above.)

 Hints – the hints below are for the “Out of Stock” button function and will hopefully give you some clues as to how you can accomplish the other button’s work.

  1. Create a query1 from the order table to get the itemIDs ordered. You will want to order your query by itemID and use Distinct to eliminate duplicate itemIDs.
  2. Use a for-each loop to go through query1 once per itemID. For each loop you want to do the following:
    1. Create a query2 using the order table Where the itemID in the order table equals the itemID from query1. The purpose of this query is to get the quantities ordered for each itemID.
    2. Use a for-each loop and a variable (let’s call it intTotalOrdered) to iterate through query2 and sum up the quantities ordered for each itemID.
    3. Create a query3 using the inventory table and select those records Where the intTotalOrdered is equal to or greater than the quantity on hand – these are the records that will need to be reordered. Use a Let statement with quantity on hand and intTotalOrdered to determine the reorder quantity. Select the itemID, reorder quantity, and item description.
    4. Print out itemID, reorder quantity, and item description to your list box. Use Math.Abs() on your reorder quantity to convert negative numbers to positive ones.

My tutorial contains Visual Basic Project (using Visual Studio).

If you have more questions, please contact me via email support@extutorials.com

I will help you any time

Thank you !

 

Attached Files

Move over [ preview ] file name to preview content in it!

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad           Good

Enter the code in the box below:



PURCHASE SAVE
2 Tutorials 10%
3 Tutorials 13%
4 Tutorials 16%
5 Tutorials 19%
6 Tutorials 22%
7 Tutorials 25%
8 Tutorials 28%
9 Tutorials 31%
10 Tutorials 34%
add url more

9MZQASHWN73B