Database activity: Difference between revisions

Latest revision as of 08:14, 5 December 2022

What is the Database activity?

The Database activity allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things. New feature
in Moodle 4.1!

Watch the video to see the new features and improvements to the Database activity in Moodle 4.1.

Database improvements

Watch this video to see how to set up a Database activity.

Setting up a Database activity

How is it set up?

In a course, with the editing turned on, choose 'Database' from the activity chooser.
Give it a name and, if needed, a description.
Expand the other sections to define the settings you want, in particular the Entries section.
Click Save and Display
From the next page, click to either create new fields, import a preset or use a preset.
Once your fields are set up, click the Templates tab to edit and save templates. For more help, see Database templates

How does it work?

Student view

Students click on the Database icon in the course to access it and add an entry.

They can usually see entries individually (View single) and in a list (List view) and are able to search entries.

Teacher view

Teachers additionally see the set up tabs and can edit,delete, approve/unapprove entries as required.

More information

@@ Line 1: / Line 1: @@
-{{Activities}}{{Improve}}
+{{Activities}}
-The database activity module allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.
+__NOTOC__
+==What is the Database activity?==
+The Database activity allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.
+{{New features}}
+Watch the video to see the new features and improvements to the Database activity in Moodle 4.1.
+{{MediaPlayer | url = https://youtu.be/hFEP-V7hUjo | desc = Database improvements}}
+Watch this video to see how to set up a Database activity.
+{{MediaPlayer | url = https://youtu.be/cypkjvcveP8 | desc = Setting up a Database activity}}
+==How is it set up?==
+#In a course, with the editing turned on, choose 'Database' from the activity chooser.
+#Give it a name and, if needed, a description.
+#Expand the other sections to define the settings you want, in particular the Entries section.
+#Click Save and Display
+#From the next page, click to either create new fields, import a preset or use a preset.
+#Once your fields are set up, click the Templates tab to edit and save templates. For more help, see [[Database templates]]
+==How does it work?==
+===Student view===
+Students click on the Database icon in the course to access it and add an entry.
+They can usually see entries individually (View single) and in a list (List view) and are able to search entries.
+===Teacher view===
+Teachers additionally see the set up tabs and can edit,delete, approve/unapprove entries as required.
+==More information==
 * [[Database activity settings|Database settings]]
 * [[Building Database]]
+* [[Database templates]]
 * [[Using Database]]
 * [[Database activity FAQ]]
+[[Category:Database activity module]]
-This module will create one table per instance, but you may create as many instances you need. The records can be linked to other tables and all resources in the course, if you allow autolink in a name field, but you cannot build a SQL query.
-The table is not created in the SQL database, it is just stored there in lines of other SQL tables (mdl_data*).
 [[de:Datenbank]]
@@ Line 15: / Line 39: @@
 [[eu:Datu-basea]]
 [[fr:Base de données]]
-[[cs:Modul Databáze]]
 [[ja:データベースモジュール]]
-[[ru: База_данных]]

Documentation