Exam #1 ISM 4212 fall 2005 9/5/2005
Build an application in ACCESS with the following database structure:
Property ( pno, pname )
Lease ( lno , ltid, lpno, ldate, lbegindate, lenddate )
[ ltid is a foreign key referencing Tenant; lpno is a foreign key referencing Property. ]
Provide forms for data entry into each table. Have dropdown combo boxes for all foreign key attributes. Provide a main menu form.
Provide reports: 1. Leases by Property; 2. Leases by Tenant; 3. Tenants sorted by name, 4. Properties sorted by name.
Include Tenant and Property name whenever Tenant or Property data appears on a report.
Build reports with SQL select statements as input to the report writer.
Use create table statements for all tables. Define primary keys and foreign keys in the SQL.
Save all SQL statements (create table and select) as queries.
Provide at least 10 rows of test data for each table.
Use captions to have user-friendly field names on all reports and forms.
Email the ACCESS mdb file to wleighwleigh@yahoo.com by noon. Put "ISM 4212 Test 1" and your name in the subject line of the email. (Use of the Yahoo mail account should avoid security screening problems with the university.)