introduction to database design tools

• click on the start button
• point cursor at all program in the start menu
• move cursor to microsoft office and click on it
• click on the microsoft access 2003 or 2007

create database

• click on file button
• click on new button
• select blank database on the new file

 create table in design view

•  click on table in database window
• double click on create in design view
• field properties change field size student ID from 50 to 15
• highlight row
• add primary key

create from by using wizard

• click on form
• double click on create form by using wizard 

After the table have done, After we get the 4 tables done. We put the relationships between 4 tables. It came out like figure below

After finishing the save mode. Check all the tables,if all the tables were been arranged correctly.

Now put the data in each of the tables,

you may see a little box next to the primary key button,

there is a "+" box, press it and it will show all 3 tables 

and fill it up with all informations that been ask. 

After you have settle it up, save it.

That is all how we learn and understand learning 

about Introduction to Database Design Tools foe this week.