Page 210 - Computer - 10(A&B)

Creating Tables

Tables are the basic building blocks of a database. You store data in the database in the form of tables. You have
already learnt how to create database. Now, you will learn how to create a table in a database.

There are two ways to create a table:
v Use Wizard to create table v Create table in Design View

Use Wizard To Create Table
A table can be created using the predefined steps and table structure(s) in Base using the Table Wizard.

To create a table:
Step 1: Click on Tables Use Wizard to Create Table. The Table Wizard opens.

The wizard has four steps: Select fields, Set types and formats, Set primary key, and Create table.
Step2 : Select fields: This step allows you to choose from sample tables, and apply one and its categories to
your table. It has four sections: Category, Sample tables, Available fields, and Selected fields.
Choose Category from “Business” or “Personal”. The one you choose affects what items are in the
Sample tables drop-down menus; business table samples are different from personal table samples.
Click one of the radio buttons.
Step 3: When you select a sample table, all the available fields of that table are displayed in the Available fields
combo box.
The Selected fields list box is empty until you use the controls between the two list boxes to move fields
from the Available box to the Select box.
Select the fields as per the requirements and select ( ) or ( ) buttons to add the predefined
columns or click ( ) or ( )to remove the fields from the Selected Fields box. Click the Next button.

Step 4: Set types and formats: In this step of the wizard, you can set the data types. By default, all the fields
will have Text [VARCHAR] data type which can be changed. Other properties with default values can
be selected as per the requirement. Click the Next Button.

92