Creating a Table From Scratch

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.