Simple Tables
Home FAQ Getting Started Tables Queries Forms Reports Macros/VBA

 

Simple Tables
Advanced Tables
Relationships

Step Number 1

In the Objects Panel select Tables and click New. Select Create in Design View.

Figure 1 - Click here to view a larger version of the image.

Step Number 2

A blank table comes up.

Figure 2 - Click here to view a larger version of the image.

Step Number 3

In the field name type the name of your field and select the data type you wish to use. In the General tab be sure to type a caption.

Figure 3 - Click here to view a larger version of the image.

Step Number 4

Enter as many field names along with their Data types as are needed.

Figure 4 - Click here to view a larger version of the image.

Step Number 5

Save your changes.

Figure 5 - Click here to view a larger version of the image.

Step Number 6

Type in the name of you table and click OK.

Figure 6 - Click here to view a larger version of the image.

Step Number 7

Select Yes to create a Primary Key.

Figure 7 - Click here to view a larger version of the image.

Step Number 8

Select the table and right click to open the table in Design View.

Figure 8 - Click here to view a larger version of the image.

Step Number 9

Type in the field name of your primary key.

Figure 9 - Click here to view a larger version of the image.

Step Number 10

Go back to your database and select Tables from the Objects panel.

Figure 10 - Click here to view a larger version of the image.

Step Number 11

Open in Design View.

Figure 11 - Click here to view a larger version of the image.

Step Number 12

Select the field name and right click on it, and select Primary Key.

Figure 12 - Click here to view a larger version of the image.

Step Number 13

Make sure the the layout of your table fits your needs.

Figure 13 - Click here to view a larger version of the image.

Step Number 14

Select File, Save As.

Figure 14 - Click here to view a larger version of the image.

Step Number 15

Type in the name of the table and click OK.

Figure 15 - Click here to view a larger version of the image.

Step Number 16

You can view your table.

Figure 16 - Click here to view a larger version of the image.

Step Number 17

You can view record 1.

Figure 17 - Click here to view a larger version of the image.

Step Number 18

Right Click your table and select Open.

Figure 18 - Click here to view a larger version of the image.

Step Number 19

View your completed Table.

Figure 19 - Click here to view a larger version of the image.