It’s that time of the year! The Final Project is around the corner. This sheet will help prepare you for the project. Make you sure you follow the directions and don’t hesitate to call/email me with any questions.

• Choose your partner(s), groups can be 2-3 people.
• Decide on a project you would like to develop. This project can be work-related. In the past, people have created Dental Scheduling Systems, Video Store Program, Inventory control system, Dating Service, + others.
• If possible, meet ahead a time and allocate different tasks of the project to different team members (simulate a project management environment).

Design your application with as many of the following topics as possible:

• Multiple controls on your form (including command buttons, radio buttons, text boxes, labels, etc.)
• at least 2 forms in your project
• Use multiple functions (VAL, Format, InputBox, MsgBox, etc)
• declare variables (and constants if appropriate)
• Use the selection structure and/or repitition structure appropriately (If..Then..Else and Select Case, Do While, Do Until, or For Next)
• create your own procedure/function when necessary (similar to ButtonEditAddMode or FillFields from project 6).
• provide access to a database table (use the data control/ADO and any other ActiveX data-related controls where appropriate)
• create a database using Microsoft Access, include at least two related tables (to be used with data control above)
• create a query in Microsoft Access based upon the two (or more) tables you created
• Create a Visual Basic Package to distribute the application (from Microsoft Visual studio 6.0 Tools, choose Package & Deployment Wizard)
• Use Graphics/background colors where needed.....you may want to spice up your forms!

Optional Components

• include an ActiveX Control (optional)
• include a VBScript component in your application (optional)
• if possible, include a control array (optional, chapter 7 in the book)
• include a custom menu bar with commands (optional)
• It is recommended that you 'burn' your application to a recordable cd, especially if your project contains multimedia files.  You can use the burner in OHE 540 to assist you in this task.

Important

• IMPORTANT! include Remarks in all your procedures stating the purpose and intention of the code (it can be limited to one or two lines)

• submit a 3-5 page paper (you can include this on your media you submit) discussing the format and organization of your project; include any relevant information pertaining to the design and functionality of your final project.  For example, if you have special parameters to input on your form, explain that in the paper.  Also, talk about the distribution of the work amongst your team members...who did what.