1. Create a table Customer Details

	Itemno		Number
	Custid		Number
	Cust_name	Text
	Cust_addr	text
	Cust_phone	text
	Cust_cell	text
	Cust_fax	text
	Cust_email	text
	Date		Date/Time
 	Payment		cash/credit
	
2. Create a table Item Details
	
	Itemno		number
	Itemname	text
	Itemprice	text
	Itemqty		number
        
	
create the above mentioned table using
1. Wizard
2. DataSheet view
3. Design View
4. Import and Link.


Validations for the Above tables

	1. The Cust_phone should be in format 999-99-9999
	2. The Cust_email should consist of @ symbol.
	3. The Itemprice should appear in $
	4. The Itemqty should not be negative
	5. The Customer_no should be of format C00001
	6. The cell_no should have the format (999)99999
	7. The Cust_name should always be displayed in Uppercase
	8. The Date should be in format DD/MM/YYYY.
	9. The Payment can be either be cash or credit
	10.All the fields should have required as yes.