Table in Design View

Table in Design View

Design View will allow you to define the fields in the table before adding any data to the datasheet. The window is divided into two parts: a top pane for entering the field name, data type, and an option description of the field, and a bottom pane for specifying field properties

Steps:

1. Select 'Tables' tab From the Database view, click 'New' and then choose 'Design View' from the 'New Table' dialog box, and click OK.

2. Enter a field name in the first row of the Field Name Column.

3. Press Enter or Tab to move to the Data Type Field.

4. Enter a data type for this field. Access will scroll using the first letter of the data type, or you can also use the drop down list provided to you.

5. Alter the Field Properties section of the table design grid as needed.

6. Add a comment in the description column for your better understanding

For the viewlet of Table in Design View.

Using Table Wizard

Like all Wizards, the Table Wizard simplifies the Layout of the fields. You are guided visually through a series of steps, which help you to decide on the type to be created, and then the table is created automatically. The steps in creating a table through 'Table Wizard' are as follows:

1. Open the 'New Table' Dialog box by using one of the followings:

Select the 'Tables' option from the Insert menu. Select the 'Tables' tab and then click on 'New' button in the Database window. Select the 'New' Object toolbar button and choose the Table option.

2. Select table type from the 'New Table' Dialog box.

3. Select table and field from the list of sample tables and sample fields.

4. Give title of the table and create relationship if exist.

Datasheet View to Make a Table

1. Launch MS Access and start a new blank database. Access now launches a blank table for use.

2. Enter data for the first field in the first row.

3. Right click on the first column header (labeled Field 1) and choose Rename from the shortcut menu. This allows you to change the column header, change it to Employee ID for this field.

4. Enter come name data for each of the next three fields, editing the field names to Last Name, First Name, and Middle Name respectively.

5. Move to the next column, Enter yes.

6. Move to the next column to enter date.

7. Click on the Save icon in the toolbar.

8. Click the view button to switch to Design View.