Building Database

Database activity

After creating a database, as explained in Database activity settings...


Contents


Database fields

A field is a named unit of information. Each entry in a database activity module can have multiple fields of multiple types e.g. a text field called 'favourite color' which allows us to type in your favourite shade, or a menu called 'state' that lets you choose one from a list of the 50 that make up the United States of America. By combining several fields with appropriate names and types you should be able to capture all the relevant information about the items in your database.

Note that if you later edit the fields in the databases you must use the Reset template button, or manually edit the template, to ensure the new fields are added to the display.


Field name and description

The name is what is shown when an entry is added. It must be unique and short. The description is for your benefit to help identify that field.


Required field

If you need to ensure one or several particular fields are always completed, then tick the box 'Required field' when setting up the fields for your database. The field(s) will display a red asterisk when students contribute to the database, and they will not be able to save their work until they have entered the relevant information. A new column will show the teacher which fields are required and not:


Field types

The following screenshots show "before" and "afters" of setting up fields. The selection in orange shows the field as it is displayed for the user when they add an entry.

Checkbox

This allows us to offer checkboxes for the user to select. Add the options one under the other. The word will appear next to a checkbox when the user clicks to add an entry. They can check more than one box.

Date

This allows a user to enter a date by picking a day, month and year from a drop down list.

File

Users can upload a file from their computer. If it is an image file then the picture field may be a better choice.

Latitude/longitude

Users can enter a geographic location using latitude and longitude. For example, Moodle HQ is at latitude -31.9545, longitude 115.877. When viewing the record, links are automatically generated linking to geographic data services such as Google Earth, OpenStreetMap, GeaBios,Mapstars and more. (The teacher can choose which of those links appear, if any.)

Menu

The text entered in the options area will be presented as a drop-down list for the user to choose from. Each line become a different option.

Menu (Multi-select)

The text entered in the options area will be presented as a list for the user to choose from and each line become a different option. By holding down control or shift as they click, users will be able to select multiple options. This is a fairly advanced computer skill so it may be wise to use multiple checkboxes instead.

Number

This allows users to enter any number. For example:

(For those who care about the technical details, the field stores floating point numbers.)

Picture

This allows a user to upload and display an image file. "Single view" is when the image is viewed on its own; "list view" is when it is viewed in with other images. Single view can be larger than list view.

Radio buttons

The user gets radio buttons and can choose only one. They can only submit the entry when they have clicked on one button. (Note:If you only have two options and they are opposites (true/false, yes/no) then you could simply use a single checkbox instead. However checkboxes default to their unchecked status and so people could submit without actively selecting one of the options. This may not always be appropriate.)

Text input

Users can enter text up to 60 characters in length. For longer text, or for text that requires formatting such as headers and bullet points, we can use a text area field.

Text area

This allows users to enter a long piece of text using the text editor.

URL

The user can add a link to a website here. If you select autolink then the URL becomes clickable.. If you also enter a forced name for the link then that text will be used for the hyperlink. For example in a database of authors you may wish people to enter the author's website. If you enter the text 'homepage' as a forced name then clicking on text "homepage" will take us to the entered URL.

We can choose to have the URL open in a new window if so desired.


Presets

To avoid the necessity of always having to create a new database from scratch, the database activity module has a presets feature. An image gallery preset is currently included in the database module to help get you started. We can create your own presets as well and share them with others.


Importing a preset

To use a preset:

  1. On the database page, click the Presets tab.
  2. The usual way to import a preset is clicking the "Choose file" button and browsing to the ZIP file containing the preset (eg. "preset.zip") stored on the server. If there does not yet exist a preset ZIP file on the server, upload it from your local machine. Choose the desired preset file by clicking on its action "Choose". Finally, press the "Import" button.
  3. Alternatively, we can choose a previously loaded preset.
  4. After the import, we can start to add or import entries. All the hard work of setting up the fields and templates has been done for you. If you desire, we can still customize the fields and templates.

We will see a "Overwrite current settings" checkbox after the "Import" button has been pressed. If checked, the database activity overwrites some of its current general settings by those stored in the preset:


Exporting a preset

If you wish to share your database presets with others, you have two options:

  1. Export as a ZIP file, which can then be imported to another course or Moodle site.
  2. Save as a preset, which publishes the database for other teachers on your site to use. It will then appear in the preset list. (We can delete it from the list at any time.)

Note: Only the fields and templates of the database are copied when exporting or saving it as a preset, not the entries.


Presets for download

The Activity Examples course on the School demo site has a number of database activities with presets for download.


See also

Using Moodle forum discussions: