Building Your First Database with Microsoft Access- Part 2

To create a second table in which to store information about the electronic devices your workers are using, follow these steps:

Step 1: Select the Create tab on the Ribbon toolbar, and click Table.

Step 2: Click on Click to Add, type T23.

Step 3: Press Enter and type iPad. Thenpress Enter twice.

“T23” and “iPad” are just for the purposes of illustration, of course; utilise whatever number plan bodes well for your business.

Step 4: Every item must be apportioned to the worker who is in control of it, so to change the table design to accommodate this, click the View drop-down menu on the Ribbon toolbar, and click Design View(Figure 1). Type the table name Electronics, and clickOK(Figure 2).
Step 5: In the Design View, type Worker Number in place of the field name ‘ID’.
Step 6: Press the Tab key and in the Data Type drop-down menu, select Number.
Step 7: Type IDcode in place of ‘Field1’ (Figure 1) and Description in place of ‘Field2’ (Figure 2).

As of now the Worker Number field is set to be a “primary key” field, which keeps you from entering duplicate data in that field. You will have to change that so that you can enter a similar worker number multiple times if that worker has several gadgets checked out.

Step 8: Click any where in the Worker Number field in the table, and click the Primary Key button on the Ribbon toolbar to remove the Primary Key setting from this field.

Step 9: Go back to Datasheet View by clicking View, Datasheet View on the Ribbon toolbar. Whenever prompted, click Yes to save the table.

Now, the Electronics table no longer has a primary key’ field, so it will enable you to enter a worker number several times.

Step 10: Type 2011 as the worker number for the first electronics item in the list.

For More details about Building Database with Microsoft Access- Part 2 Please visit our website Below:

Ben Beitler

https://www.accessdatabasetutorial.com/

ben@accessdatabasetutorial.com

United Kingdom
London

		From	To	From	To	From	To
Monday	Open
Tuesday	Open
Wednesday	Open
Thursday	Open
Friday	Open
Saturday	Open
Sunday	Closed