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"
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 !
0 comments:
Post a Comment