PRG 240 Visual Basic Programming Assignments

The Programming Process -  It is essential that you follow the Three-Step Process that you studied in PRG 140. Read Ch. 1, pp. 4 & 5 of your PRG 140 textbook carefully. You must conscientiously follow these steps in order to be successful in writing programs efficiently. Students who do not have the patience to follow the steps WILL have difficulty completing the assignments.

1. Designing the user interface. - First you must completely understand the program's specifications. Ask you instructor any questions that you have regarding the specifications. Then, draw a sketch of what the user will see on the Interface Design Form or a blank piece of paper. Indicate the names that you plan to give to the form and its objects. In addition to drawing a sketch on blank paper, use the Event Procedures Planning Form to name and organize the objects you plan to use.

2. Plan the properties. - For each object, write down the properties that you plan to set or change on an Object/Properties Planning Form.

3. Plan the Basic code. - Planning to write the code requires you first to write pseudocode on an Events Planning Form. Then, you should write the actual VB code. Finally, you will type the code into the Visual Basic software. Then, if you have any errors, you must debug the program. Finally, you must check the program by using a test plan that you developed BEFORE you wrote the code. Don't forget to make sure that internal documentation explains the algorithms in your code.


Coding Standards - Hopefully, you will become a better problem-solver throughout this course. However, even if you write programs that follow the given specifications perfectly and work to the degree that they display the proper results, you may miss points if you do not follow the Coding Standards. Read these guidelines thoroughly. If you have any questions, be sure to consult the instructor and your textbook. Take the time to check your program and code thoroughly before submitting it so that you do not lose points for violating the Coding Standards.


Requirements for all assignments:

You must submit the printout the code and form image of all VB forms included with your project at the beginning of the class period on which it is due. You must also save a copy of that project (all .frm, .vbp, .bas files) in a folder with the name of the project on a floppy disk labeled with your name and the project title. Submit the whole project in a folder or binder labeled with your name and the name of the course. I must be able to read all of the code (particularly along the left margin) on each page even if it is stapled inside a binder. Securely enclose a floppy disk containing the project files into the folder so that it will not fall out.

Be sure to include the specified header in the general declarations section of each form. The input prompts that you provide to the user should be explanatory enough that practically anyone could understand and successfully execute your program. Make sure that your program includes internal documentation that explains your algorithm.


Assignment #1:

Do Ch. 2 VB Auto Center on p. 92 of your textbook. Save the whole project in a folder named Ch2VBAuto. Make sure that you include sufficient user interface (including all prompts, labels, and message boxes) which is clear and understandable. You must also include proper internal documentation and type the code following our Coding Standards.

Specifications for Ch. 2 VB Auto Center on p. 92:

Will be filled in at a later date.


Assignment #2:

Do Ch. 3 VB Auto Center on p. 156 of your textbook.

Specifications for Ch. 3 VB Auto Center on p. 92:

Add a Customer menu to your parent form in the project from Chapter 2. Display data from the VBAuto.mdb file for customers on a child form. Use menu options or command buttons for navigation. Include the following fields on the display: Customer Number, Customer Name, Manufacturer, Model, and Year. Use DataCombo controls to display the last three fields linked by Vehicle ID. Place a command button on the form to display a report. The report should display the customer number, customer name, and Inventory ID number.

Clarifications:

???

For extra credit, make this project portable.

You must provide a well-designed user interface and you must amply document the program. Make sure that the program follows the class Coding Standards. Hand in the code for each form module stapled on top of its form image. Staple these sets (if your program had more than one form) on top of the code for the general code module (if you used one.) As described in the general requirements for all assignments above, you must submit the project in a folder with a floppy disk containing the files securely enclosed.


Assignment #3:

Do Ch. 4 VB Auto Center on p. 206 of your textbook.

Specifications for Ch. 4 VB Auto Center on p. 206:

Modify your VB Auto Center project from Ch. 3 to use a Data Environment and allow updates, including Add and Delete records. (No Modify is required.) You may validate to make sure the Customer Name is present. (Do not worry about making sure that Customer Number is numeric.) Do not allow the user to change the key field. During an Add, the only options should be Save and Cancel. Allow the user to find a specific customer by name (or partial name). Optionally, allow the user to sort by Customer Number, Customer Name, or Manufacturer. Do not worry about handling all possible program errors.

Clarifications:

You must use a Data Environment instead of ADO data controls in this project. Do not worry about the report displaying properly in this project.


Assignment #4:

Do Ch. 5 VB Auto Center #1 on p. 248 of your textbook.

Specifications for Ch. 5 VB Auto Center #1 on p. 248:

Remove the Data Environment form your Chapter 4 project. Make the code work using the ADO object model.

Clarifications:

Only the Customer form is necessary in this project. Remember to delete the Data Source properties of the bound controls.