CIS 671, Winter 2002
Homework 2: Report Writing and Form Generation with MS Access Report Writer and Forms

1. Using the Airline database in Sybase write an MS Access Report program to produce a report showing the legs of all the flights. Include the names of the cities involved. Format the report "nicely". Put your name in the title of the report.

2. Using the Airline database in Sybase write an MS Access Forms program to produce an "interesting" form of your choice. Include your name somewhere in the form.

Call your database ``hw2.mdb'' and submit it to ``hw2''. See the tutorial on the MS Access Report Writer and the tutorials on MS Access Forms available from the course web page. Also see the instructions on how to connect MS Access to Sybase.

Since Access just adds information to your mdb file, you should compact your mdb file before submitting it.
        Tools
                Database Utilities
                        Compact and Repair Database ...