Unit 3. Creating data tables (I)

Here we will see how to create a data table in order to be able to introduce data into the database in the following units, and later work with this data using the advantages provided to us by Access2003.


Creating a data table.

To create a data table we need to position ourselves in the database window with the Tables object selected, if we click on the New button it opens a window with the various available ways of creating a new table:

Datasheet view consists of directly introducing the data into the table, and according to the value introduced into the column determines the type of data that the column has.

Design view is the method we will detail in this unit.

Table wizard guides us step by step in the creation of the table using a predetermined sample table.

Import table consists of creating a new table from an existing one in another database.

Link table consists of creating a reference to another table stored in a different database.

Next we will explain the way to create a table in design view. This method consists in defining the structure of the table i.e define the different columns that it will contain as well as other considerations such as codes, validation rules etc...

Another way to arrive at the design view is from the Database window with the Tables object selected then double clicking on the option Create table in Design view.

The Table design window will appear:

In the title bar we have the name of the table (as we have still not assigned a name to the table, Access has assigned a default name Table1.

Next we have a grid where we define the columns (fields) that compose the table using a line for each column, so in the first row of the grid we will define the first column of the table, in the second row of the grid we will define the second column of the table and so on and so on.

At the bottom left we have two tabs (General and Lookup) to define the properties of the field i.e additional characteristics of the column we are defining.

And on the right we have a box with text to help us with what we need to accomplish.

To continue, go to the next page.


Page. 3.1

Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.