Assignment #1 Begin to build the Contact Management System. a. PART I: Create a Microsoft Access database with the following fields: ID Number Date Added Last Name First Name and Middle Initial Address (2 lines) City State ZIP Code Telephone Number 1 Telephone Number 2 Fax Number E-mail Address b. Index the database on the ID Number and Last Name + First Name, so that the database can be searched by ID or Name. c. Write a Visual Basic program that can add, update, and delete records in the Microsoft Access database. d. Enter 10 different records. Assignment #2 PART II: Add the following fields: Lead Source ??" include in table Next appointment (time, day of week, date, place, purpose) ??" Second table with appointments (This is a separate class) A notes area Pick state’s two-letter abbreviation from list of states. Pick lead source from a list (radio, TV, magazine ad, 1-800, etc.). (How did you get this source? List box with at least 6 leads max of 8) Print a report by date or range of dates with the following detail: Name Next appointment (time, day of week, date, place, purpose). 2. Add a menu Assignment #3 Add the following functionality to the Contact Management System from Assignment 2: PART III: Do not allow overlapping appointments. Allow searching by Name or Next Appointment Date. Update menu. Include any suggestions from group activity in Workshop Three that were assigned. Assignment #4 Finalize the Contact Management System. PART IV: Adding notes using a text file in appointment table as a linked file. Enter ZIP codes and bring up City and State (use a database of 20 possible ZIP codes). No hard coding Add a calculator and a calendar. Use windows [url removed, login to view] and [url removed, login to view] via menu command Update menu. *Additional Requirements - See attached word document. Contains a better desciption and due dates.
1) Complete and fully-functional working program(s) in executable form as well as complete source code (comments within code) documented of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4)Max price can be negotiated if to low. This is suposed to be a very simple application.
Windows 98, 2000, and XP