This is one of many help and support pages that are available about the University of Nottingham's Moodle online learning environment. If you have any questions or queries concerning Moodle then contact information is at the bottom of this one-page sheet. Please browse or use the SEARCH box below.
- Login to your module and click on the Turn editing on button (top right).
- In the relevant section, click on the + Add an activity or resource hyperlink and choose Database
- In General Settings, add the Name of the database (which will display on the main module page) and Description, e.g., to include specific directions on how students might contribute if they are expected to.
- Choose any Restrict access settings - Use the dates to restrict access by date if required
- Click on the Save and display button to see the database and start setting it up as below.
(or Save and return to module to go to module front page or Cancel.)
You can also add settings to:
Stage 2: Define the fields:
Create You create a database by defining a set of fields that make up the database template. Each Field created will have a name and description. (Note that if you later edit the fields in a database template you must click on the Templates tab and use the Reset template button, or manually edit the template, to ensure the new fields are added to the display.)
For a new database, the Fields window will open automatically.
If not, click on the Fields tab.
Under Create a new field dropdown Choose to select the type of field
Field types include:
- Checkbox - This allows you 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.
- Latlong - This allows users to add a location via link out services such as Google Maps.
- 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.
- Multimenu - The text entered in theoptionsarea 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.
- 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 button - 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 area - This allows users to enter a long longer piece of text using the text editor.
- Text input - Users can enter short amounts of text up to 60 characters in length. For longer text, or for text that requires formatting such as headers and bullet points, you can use a text area field.
- URL - The user can add a link to a website here. If you select autolink then the URL becomes clickable.. If you also enter aforced name for the linkthen 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 you to the entered URL.
Add names, descriptions and any other parameters to the fields and click Add
Continue adding fields.
You can choose which of the fields is used to sort the entries (by default they are listed by time created/added)
Stage 3: Define the templates
Click on the Templates tab. The List template and Single template define the way the database entries are displayed (there are other templates too, probably not needed for basic databases). Once you've defined the fields in step 2 you can often accept the default templates are often acceptablewithout having to change anything. (More information on the Moodle site here)
Click Save templatefor each (normally List, Single and Add are the only ones needed)
Stage 4: Add or import entries