Paparazzi

  1. You are going to create a Database for your Paparazzi business so you can take pictures of all your favorite celebrities.
  2. First you need to design a table for the celebrity’s agents (Name this table Agent) The table should consist of 5 agents and should be set up like the following:

Field Name / Data Type / Field Size / Primary Key / Description
Agent ID / Number / Yes / Agent Identification
First Name / Text / 10 / First Name of Agent
Last Name / Text / 15 / Last Name of Agent
  1. After you have set the table up, enter 5 Agent records into the table. You are to make each of these records up. For example, Agent ID: 100, First Name: Jerry, Last Name: McGuire. You are not allowed to use this example!
  2. Design another table that lists all of your favorite celebrities (Name this table Celebrity). You must have at least 10 (and they must be real people). You can make up all the addresses and information. The table should be set up like the following:

Field Name / Data Type / Field Size / Primary Key / Description
Id Number / Number / Yes / Identification Number
First Name / Text / 10 / First Name of Celeb
Last Name / Text / 15 / Last Name of Celeb
Address / Text / 25 / Address of Celeb
City / Text / 15 / City of Celeb
State / Text / 2 / State (Two Character)
Zip / Text / 5 / Zip Code (5 char.)
Agent ID / Number / Agent Number
  1. Each celebrity should be connected to an Agent by their Agent ID number. The easiest way to do this is to make each agent have 2 celebrities. For example, if Jerry McGuire’s Agent ID is 100, you could set up your first two clients with the 100 Agent ID.
  2. You are to make 5 queries that show each Agent’s Clients. To do this, run a query with all the celebrity first and last name and agent ID. Then for each query, go into design view and type (= and the agent ID in the criteria field). If you repeat this 4 times, this will not be a hard step.
  3. Create a form for both the Agent and Celebrity Tables. Use all fields.
  4. Create a report that shows the first and last name of the Celebrities and the city and states they live in.