CSC 430  - Database Project - Prof. Domanski

Build a small database for simple maintenance of a phone book:

Assume you download the phone directory database first ; it contains only 2 columns in 1 table called Phone and Name respectively.

What functions you need to design & build:

• Search by Name

• Search by Phone #

• Adding a new person & phone #

• Deleting the current name/phone record displayed

• Updating either the name or phone # displayed for the record displayed

• A simple menu-ing system that provides these functions without having to use a mouse

• Ending the program (quit)

• An about box to give you credit for writing it.

What you likely need to understand:

• ADO data control (ActiveX Data Control)

  • Connection String

  • RecordSource

• Binding Textboxes to the Data Control

  • DataSource

  • DataField

• Hierarchical FlexGrid Control

  • flexResizeColumns

  • DataSource

• Simple SQL for Select

• Recordset Methods

  • .MoveFirst

  • .MoveLast

  • .MoveNext

  • .Update

  • .AddNew

  • .Delete

Extra Credit: If you can get the textbox for the phone number to be formatted for  display purposes and still be used to input a phone number without the formatting characters.

Due: 3 weeks.  Test plan, Design document, and code should be ready for demonstration in front of the class.

Created and maintained by DrB
Last Updated on Wednesday, February 18, 2009