INFO200 and CMPT440, Intermediate Visual Basic

Project 1

The evaluation criteria for project 1 are timeliness and technical correctness.

In this project you will design an information system based on a sequential file. In project 2 you will modify it to use an indexed, direct [random] access file, and to use arrays to interpret encoded data. Then in project 3 you will incorporate sophisticated error handling and create a setup program.

For project 1, you must create your own information systems application, although you may use the sample program VB2Example1, available from the ftp site, as a model. Your own finished program must allow the user to do the following using Menus, CommonDialogBox, DriveListBox, DirListBox, and FileListBox.

create a data file
select a data file for input
display a listing of all of the data in the file
display a summary of the data in the file, including a count of the number of records, and a total and average of one of the numeric fields
display an exception report from the file
retrieve a specific record from the file

Either choose and modify appropriately one of the following information systems application areas, or choose something similar. Prepare about a dozen data records. Modify the given sample program to process your data file. You will need to modify the logic in some sections of the program to correspond logically with the requirements of your own application. Whatever application area you choose, each record must contain:

a unique ID, usually, but not necessarily, as the first field
at least one numeric field which can logically be used for calculating a total and an average
at least one encoded field which can be translated by the program
at least one field which can be used as a basis for retrieval
other data suitable for decisions and calculations

Customer Information	Accounts Receivable	Accounts Payable
Customer ID	Customer ID	Vendor ID
Last name	Last name	Last name
First name	First name	First name
Title	Title	Title
Address line 1	Address line 1	Address line 1
Address line 2	Address line 2	Address line 2
Address line 3	Address line 3	Address line 3
Phone	Invoice number	Invoice number
Credit category	Invoice date	Invoice date
Credit limit	Invoice amount	Invoice amount
Current credit	Discount category	Discount category
Most recent order date
E-mail address

Patient Information	Employee Information	Student Information
Patient ID	Employee ID	Student ID
Last name	Last name	Last name
First name	First name	First name
Title	Title	Title
Address line 1	Address line 1	Address line 1
Address line 2	Address line 2	Address line 2
Address line 3	Address line 3	Address line 3
Date of birth	Job title	Home phone
Home phone	Home phone	Program code
Work phone	Work phone	Tuition amount
Date service began	Employee category	Tuition owing
	Hourly rate or annual salary	Date of birth
	Date of birth	Date first registered
	Date employment began	E-mail address
	E-mail address