BMIS 208 Programming Assignment 9 Microland Computer
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 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.
Write a Visual Basic program that will:
a. On the form_load event, display in a listbox the customers’ names that are listed in the Customers table.
b. When the user selects a customer from the listbox and clicks the button to “Show Customer Information”, the customer’s name, street, city, and purchases should be displayed in the textboxes to the right of the buttons as illustrated below.
c. A Clear button should be included to clear all of the textboxes. [Note that it should not clear the listbox containing the customers’ names.]
d. A Close button should be included to exit the application.
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.)
Design your form based on the diagram below.
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.
Below are the data that are contained in the table in the database.
(Note: You do not have to display this table in your Visual Basic program. You should only create the screen shown above using the data in this table.)