Sample Exam #1 ism 4212 fall 2005
Build an application in ACCESS with the following database structure:
Course ( cno, cname )
Registration ( rno , rsid, rcno, rdate )
[ rsid is a foreign key referencing student, and rcno is a foreign key referencing course. ]
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. registrations by course; 2. registrations by student; 3. students sorted by name, 4. courses sorted by name.
Include student name and course name whenever student or course 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.