Database activity

Q. 

What is a Database and how do I create one?

A.

The Database Activity module allows teachers or participants 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. 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 auto link in a name field. Follow the steps below to create to create a Database.



1. Turn Edit Mode ON.

2. Select a topic and click Add an activity or resource to open the Activity chooser.

3. Select Database and click Add button.

4.  Complete General settings.
Name - Add a Name to the Activity
Description - Write a description
Display description on course page - Check box to Display description on course section.

5. Continue completing General settings.
Available from / Available to - Choose availability dates.
Read only from / Read only to - Choose read dates.
Required entries - The number of entries a participant is required to submit before the activity can be considered complete.
Entries required before viewing - The number of entries a participant is required to submit before they can view entries from other participants.
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 - Enter the maximum number of entries a participant is allowed to submit for this activity.
Comments - Enable comments to be submit in response to participant entries.
Require approval? - If enabled, entries require approving by a teacher before they are viewable by everyone.

6. Configure Grade and Rating settings.
Grade category - Select the gradebook category to place this Database.

Aggregate - The aggregate type defines how ratings are combined to form the final grade in the gradebook. If No ratings is selected, then the activity will not appear in the gradebook.
Scale - Select a custom rating Scal, or how many points should be scored.
Restrict ratings to items with dates in this range - Restrict the dates for rating posts.

7. Define Common module and restrict access settings. (Optional)

8. Click Save and display and create the fields for the Database.

9. Select a Field. A field allows the input of data. Each entry in a database activity can have multiple fields of multiple types such as a date field, which allows participants to select a day, month and year from a dropdown list, a picture field, which allows participants to upload an image file, or a checkbox field, which allows participants to select one or more options.

10. Each field must have a unique field name. The field description is optional.

11. Click the Add entry tab to preview how your entry will look like to other users.

12. Click the Template tab to edit the visual layout of information when listing, viewing or editing database entries. Select the template you want to edit. You can edit in the HTML editor. When done editing click Save template. Click the top tab that corresponds with the selected template to preview.

List template - This template allows you to control the fields used and their layout when viewing multiple entries at once (search results). It is possible that this view may simply provide an overview with more detailed information available by clicking on an entry to access the single view of the entry.
Single template - This is used to display a single entry at a time and so has more space for display and can use, for example, larger versions of images or optionally provide more information than shown in the list view.
Advanced search template - An advanced search template is for creating the interface form used in the advanced search.
Add template - This template creates the interface form used when adding or editing database.
entries.
RSS, CSS, and Javascript templates are for the advanced TLEARN user.

<- Add Template

<- List Template
Use Header and Footer area to enter a message to user.














13. Click the Add entry tab to create a new entry. Answer the fields and click Save and view.

14. Click to view your submission in View single or View list.

<- Single view

<- List view