The NBA Challenge

Special Thanks to:
Untavious Scott
For Designing this Lesson

You have been assigned by ESPN to put together a database of the top 75 NBA 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/High School Attended
Round Drafted
Years Played
Jersey Number
All Star Games Played
Award Won

Information can be found on the following website:



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:

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