To create a database using Visual Basic:
  1. Start Visual Basic
  2. Click on "Add-Ins"
  3. Click on "Visual Data Manager..."
  4. A new window title "VisData" will appear.
  5. Click on "File"
  6. Click on "New..."
  7. Click on "Microsoft Access"
  8. Click on "Version 7.0 MDB..."
  9. Choose a folder for the database
  10. Type in a name for the database
  11. Click on the "Save" button.

You will now see two windows, one titled "Database Window" and the other titled "SQL Statement". Close the window titled "SQL Statement".

For each table in your paper diagram:

  1. Right-click on the word "Properties" in the tree of the Database Window.
  2. Click on "New Table"
  3. A new window titled "Table Structure" will appear.
  4. Enter a table name
  5. For each field in the table:
    1. Click on "Add Field"
    2. Enter a name
    3. Select a data type.  General rule of thumb:  Only make it a number if the field contains a value that you will be doing a calculation on.  Example:  A zip code is a 5-digit number, but the data type should be text because we don't do any arithmetic on the zip code.  The exception to this rule of thumb is if the field is a foreign key - in which case the data type should be a number of type long (because auto-number fields are usually of type long).
  6. Click on "OK"
  7. Click on "Add Index"
  8. Type in a name for the index, usually "Primary Key" is sufficient and descriptive.
  9. Click once on the id field from the list.
  10. Click "OK"
  11. Click "Close"
  12. Click on "Build the table"
  13. The window will close and the table will appear in the tree.