CREATING A DATABASE APPLICATION

1. Click the Web Database module on the navigation bar.
   • In the Modern portal interface, select Applications from the navigation toolbar and click on Web Databases.
2. Click "New Application" on the top right of the window.
3. Choose a template, enter the name and a description for the database and click Save to create the database.
4. To add users:
   • On the General Tab, select the user(s) from the Unassociated Users box and click the right-arrow to move the user to the Associated Users box.
   • Click on Submit and click Close when done adding users.
5. The application is set up; create forms, tables and views to complete the database.

NOTES

• There is no limit to the number of databases that can be created.
• Only a Level 1 Administrator can create databases.
• Users can be added at anytime; they do not have to be added when the database is created.

This article describes the steps needed to create a table from scratch.

The purpose of a database is to store information; the place where data is stored is called a table. A table consists of rows and columns. A row, also called a record, contains information about each item you are tracking in the table. A column, also known as a field, stores each characteristic tracked in the table.

Here is an example of a simple database table, containing company information. The first row, listed in bold, contains the names of the table columns:

Now that we have a basic understanding of what a table is, follow these steps to create a table:

1. Select Tables from the primary toolbar
2. Select New from the secondary toolbar
3. The ‘Create new table’ window will pop-up. On the properties tab;
   1. Fill-in the Table name: Product
   2. Fill-in the RID Caption: Prod_01
   3. Fill-in the Description: Product Portfolio
   4. Click Submit
   • Note:The RID caption, also known as the row identifier and the Description are optional.
4. On the Design tab, create the columns or fields of the information to track.
   1. Click New
   2. Fill-in the field name
   3. Select the field type
      • Number, Decimal, Money, Date, Time, Short Text, Long Text, Memo or Yes/No
   4. Check Required if the field is to be mandatory
   5. Check Indexed if this field is to be indexed.
   • Note:The RID caption, also known as the row identifier and the Description are optional.
On the Permissions tab, assign the users in the workspace, their permissions to modify the table.
1. Click the dropdown arrow to select the user.
2. Click the dropdown arrow to select the permission.
3. Click Submit
4. Click Close. 

This article describes the steps needed to create a table via import from a CSV (Comma Separated Values) file.

The purpose of a database is to store information; the place where data is stored is called a table. A table consists of rows and columns. A row, also called a record, contains information about each item you are tracking in the table. A column, also known as a field, stores each characteristic tracked in the table.

Here is an example of a simple database table, containing company information. The first row, listed in bold, contains the names of the table columns:

Include header information in the first row of your CSV file, as this aids in setting up the columns in the table.

To create a table via import, follow these steps:

1. Select Tables from the primary toolbar
2. Select Import from the secondary toolbar
3. Browse for the CSV file containing information to import
4. Check the box ‘first row contains header information’, if the import file contains header information.
5. Select Create a new Table
   • Fill-in Table name:
   • Fill-in the RID Column:
6. Click Next
7. Check fields that required
8. Click Finish
9. Select OK