Scribd
Upload
13 views4 pages

Practical 11

The document outlines a practical exercise to create a 'Salesman' table with specified fields and data types. It includes tasks such as inserting a 'Gender' field, adding records, modifying field widths, and sorting records. The practical aims to familiarize users with database management operations.

Uploaded by

hardikvats30
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views4 pages

Practical 11

The document outlines a practical exercise to create a 'Salesman' table with specified fields and data types. It includes tasks such as inserting a 'Gender' field, adding records, modifying field widths, and sorting records. The practical aims to familiarize users with database management operations.

Uploaded by

hardikvats30
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Practical No.

11
Practical Name : Create a Table

Q. Create a Table Salesman' with the following structure:

Field Name Data Type

SM ID Number (NUMERIC)

SM_Name Text (35 Characters)

Address 1 Text (40 Characters)

Address2 Text (40 Characters)

City Text (15 Characters)

State Text (15 Characters)

Pin Code Number

Sell Amt Number

Comm Number

Phone Number

(a) Insert a new field 'Gender. (Use default value of Gender field as 'Male').
(b) Insert at least 15 records in the Table.
(c) Save and Close the Table.
(d) Open the Table 'Salesman' again and Delete Record numbers 3 and 6.
(e) Modify the width of the Address1 and Address2 field as Text (50 Characters).
(f) Sort the records of the table in ascending order of SM_NAME field.
(g) Sort the records of the table in descending order of SM_NAME field.

You might also like