Page History

...

This refers to Moodle 4.3 .8 from September 2020 onwardfrom August 2024 onwards

How to: create a database activity

...

1. Login to your module and click on the 'Turn editing on button Edit mode' toggle switch (top right).  Image Removed Image Added
2. In the relevant section, click on the the '+  Add Add an activity or resource hyperlink ' button. Image Added
3. A window will open. Select Click on the word 'Database' and click on 'Add'

Image Removed

...

1. you will be taken directly to the 'Adding a new database' screen.
2. Image Added
3. In General Settings, add

...

1. the 'Name' of the database (

...

1. which will display on the main module page)

...

1. and 'Description

...

1. ', e.g.,

...

1. to include specific directions on how students might contribute if they are expected to.

...

1. Image Added

...

Image Removed

...

1. (Optional) If you want to add a restriction, click on 'Add restriction' within the "Restrict Access" section. This will open a window, select the restriction you want to add

...

1. .
2. Image Added
3. Image Added
4. Click on the

1. 'Save and display' button to see the database and start setting it up as below Image Added (or 'Save and return to module'

...

1. to go to module front

...

1. page)

...

1. Click on the '

...

1. Edit mode' button

...

1. Image Added on your main Moodle page

Other settings

You can also add settings to:

• "Entries": - Set teacher approval for database entries to be viewable, allow comments, maximum entries, set entries required for completion of the activity or before students can view the entries of others.
• "Availability": - Similar to restrict access
• "RSS": - Add entries to RSS feed"Grade": Controls the category in which this activity's grades are placed in the gradebook.
• "Ratings": - Allow users to rate items

...

1. Open your database. For a new database, the Fields window will open automatically. If not, click on the Fields tab.

...

1. Image Added

...

1. Under 'Create a

...

1. field' dropdown. Choose to select the type of field

...

1. .  Field types include:

...

1. ...

   1. 1. 'Checkboxes' - 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.
      2. 'Coordinates' - This allows users to add a location via link out services such as Google Maps.
      3. 'Date

   ...

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

   ...

   1. 1. 'Dropdown list' - 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.
      2. 'File' - Users can upload a file from their computer. If it is an image file then the picture field may be a better choice.

   ...

   1. 1. 'Image' - This allows

   ...

   1. 1. 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.
      2. 'Multi-select list'
   1. 1. - 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.
      2. 'Number

   ...

   1. 1. ' - This allows users to enter any number.

   ...

   1. 1. '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.)

   ...

   1. 1. 'Short text' - 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.

   ...

   1. 1. 'Text area' - This allows users to enter a longer piece of text using the text editor.
      2. '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.

   ...

   1. Add

   ...

   1. Field name,

   ...

   1. Field description and any other parameters to the fields

   ...

   Image Removed
   

   ...

   1. (The parameters will differ depending on which field type you choose.) and click 'Save'.
   2. Image Added
   3. Continue doing this for as many fields as you need adding fields.
   4. You can choose which of the fields is used to sort the entries (by default they are listed by time created/added)

   ...

   1. Image Added

   
   

   Stage 3: Define the templates

   1. 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 without having to change anything. (More information on the Moodle site here)
   2. Click Save templatefor each (

   ...

   1. normally List Template, Single Template and Add Template

   ...

   1. are the only ones needed).

   Image RemovedImage Added

   Stage 4: Add or import entries

   1. It's usually a good idea at this stage to add your first entry or a test entry. You will need to go to

   ...

   1. the 'Add Entry' tab of your database to do this.

   ...

   1. Image Added
   2. You can import multiple entries via a CSV file if you click the

   ...

   1. 'Import entries

   ...

   1. ' button. The easiest way to determine the format of the text file is to manually add an entry to the database and then export it. The resulting export text file may then be edited and used for importing entries.
   2. Image Added

   ...

   1. Image Added
   2. The expected file format is a plain text file with a list of field names as the first record. The data then follows, one record per line.

   ...

   1. Image Added

   2. Example

      drug_name,action,category

      omeprazole,suppresses gastric acid secretion,proton pump inhibitor

      Records should be delimited by new lines

      Note: Certain field types may not be supported (e.g., files and images).

      Do not put spaces after your commas or upload will fail!

   3. To import a

   ...

   1. file:

      Click on

      1. Select the '

      Cogwheel' within your database and

      1. Actions' drop-down menu, the select 'Import entries'.

   ...

   1. 1. Image Added

   ...

   1. 1.  Find your file to upload and click on 'Submit'.

   ...

   1. 1. Image Added

   ...

   1. It will then confirm that your entries have been imported.

   ...

   1. Click 'Continue'.

      
      

   2. Image Added

    

   Further reading

   Online collaboration with Moodle Databases and Wikis is a useful Xerte toolkit that will help you use both Wikis and Databases more effectively for student collaboration.Image Removed

   See also

   Content by Label
   showLabels false showSpace false cql label = "moodle_database" labels moodle_database