A client has asked for an application that will manage information about presidents. They have a database containing their data, but have contracted with you to develop the user interface, and necessary reports.
I will provide the text file, and that text file will contain the following information:
Each presidential record contains the following data:
• Number of the presidential term
• First name(s) and last name of the president
• Birth year
• Death year (empty if still alive)
• Political party (separated by slash if more than one)
• First year of term
• Last year of term (note terms vary from one year to many)
• Vice president(s) (separated by slash if more than one, can be empty, runs to end of line)
The initial data delivery is in the form of a comma-delimited file with one line containing a complete record above, each field separated by a comma. The president listing are in chronological order.
This assignment contains several parts:
1. Design a main form with proper navigation. It should contain a window for displaying a report (text box with the multiline property set to true is fine here). It should allow for the selection of which report to run, and provide for a way to run the selected report. I need A and F in this report from the list below, but the design should allow for the addition of other reports in the future. This main form should also contain a method to navigate to the data maintenance form.
2. Design a data maintenance form that allows users to view, edit, insert and delete entries about presidents. This form should contain controls displaying each data value about presidents. This form should contain navigation buttons to advance one record, back up one record, advance to the last record, move to the first record.
List of Possible reports
A. List, alphabetically, all presidents alive in 1920
B. What is the average age of a president in their first term?
C. What is the average number of years deceased presidents live after their last term?
D. List all president’s that also served as vice president
E. What is the number of presidents in each political party?
F. Which presidents might have served in the civil war (over 13 Years old, 1861 to 1865)
G. List the 5 longest lived presidents, and their age
H. List all vice presidents in alphabetical order
I. list the 10 youngest presidents
J. list the presidents by their age at death