Homework #1 ISM 4212 fall 2005 due via email ( wleighwleigh@yahoo.com ) by midnight 9/16.
Build an application in ACCESS with the following database structure:
Property ( pno, pname )
Lease ( lno , ltid, lpno, ldate, lbegindate, lenddate, lpaymentamount )
[ ltid is a foreign key referencing Tenant; lpno is a foreign key referencing Property. ]
Payment ( payno, paydate, payamount, paylno )
[ paylno is a foreign key referencing Lease. ]
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, 5. Payments by lease, 6. Payments by Tenant, 7. Total paid by lease, 8. Total paid by property by month.
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 midnight 9/17. Put "ISM 4212 Homeowrk 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.)