How to create a database in moodle.
- From your course page, turn editing on and go to the Topic or Week in which you want to add the database.
- Click on the Add an activity drop-down box and select Database to get the new forum interface. Detailed descriptions of the various fields are provided below the following image of the form, but in most cases the default values are fine.
- The database name will be the link students use to access the database activity. The description is required. You may want to use the description to tell your students what should go into the various fields.
- You can control both when the database will be available for adding entries and when it will be readable. By default these values are disabled and the database is always available.
- The Required entries values can be ignored since we currently don’t support completion reporting.
- With Enries required before viewing you can require that your students add a minimal number of entries to the database before they can see what other students have submitted.
- You can use Maximum entries to limit the number of entries any individual student can add.
- The Comments feature allows students to add comments to entries, both their own and other students. This is a simple commenting feature and does not support complex threads as a forum would do.
- By setting Require approval student entries will not be visible to other students until you approve them. This requires more work on your part, but prevents the database from filling up with incorrect or irrelevant entries.
- The Ratings section allows entries to be rated. We don’t have any experience with rated databases.
- Common module settings and Restrict access sections are standard activity options. Most of the time the default values will be fine. With a database you may want to hid the activity until you’ve finishing defining the fields and setting up the database display.
- When done click one of the two save buttons at the bottom of the page.