Note: You are currently viewing documentation for Moodle 2.3. Up-to-date documentation for the latest stable version is available here: Database activity settings.

Database activity settings

From MoodleDocs

Adding a database activity

Give your database a name and a description

To add a database activity:

  1. With the editing turned on,in the section you wish to add your database, click the "Add an activity or resource" link (or, if not present, the "Add an activity" drop down menu )and choose Database
  2. Give your new database a name and a description.
  3. Select the general options (see below) and the common module settings.
  4. Click the "Save and display" button at the bottom of the page.
  5. Define the fields or use a preset.
  6. Define the templates.
  7. 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 visible to students.

The database will also be open for data entry, provided we are not within the date range specified by the "read only from/to" settings.

Read only from/to

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

The "available from/to" settings override the "read only from/to" settings. So if a database has "read only from" 1 January, and "available from" 1 February, students will not be able to view its content during January.

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.

Rating a database

Rating a database

Lets you allow posts to be rated, which will enter a score in the gradebook for the students' 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.

Site administration settings

The database activity module has additional settings which may be changed by an administrator in Settings > Site administration > Plugins > Activity modules > Database.

Enabling RSS feeds

RSS feeds must first be enabled in Settings > Site administration > Advanced Features

Database activity capabilities