Die Familiedatei – a German project for the language topic of family

and the technology skill of using a data base

 
  1. Open Microsoft's "Access"
  2. If the little paperclip helper pops up, click on "Start using Microsoft Access"
  3. Save the file in your folder with the extension ".mdb"
  4. When you see the window with:

    5. Tables Queries Forms Reports Macros Modules at the top, click on "New".

  5. Create a new table in Data sheet view by clicking "OK"
  6. A window with Table1: Table

    7. Field 1 | Field 2 | Field 3 etc. will open.

  7. Move your cursor to the top left of the screen and click on the icon with the pencil, triangle and ruler, pull down the options, and release on "Design View"
  8. A window will open with "Save as Table Name: 'Table 1' " click on "OK"
  9. Click "yes" to create a "Primary Key"

    10. A window with Table 1: Table

    Field Name | Data Type | Description will open.

    Delete the second line under Field Name "Field 1" and type in "Familienname".

  10. Type on the lines below, the categories about the Family such as: "Vorname" "Hausnummer" "Straße" "Stadt" "Postleitzahl" "Telefonnummer" "Alter" "Geschlecht"
  11. Click on the db1 Database window behind Table1: Table and you will be asked to save the table, click "Yes".
  12. You will see that Table 1: Table now has your new category headings.

    13. The ID will have "(AutoNumber)" - Do not do anything to this.

  13. Type in the name of a person in the family and you will see that the ID will change to "1" and (AutoNumber) will drop down a line.
  14. Fill out all the fields, i.e. the categories for the first record i.e. on the first line.
  15. Then, go back to the second column but on the next line and type in the next person in the family.
  16. Continue typing in all the family’s data.
  17. Save your database.

 

 
Hosted by www.Geocities.ws

1