Microsoft Access : Chapter 3 : Exercise 1 Creating a Table


Exercise 1 :Creating a Table  

 

Step 1

 

Open Microsoft Access

 

Choose Blank Access Database

 

Click on OK

 

Step 2
 

Change the File Name to “People”

 

Click on create

 

Step 3
 

Double Click on Create a Table using Wizard

 

Double Click Students under Sample titles

 

Double click last name, first name, city, and notes

 

Click rename field when notes is highlighted, and change the field name to age and click OK

 

Click on Next

Step 4
 

Name your table:  People

 

Click Next

Step 5
 

Select:  Enter data directly into    the table

 

Click Finish

Step 6
 

Enter 10 names of students, the cities that they live in, and their ages.

 

Save this table as Students

 

Continue to Exercise 1 solution to compare your final Table with the correct answer.....

Back to Lesson 5

Continue to Exercise 1 Solution

 Back to Menu 

 


Microsoft Access : Chapter 3 : Exercise 1 Creating a Table