Creating a Table

Diving Line


If you need to print this page out, type your name in the box below.

Your Name : 


Information

When you create a database, all the data you type into it is stored in Tables.

A table is made up of columns (called Fields) and rows (called Records).

Databases


When you create a new blank database, your database software will normally create the first table for you.  It will have one field in it called ID.  This is an important field.  It is called the Primary Key (or Key Field).   Notice there will be an image of a key Databasesnext to the field name.  Every time you add a new record into the table, your database software will insert a number into this field automatically.

Let's add the following fields to a database table ...

Field Name Data Type Notes 
EmployeelD AutoNumber  Primary Key Field
FirstName Short Text  
LastName Short Text  
Address1 Short Text  
Address2 Short Text  
City Short Text  
County Short Text  
Post Code Short Text  
Mobile Short Text  
Email Short Text  
 Home-Based  Yes/No  Tick if they work from home
 Salary  Currency  


Information

The first thing to do is open the table in Design View.  Click on the View button and select Design View.

Databases

You might be prompted to save your table (if it has not been saved yet).  Give your table a meaningful name.  For this example, we can name our table Employees.

Databases


When the table has been saved, its appearance on the screen will change to this ...

Databases


Information

You can now start added the fields to your table. The first thing to do is to add the next field name.  Click in the Field Name box (under the ID Field) and type in the field name.

Next, click on the list in the Data Type box and select the most appropriate data type from the list.

Databases


Click on the next field name box to add the next field.

Keep doing this until you have added all the fields into the table.

Don't forget to keep saving your table as you go along.

Databases


Information

Finally, you need to change the view of your table again, but this time to Datasheet View.

Click on the View button again.  Select Datasheet View.

Databases


Your database table is now ready for you to add your data.

Databases


DoIT

Create a new database table called Employees.

Use the information below to add the correct fields and data types to your database table.

Field Name Data Type Notes 
EmployeelD AutoNumber  Primary Key Field
FirstName Short Text  
LastName Short Text  
Address1 Short Text  
Address2 Short Text  
City Short Text  
County Short Text  
Post Code Short Text  
Mobile Short Text  
Email Short Text  
 Home-Based  Yes/No  Tick if they work from home
 Salary  Currency  


PrintIT  Print out this Page

Next  Validation Rules


Last modified: Thursday, 5 November 2020, 12:19 PM