Question

Thants auad Answer
Using Table Design view create a new table with following specification:
Field Name
Field Type
ItemCode
Auto Number
ProdName
Short Text
Price
Currency
QtySold
Number
Set the field ItemCode as Primary Key Field,
• Save the table as 'Product'.​

Answer 1

Answer:

When you create an Access database, you store your data in tables—subject-based lists that contain rows and columns. For instance, you can create a Contacts table to store a list of names, addresses, and telephone numbers, or a Products table to store information about products. This article explains how to create a table, add fields to a table, set a table's primary key, and how to set field and table properties.