Step 2: Create and Format the Manufacturers Table

1. Create a new table in Design View.

2. Save the table as Manufacturers.

2. Add and format the fields as follows:

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

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

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

• Discount: 
• Data Type - Number, 
• Field Size - Single, 
• show as Percent, 
• 0 decimal places.

3. Set ID_Manufacturer as the primary key by selecting the field and clicking the "Primary Key" button in the toolbar.

4. Save the table