The NFL Challenge

Special Thanks to:
Jaimie Hunter 

Daniel Garcia

for helping develop this project!!!

You have been assigned by ESPN to put together a database of the top 75 NFL players you feel should receive recognition.  In order to determine their strengths and weaknesses, you will need to make up a database in Access with the following fields.  Remember to format your fields according to data type, length, and description.  Remember to format your picture file as an OLE object, and in design view you will format it to zoom.  The following fields must be included in your table, but you may add additional ones if you like:

First Name
Last Name
College Attended
Round Drafted
Years Played
Jersey Number
Pro Bowls Played
Award Won

Information can be found on the following website:

 The NFL Homepage

 Starting Lineup

Once your table is created, you will construct 20 queries along with questions generated in Microsoft word.  You will be graded on the following three criteria:

  • NFL Players Table Database
  • Microsoft Word Questions for Query
  • 20 Generated Queries which answer the questions created in their word document