Question

Create a table with a minimum of 10 Records.

Each Record should have a Minimum of 8 fields, one of which should be a phone, one a birth date and 1 (Memo) a long Text. Don't forget a Key Field

Using Microsoft Access

Answer 1

Solution

Step 1

Open the Access

Step 2

After Opening access

Right click on the table

Select "Design View"

Step 3

Give appropriate name for the table

Step 4

Creating the fields

Please note "CustomerID" is the keyfield that is primary key

if you want to set the primary key

right click on the field name select primary key

Step 5

save the table

open the table

Step 6

Start entering records

Please note at least 10 records

Save the table

---

all the best