Comp 100 Fall 2006 - Exam 1 - Oct 04, 2006

PRINT NAME:________________________________________

Pledge of Honor

General Instructions:

AFTER THE EXAM, DO NOT TOUCH YOUR EXAM FILES ON YOUR U: DRIVE UNTIL AFTER YOU ARE INSTRUCTED TO DO SO!! THE RICE HONOR CODE FORBIDS YOU FROM DISCUSSING ANYTHING ABOUT THE EXAM TO ANYONE UNTIL THE INSTRUCTORS SAY IT IS OK TO DO SO.

MS Powerpoint Questions (40 Points Total)

Download the following files: PackList.ppt and GHLogo.jpg.  Be sure to save in your drive U:.  Open the PackList.ppt file and save as PeruPackList.ppt.

Modify the presentation as follows. (Remember to save your work often.)  Each question from 1 to 8 is worth 5 points.

  1. Apply the design template titled "Teamwork," and replace the subtitle in slide 1 with your name.  If "Teamwork" is not on your system, pick some other "good looking" template besides "Glass Layers."  You will be asked to use "Glass Layers" in question 8 below.
  2. Add the footer "Packing List" and slide numbers to all the slides except slide 1.
  3. In the title Master, insert the logo file "GHLogo.jpg" and position it near tlhe lower right corner of the slide, just above the Number Area place holder, and make the background of the graphic transparent.
  4. On both the title master and the slide master, change the title font color to the light yellow-green color found among the scheme colors.  Switch back to normal view when you are finished.
  5. On slide 2 change the slide layout so you can place clip art to the right of the bulleted list; search for a clip art that deals with money and insert the piece of clip art that shows a dollar sign in an orange circle.
  6. Resize the clip art so that it fits properly on the slide, and then resize the bulleted list text-box as needed so the text is as large as possible without overlapping the clip art.  If the font size does not adjust automatically then use the Font Size button on the Formatting toolbar to adjust the font size.
  7. Add a new slide 10 with the Title and Content layout; type "Discount Items" as the title and insert a table with three columns and three rows as shown below:
     
    Item Regular Price Discount Price
    Boots $198 $118
    Sleeping Bag $162 $98

     

  8. Apply the design template "Glass Layers" to Slide 10 ONLY.  Change the font and alignment of the title of slide 10 to match with the rest of the slides.
  9. When finished, be sure to save the file and close MS PowerPoint.

MS Access Questions (60 Points Total)

  1. 5 pts: Create a new blank database called Recruits and save it the subdirectory comp100/exam1 of drive U: as described in the above general instructions.
  2. 10 pts: Use the Design view to create a new table using the design shown below:
     
    Field Name Data Type Description Field Size Caption Other Properties
    SSN Text Primary Key 30    
    First Text   50 First Name  
    Last Text   50 Last Name  
    Salary Currency       Format: Currency
    Default value: (blank)

    Be sure to make SSN a primary key field and save the table as Recruiters.  This table represents recruiters from some company.


  3.  10 pts: Use the Design view to create a new table using the design shown below:
     
    Field Name Data Type Description Field Size Caption Other Properties
    StudentID Text Primary key 16 Student ID  
    First Text   50 First Name  
    Last Text   50 Last Name  
    BirthDate Date/Time     Birth Date Format: mm/dd/yyyy
    IsMale Yes/No Yes = male, No = female   Male  
    SSN Text Foreign Key from Recruiters table      

    Be sure to make StudentID a primary key field and save the table as Students.  This table represents students from some school.
     

  4. 10 pts: Open the Relationship diagram; add the Recruiters table and the Students table to the diagram; create a one-to-many relationship between Recruiters and Students with referential integrity to represent the fact that a recruiter may recruit many students.  Save the Relationship diagram.
  5. 5 pts: Add two fictitious recruiters to the Recruiters table.
  6. 10 pts: Add three fictitious students to the Students table.  Be sure that each student is associated with one recruiter and each recruiter is connected to at least one student via the recruiter's SSN.  This serves to illustrate the one-to-many relationship.
  7. 10 pts: Create a query that shows the first and last names of all the male students together with the first and last name of their respective recruiters.  Save the query as Male Recruits.
  8. When finished, be sure to close MS ACCESS.

BE SURE YOU UPLOAD BOTH FILES, PeruPackList.ppt and Recruits.mdb, TO YOUR OWL-SPACE EXAM 1 LOCATION.

Hand in your signed Honor Pledge AND all exam materials.