Step 3: Create and Format the Customers Table

1. Create another new table in Design View.

2. Save the table as Customers.

2. Add and format the fields as follows:

• Cust_ID: 
• Data Type - Short Text, 
• Field Size - 6 characters.

• Cust_Name: 
• Data Type - Short Text, 
• Field Size- 25 characters.

• City: 
• Data Type - Short Text, 
• Field Size - 25 characters.

• Quantity: 
• Data Type - Number, 
• Field Size - Integer, 
• 2 decimal places

• Price/unit: 
• Data Type - Currency, 
• Format - Currency, 
• 2 decimal places

• ID_Manufacturer: 
• Data Type - Short Text, 
• Field Size - 3 characters

3. Set Cust_ID as the primary key.

4. Save the table as Customers.