Page 49 - 1

Creating a Database in Design View

Design view allows you to build a table from scratch and set or change every available
property for each field. You can also open existing tables in Design view and add, remove,
or change fields.

Follow the given steps to create a database in
design view :

Step 1 : Open Microsoft Access 2010.

Step 2 : Click on the Create tab.

Step 3 : Click on Tables Design under the Tables
group.

The database will appear as shown on the right.

Entering Record in a Design View

Follow the given steps to enter record in a design view :

Step 1 : Open the database in the design view.

Step 2 : Click in the cell under the Field Name
and enter the name of the field.

Step 3 : Click in the cell under the Data type.

Step 4 : Click on the arrow.

A drop down list of options will
appear.

Step 5 : Select the data type for the field.
Step 6 :
You can change the properties of
Step 7 : the field under the Field
Properties option.

Repeat the Steps 2 to 6 till all the
fields are named.

49