Note: You are currently viewing documentation for Moodle 1.9. Up-to-date documentation for the latest stable version is available here: Adding/editing a database activity.

Adding/editing a database activity

From MoodleDocs

Adding a database activity

Give your database a name and a description

To add a database activity:

  1. Click the "Turn editing on" button at the top right of the course homepage.
  2. Select Databases from the "Add an activity" dropdown menu.
  3. On the Adding a new database page give your new database a name and a description.
  4. Select the general options (see below) and the common module settings.
  5. Click the "Save and display" button at the bottom of the page.
  6. Define the fields or use a preset.
  7. Define the templates.
  8. Add one or two same entries then edit the templates as appropriate.

General options

General options for the database activity

Available from/to

The dates the database is both visible to students and open for data entry.

Viewable from/to

The dates the database is available for viewing, but not open for data entry.

Required entries

The number of entries each student is required to enter before the database activity can be considered complete. The student will see a reminder message if s/he has not submitted the required number of entries.

Entries required before viewing

The number of entries the student needs to submit before s/he can see entries by other students. If the student has not submitted the required number of entries, s/he will only see the entry page and not the list or single view pages.

Note: If entries are required before viewing, the database auto-linking filter should be disabled. This is because the database auto-linking filter can't determine whether a user has submitted the required number of entries.

Maximum entries

The maximum number of entries the student can submit before s/he is blocked. This prevents people from spamming the system, either in the hope that one entry is good enough or, on a public site, as a way of advertising.


Enables commenting on entries. The comments field appears on the single view template when this is enabled.

Require approval?

Allows you to require each entry to be approved by someone with the appropriate role before other users can view it.

RSS articles

Enables you to publish an RSS feed of entries in the database. The option here sets the number of entries available in the feed.

Note: RSS feeds need to be enabled by your system administrator.

Allow posts to be rated?

Lets you allow posts to be rated, which will enter a score in the gradebook for the student’s submissions in the database. The grade is set using the dropdown menu below this option.

Common module settings

See Common module settings for more information. Essentially you can set how different Groups in the course see or interact with each other and set an ID for grading purposes in this area.

See also