Class 10 Unit 3 Part B | Session 3 : Creating / Editing Tables in Design View | 2022-2023

Session 3 : Creating / Editing Tables in Design View              

Hello students in last article we learnt about how to create tables using table wizard and how to create table in design view. In this session, we shall talk about how you can create and edit tables in design view. 

Modifying a table in Design View : 

A table once created, whether through wizard or through design view, can be opened in design view. Then you can edit the table design by: 

• Adding fields
• Moving fields
• Deleting fields
• Changing fields properties.

1. Steps to modify the table
2. In the database window, firstly click the tables tab
3. From the bottom half pan, select the name of desired table name and right click on it.

               A.  Select edit from the shortcut menu that appears.

      4. The table structure will bet opened in the design view where you can make the desired changes in

          the table structure as explained in coming lines.

Adding/Modifying/Deleting fields in Table design View.

1.  On the Tables tab of the Database window, select or click the desired table name and right click
2.  From the shortcut menu click at Edit.
3. In the table Window, click a blank row in the field name column.
4. Enter a field name and press the Tab Key to move to the next column.
5. Choose a data type from the drop-down list in the field Type column
6. Press the Tab key to move to the next column and enter a description for the field in the Description column.
7. Save the changes to the table design by clicking Save icon on the toolbar.

Moving a Field

1. To move a field, click once in the field's far left column, i.e. Row selector button and click cut icon on the toolbar or you may also right clikc on the row selector button and select CUT .
2. Now click Paste Icon or paste from shortcut menu.
3. Once Thing that you must keep it mind is that it allows you to paste fields in the end only.
4. Pasted fields become the last field.

Deleting a field

1. Open table for editing in design window. 
2. Select field row by clicking at row selector button, the leftmost gray button upon clicking at which an arrow appears.
3. After selecting the field row, right click on the row selector button and select Delete from the shortcut menu. The shortcut menu will be identical to the one shown

Field Types  (Datatype in BASE)

A field type determines what types of data can be stored in a field and how it can be processed. Various field types in BASE are being given below. 

NUMBER DATATYPE:

Integer Data Types

• TINYINT
• SMALLINT
• INTEGER
• BIGINT

Real Number : 

• NUMERIC or DECIMAL
• REAL  or FLOAT  or DOUBLE

TEXT DATATYPE:

• LONGVARCHAR, 
• CHAR, 
• VARCHAR, 
• VARCHAR_IGNORCASE

DATE DATATYPE:

• DATE

TIME DATATYPE:

• TIME

DATE/TIME : 

• TIMESTAMP

BOOLEAN DATATYPE:

• BOOLEAN 

Setting changing field properties in design view

Entry Required field property  

This property Ensures that data cannot be skipped in the field for which this property is set to YES. SKIPPED  data will be represented through NULL value,

length field property:

this property determines the maximum length of the data can have in this field.

Decimal Places  field property:

this property specifies the number of decimal places permitted in this field.

Default Value Field property:

The default value is used to specify the default value for a field or control.

Field Properties and Data Validation: 

Data validation refers to process of ensuring that only valid data as per set norms should be allowed in the table. Data that does not meet specifications should be discarded.

Setting Field properties: If you are creating a new table then create it in Design view to set field properties.

If you want to set field properties in an existing table, then open it in design view by right clicking on the table's name under Tables Tab and selecting Edit.

Can We Create table in Design view? Can we edit data in Design view? How do you create a table to edit a table? How do you create a table from Design view in computer?  how to create table in design view how to create a table in design view class 10 create a new table in design view with the following field names and data types to design a table form and report in access write the steps to create a table using design view class 8 write the steps to create table with minimum five fields on an entity student'' in design view how to create table using design view in ms access 2007 create a new table in design view. name the first field