When you have created your database you can start creating
a table from the database window shown below:
Make sure that you are in the Tables
section of the database window, if you are not you can click on
the Tables option at the left-hand side of the window to go to that
make sure the option ‘Create Table in Design View’ is selected as above and click the
Open option at the top left of the window.
A table now appears
as below and you can enter details to define your fields.
A number of fields
which have been defined are shown below. Note how you can click on the arrow to the right of
Type box to
choose the field type.
If you create
a Text field, you should also enter a length for that field in the
Field Size box at the bottom of the screen.
You can type in almost any field name
you want as long as it is not too long. Field names can contain spaces and do not have to be
all upper case. When
you have created as many fields as you need, click on the floppy
disk icon and enter a name for your table as below.
When you click on OK to save your table you will see a window
appear as below asking you if you want to create a primary key.
We will not create
a primary key at the moment, this topic is covered in the section
on the primary
Click the No button to prevent a primary key being created.
you have saved your table you can close the field definition window
by clicking on the cross in the top right hand corner of that window
and you will now see your new table listed in the Tables section
of the database window as below.
Click here to
return to the Access index.