[NEW SOLN] CSIS 208 PROGRAMMING ASSIGNMENT 7

[SOLVED] CSIS 208 PROGRAMMING ASSIGNMENT 7: The database Microland.accdb is maintained by the Microland Computer Warehouse, a mail-order computer-supply company. The illustrations below show data in the Customers table and the Orders Table in the database. The table 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. The Order table provides the customer id and the item ordered.

[SOLVED] CSIS 208 PROGRAMMING ASSIGNMENT 7: The database that contains the table for this assignment is contained within your Instructions folder and should be placed in your project’s bin\debug folder.

[SOLVED] CSIS 208 PROGRAMMING ASSIGNMENT 7: **To receive any points for this assignment you must do the following:
For this assignment you will open the attached Microsoft Access file and add your name and your instructors name in the customers table using the following information:

[SOLVED] CSIS 208 PROGRAMMING ASSIGNMENT 7: You must also add the following lines to the Orders table

[SOLVED] CSIS 208 PROGRAMMING ASSIGNMENT 7:

Write a Visual Basic program that will:

1. On the form_load event, display in a listbox the customers’ names that are listed in the Customers table.
2. When the user selects a customer from the listbox,the customer’s name, street, city, and purchases should be displayed in the textboxes to the right of the buttons as illustrated below.
3. The customer and the order table are joined and the orders for the customer are displayed in the atagrid. The datagrid should have headers for the data as shown below.
4. The purchases should be formatted to be currency.
5. A Display Total Purchases should be included to sum up all of the total purchases for all names listed in the lstOutput. This information should be displayed in a message box.
6. A Clear button should be included to clear all of the textboxes and datagrid. [Note that it should not clear the listbox containing the customers’ names.]
7. A Close button should be included to exit the application.

[SOLVED] CSIS 208 PROGRAMMING ASSIGNMENT 7: As in all of your assignments, make sure that you have used appropriate programming techniques (i.e. naming of controls and variables, form has a title, tab order of controls is appropriate, textboxes used for display purposes are not writeable, internal documentation/comments are clear, formatting of any currency fields, etc.)

You May Also Like

[NEW SOLN] CSIS 208 PROGRAMMING ASSIGNMENT 1

$0.00

[SOLVED] CSIS 208 PROGRAMMING ASSIGNMENT 1: Create a Visual Basic form like the one below that allows the user to press buttons to change the background and foreground colors of the textbox and update a text box. Your form should have 3 buttons, 1 label, and 1 textbox.

By: GradeMeritsadmin

[NEW SOLN] CSIS 208 PROGRAMMING ASSIGNMENT 3

$15.99

[SOLVED] CSIS 208 PROGRAMMING ASSIGNMENT 3: Mark 16:15 He said to them, “ Go into all the world and preach the good news to all creation” It is very important to share the Word with others. One of the ways to do this is through mission trips where not only are you the hands and feet of Jesus but also you provide His Word.

By: GradeMeritsadmin

[NEW SOLN] CSIS 208 PROGRAMMING ASSIGNMENT 5

$15.99

[SOLVED] CSIS 208 PROGRAMMING ASSIGNMENT 5: In this assignment, you are to design an application, which will manage a listing of missionaries on staff at the Organization Go and Tell. The company has several specifications for this application. This application must be able to display two of the organizations files that contain the missionaries in the field and the missionaries waiting for assignment. The application must be able to sort the display.

By: GradeMeritsadmin