Microsoft Access 2007 tutorial:create tables

Create tables

I. What is Table?

A table is constructed with a field or many fields and it is used for storing data or information. The data can be student information, teachers’ information, employees’ information, etc.

I. How to Create a Table

In Microsoft Access 2007, we can create a table in three ways. They are:

- How to create a table with Table Template

- How to create a table with Design View

II.1. How to Create a Table with Datasheet View

It is the first way to create a table. You can create a table by following the steps below:

- Open any database files you created

- Click Create tab-->Click Table as figure below:

II.2. How to Create a Table with Table Template

You can also create a table via Table Template by doing the similar steps:

- Open any database file you created

- Click Create tab-->Click Table Template as figure:

 


- Select any template you like

III.3. How to Create a Table with Design View

It is the last and popular way in creating a table; in this way you can create a table which all features of a table are organized by yourself, such as field name, data type, field size, format, input mask, default value, required, etc. It is not far different from two ways above; you can do it by the following steps:

Note:  You can create lookup wizard on a field of table if your table field has a data type as Text or Number.