Scouting Database

    The Scouting Report Database is a Microsoft Access Database specifically designed to record NFL prospects (from 2011 and beyond) and then present them to the user in a variety of ways. Its easy-to-use format makes it accessible to both the novice and professional.

Getting Started

    In order for this database to work you must have Microsoft Access installed on your computer! Please check to make sure that is indeed the case before downloading it or contacting me. I've provided files that will work in Microsoft Access 2000, 2003, 2007, and 2010. If you do not have Access on your computer, the following links will bring you to web pages that have available demos: Access 2007 and 2010.

    The file you are downloading is a ZIP file consisting of a folder which contains multiple versions of the database. Once downloaded, you must extract the files by right-clicking on the folder and selecting "Extract All..." Select your desired destination and you're finished. If you have another extraction/compression program installed like WinZip, then follow their instructions.

    The first thing you should do after extracting the files, is find out which file version matches your version of Access and delete the rest (they're pointless). There is a file called "Filled" that is a working database filled with prospects that you can test drive. After deleting the useless files, I would make a backup -- in fact, make backups frequently to ensure that any issues that may arise will not delete your data. This is no different than if you were using a text file, Excel file, or Word document.

Important!
    If you like to use the Compact and Repair feature of Access, do so at your own risk! It handles memo (large text) fields very oddly and when I used it on a test database it converted all my memo fields to text fields. I'm not yet savvy enough with Access to understand how or why that is the case. Memo fields can hold over 65,000 characters and text fields can hold 255. This paragraph is well over 255 characters, which is problematic for Strengths, Weaknesses, and Notes fields. Make a backup before you attempt a Compact and Repair.

Using the Program

    Upon entering the program, you will see a toolbar (see below) under the ribbon that says "Security Warning." You must select "Options" and select "Enable this content." This is required every time you open a file that does not originate from a location listed in your Trusted Locations.

    To avoid the hassle of clicking this every time you use the database, go to your "Access Options -> Trust Center -> Trust Center Settings -> Trusted Locations" and add the folder in which the files reside. I have disabled most of the options in the database, so you will need to open Access by itself to access the options menu. If you're not sure how to do this or your Security Warning looks different than mine (Access 2007), then you will need to search the Web or Microsoft's website for support.

    Once you've done that successfully, the page will reload and you will reach the main page without the Security Warning.


Main Page

    The main page is a very simple interface. It consists of four buttons.

  •     Add/Edit Prospects: This option will take you to the Prospects Page
  •     Scouting Reports: This option will take you to the Reports Page
  •     Add/Edit Schools: This option will take you to the Schools Page
  •     Exit: This option will exit to your desktop