Number Field Size of Single QuantityInStock Number of units in stock. Number Field Size of Single We want the Product Name to be our primary key as we will never have a product with the exact same name as another. When it changes, click the mouse button. Click the Primary Key button. Now that we have all the fields entered in the table, we have to save the table.
Type following screen appears.
Type in Products in the Table Name box. Click the OK button. Close the Table To close the table, click the button or select File, Close from the menu. The datasheet view will open. It looks like a spreadsheet-like format.