To Homework

ISP 121 -- Final Project Part 2

Underpants To Go retail chain

Reference: Final Project Part 1   Captain Underpants logo.

Part 2 of your Final Project continues the development of the Underpants-To-Go database you started in
Part 1. You will create a switchboard. The Data Entry form referenced in the switchboard is the form you created in Part 1. All other objects that are referenced on the switchboard need to be created. Therefore, before you create the switchboard, proceed as follows:

1. Open the Relationships window, pull down the File menu, click the Print Relationships command, and then view the completed report in Design view. Modify the report to include your name and the Captain Underpants logo. Here's an example: Relationships report.

2. Two additional reports are required: the Master Stores report and the Leading Stores List. I'll leave the design and exact content of each report to you, but try to achieve a uniform look (design) for all your reports. Use the company logo on all reports. For the Leading Stores, you'll need to create a query and then base the report on that query. In query design view look for the little text box (up in the menu bar) that says All. Drop it down and choose 5.  Sort (decsending) by AnnualSales.
   Here's a sample Master Stores report.

3. Create a splash screen. This is a form that will open and display automatically when the database is opened.

4. Use the Switchboard Manager to create the switchboard. You do not have to match my design exactly, but you are required to have all of the menu options. The design of the switchboard should be consistent with all other database objects.
   • Functionality. When the database is opened, the splash screen displays for 4 or 5 seconds and then closes. Immediately after the splash screen closes the switchboard automatically opens. The switchboard remains open until the user presses the Exit button.
   • Implementing Functionality.
     1. The splash screen. Under Macros, create an AutoExec macro. Be sure you name the macro AutoExec. For the Action, chose OpenForm. In the Action Arguments pane, the View should be Form and the Form Name whatever you called the form.
     2. To open the switchboard when the splash screen closes, we need another macro. Create a macro in design view. Action: OpenForm, Form Name: Switchboard, View: Form. Now close and name your macro.
     3. To close the splash screen, create a third macro. Actiion: Close, Object Type: Form, Object Name: whatever you named your splash screen form.
     4. To coordinate all the opening and closing of forms, you will need to have the correct event handlers activated. Go to your splash form and open it in Design view. Drop down the Properties list for the form. The On Close Event should be set to whatever you called the macro that opened the switchboard. To get your splash form to close after four seconds, you need to
        • have the On Timer Event set to whatever you called your macro that closes the splash form, and
        • have the Timer Interval set to 4000 (the Timer Interval is measured in milli-seconds).

5. Test your switchboard completely to be sure it works correctly. Also, close your database and then re-open it to test that the AutoExec macro is working properly. After you're sure everything is okay and just before you submit your database, pull down the Tools menu, click the Database Utilities command, and Compact and Repair Database. This can result in a good deal of space saving.
6. Your database file must be called FP-Peacock-Scarlet-Mustard.mdb (group members last names).
   Submit your FP-Peacock-Scarlet-Mustard.mdb file using COLweb.