Search
Free Stuff Jamaica |
|
Play
Games Online  |
|
|
|
|
|
|
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.
|
|
|
|
|