Question

Consider the following database:

| Product Code | Product Name | Date of sale | QtySold | Customer Name | Amount |
| P001 | Pencil | 05/10/11 | 5 | Himanshu | 25 |
| P002 | Eraser | 04/01/12 | 4 | Ali | 8 |
| P003 | Sharpner | 09/12/11 | 6 | Deepak | 12 |
| P004 | Whitener | 25/04/11 | 2 | Ankit | 30 |
| P005 | Glue Pen | 20/07/12 | 3 | Ruchi | 30 |

1. 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

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