VB 2008 Express edition (IDE)

 

1st Assignment:

  

Create a Visual Basic application that uses an Inventory database which contains a table of the parts in the inventory. Database inventory info is attached.The user should be able to do the following:

·        

Scroll through the data records, showing all the fields.

·         Add a new parts record, delete an existing parts record, and update an existing parts record.

·         Create a sequential file with the inventory data.

·         Display the number of active and discontinued inventory parts.

Program Requirements

·         You must center the form on the screen.

·         In addition to the database fields, for each part in the inventory you must calculate and display

o   

the gross profit (sales price – cost)

o    the total cost value of the part in the inventory (cost * quantity)

o    the total sales value of the part (sales price * quantity)

in 3 unbound control instances. These values should be updated when the current record changes.

·         Create a button and corresponding click event handler that will display a message box containing the number of discontinued inventory parts, and the number of inventory parts that are not discontinued.

·         You must use labels to make the application understandable

.

·         You must catch any arithmetic exceptions that occur during calculations and display an error message

·         You must use at least one user-defined FUNCTION and one SUB procedure.

·         You need to provide a way to exit the program gracefully.

 

2nd Assignment

    

Create a calculator application.

The user interface should consist of buttons for the digits 0 through 9, a button for each arithmetic operator, a Clear button and two label boxes to display the results. One label box should hold the current number and be located at the top of the form. The other label box should be located to the right of the calculator buttons. As you click each numeric button, the number is appended to the current number that appears in the label at the top of the form. When you click an arithmetic operator button, the current number and the operator should be appended to the display in the label at the right of the form on a new line, followed by the result of the calculation on a new line, and the contents of the current number label box should be cleared.

The application must have a menu system that allows the user to change the font and color of the label boxes, show the “About” dialog box, and gracefully exit the application.

Program Requirements·         You must center the form on the screen.

·         You must use label boxes for on-screen output.

·         You must use labels to make the application understandable·         You must catch any arithmetic exceptions that occur during calculations and display an error message

·         You must use at least one user-defined FUNCTION and one user-defined SUB procedure.

·         You must have an “About”dialog box with information about yourself.

·         You must provide a graceful exit on the menu.

.

8

00Gb.

3 false

false

4 false

false

5 false

fldPartNumber	fldPartDescription	fldCost	fldSalesPrice	fldQuantityOnHand	fldDiscontinued
1001	Disk Drive 200Gb.	9	4	5	145.95	18						false
1010	Disk Drive	3	122.84	189.95
1020	Disk Drive 400Gb.	189.44	289.95	32
1200	Cabinet	24.33	39.95
1210	Power Cord 6 foot	4.93	7.95	36
1220	Power Cord 12 foot	8.94	15.95