Adding a table

We will create a new table in a database

Now we will continue working with the Event Management database that we’ve just created.

Our “Event Management” database that we’ve just created

Tables

We will now create an Events table in this Event Management database. There we will store information for each new event, such as the agenda, venue, participants, etc.

 A table consists of rows and columns. Information of the same type is stored in a column. For example, the number of participants for an event is always stored in the Participants column.

Each table in a database is assigned a name, ideally so that you know straight away as to which information is held in this database.

Reminder: Table structure

Here are the most important terms again.

Creating and naming a table

Open your new Event Management database.

How to do it

1. Then click on New table in the next screen.

2. The table settings open.

3. Enter a name for your table under Table name. Since this table will hold data about events, we will name it Events (this is a bit shorter).

Create a new table (1)

In the table settings (2), add the name (3)

  If you do not automatically see the + New table option as in the example, please enable the wrench icon in the upper right corner to enter the edit mode.

You don’t need to save it yet, as we are about to continue working in the table settings.

Like to delve deeper into the topic? Then take a look at the corresponding section in our video tutorial.