Introduction
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
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
Contact Info
Address:
34 Edgwarebury Lane, Edgware, Middlesex,UK
London
London HA88LW
United Kingdom
London
London HA88LW
United Kingdom
Tel:
Website:
https://www.accessdatabasetutorial.com/
Offering
- Microsoft Ebbok Offer
Hours of operation
| From | To | From | To | From | To | ||
|---|---|---|---|---|---|---|---|
| Monday | Open | ||||||
| Tuesday | Open | ||||||
| Wednesday | Open | ||||||
| Thursday | Open | ||||||
| Friday | Open | ||||||
| Saturday | Open | ||||||
| Sunday | Closed | ||||||
