Consider the following database:Product CodeProduct NameDate of saleQt

Consider the following database:Product CodeProduct NameDate of saleQtySoldCustomer NameAmountP001Pencil05/10/115Himanshu25P002Eraser04/01/124Ali8P003Sharpner09/12/116Deepak12P004Whitener25/04/112Ankit30P005Glue Pen20/07/123Ruchi301. Write the name of the field that contains numeric data.2. Identify the primary key field in the database.3. Identify the field type of the DateofSale field.4. Identify the names of the fields that contain textual data.5. The given table contains how many fields and records?6. Which property should you use, if you want to make sure that the QtySold entered is less than 10?

Answer»

1. Qty Sold and Amount fields

2. ProductCode field

3. Date/Time data type

4. ProductCode, ProductName and CustomerName fields

5. 6 fields and 5 records

6. Validation Rule