Creating a Database from Excel Spreadsheet

 

Using the Evidence.xls created earlier

  1. Open MS Access
    1. Choose “New Blank Database
    2. Click ‘OK” press enter
    3. Save as “Evidence Log” in A:/
    4. Click “create”
    5. When the next dialog box opens choose “Create Table by entering data”
  1. On the Menu Bar choose “file” > “open” > “Get External Data” > “Import”
    1. Change file type to “Microsoft Excel”
    2. Choose “A:/Evidence.xls”
    3. Double click “Evidence.xls”    

  1. The Import Spreadsheet Dialog box continues
    1. Check “Show Worksheets” and click “Next”
    2. Check “First Row Contains Column Headings” Click ”Next”
    3. Check “In a New Table” click “Next”

 

NOTE: When the next dialog box appears it allows you to specify information about any fields. The “ID” will not be needed because Access creates an ID of its own. So highlight the fieldname “ID” and click “do not import field (skip).” Click “Next”

 

 

Choosing the Primary Key:

  1. Check “Choose my own primary key”
  2. Choose “Case Number” click “Next”
  3. Choose Import Table to “Evidence” Click “Finish”
  4. Click “OK” to close the “Finished importing” window.
  5. Close the empty Table 1 table.

 

Your Table is Complete

 

Creating the Form

 

  1. In the “Switchboard” highlight “Evidence”
  2. Under the “Objects” choose “Forms”
  3. On the menu bar choose “New”
  4. In the next dialog box, highlight “Form Wizard” and in the lower window choose “Evidence” and click “OK”
  5. In the next dialog box choose “>>” to choose all available fields click “Next”
  6. Choose “Columnar” Click “Next”
  7. Choose your own style then click “Next”
  8. Title your Form “Evidence”, check “open the form to view or enter information”
  9. Click “Finish”- View or Enter Information

BACK

Hosted by www.Geocities.ws

1