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.

  1. create a data file
  2. select a data file for input
  3. display a listing of all of the data in the file
  4. 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
  5. display an exception report from the file
  6. 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:

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