1. Go to left and choose "Start button" then click Microsoft Access 2003 or 2007
✖ Create a database . Choose "Create an new file"
✖ Click on "Blank database" (underline)
✖ You must create "a new folder" (your name or your group name)
✖ Choose your "Locate Folder" and click "create"
1. Choose table and click table in "Design view"
✖ You must insert "field name and data type"
2. And then "field properties" with its description
3. Change the fieldsize StudentID from 50 to 15
4. Highlight row on StudentID (right click) see it : primary key
5. Add primary key (looks like house key) toolbar
6 . Save ur document . Go to file (write "student" name )
✖ for additional information : if this > for one , if this >> for many / all
✖ just click "Next"
✖ Click next again
✖ and click "Finish"
✖ Now it's working !
✖ Create a database . Choose "Create an new file"
✖ Click on "Blank database" (underline)
✖ You must create "a new folder" (your name or your group name)
✖ Choose your "Locate Folder" and click "create"
How to create table in "design view"
1. Choose table and click table in "Design view"
✖ You must insert "field name and data type"
2. And then "field properties" with its description
- all you need is just press F1 for guide you using it.
- which is will help you about what you cannot understand.
3. Change the fieldsize StudentID from 50 to 15
4. Highlight row on StudentID (right click) see it : primary key
5. Add primary key (looks like house key) toolbar
6 . Save ur document . Go to file (write "student" name )
How to create "table wizard"
✖ for additional information : if this > for one , if this >> for many / all
✖ just click "Next"
✖ Click next again
✖ and click "Finish"
✖ Now it's working !
Here another example :
✖ Just a same database which is how to put and create a database
How to make a "Relationship"
✖ Don't forget to click "Enforce Referental Integrity" when
you want to make relationship. It's shown to you.
✖ Once you will 4 tables and then your database (thumbs up) FINISH !
