Using of MS Access

MICROSOFT ACCESS

=> Create a New Database :
1. Click On Start Button on the Database
2. Click All Programs
3. Click Microsoft Access
4. Click Create a New File
5. Click Blank Database

*** In The Save in Box Select the Folder to Save Database
*** Type the Database File Name Students Name

=> Create New Table Structure :
1. Click create
2. Click the table design

=> Type data table -1
1. Type C_Id 1st row
2. Select text form data type column
3. Click General
4. Type 7 for field size
5. Select yes form require combo box
6. Keep curser on field (primary key) and then click on Click design Click primary key
7. Type C_name in the 2nd row
8. Select text form data type column
9. Click General
10. Type 20 for field size
11. Type Duration third row
12. Select text form the data size
13. Click General
14. Type 10 for field size
15. Type Fee fourth d row
16. Select currency form data type column
17. Click General
18. Select standard form format column box
19. Type Table Name

i. Click file
ii.Click save
iii. Click Close

=> Type Data Table -2
1.Click Create
2. Click table design
3. Type s_Id 1st row
4. Select text form data type column
5. Click General
6. Type 7 for field size
7. Select yes form require combo box
8. Keep curser on field (primary key) and then click on Click design Click primary key
9. Type S_name in the 2nd row
10. Select text form data type column
11. Click General
12. Type 20 for field size
13.Type admission date 3rd row
14. Select text form date/time column
15. Select Sort date form format column box
16. Select yes form require combo box
17. Type batch_no- number
18. - Select genaral
19. Type C_id four row
20. Select text form data type column
21. Click General
22. Type 7 for field size
23. Select yes form require combo box
24. Select yes duplicates form indexed column box

=> Click file
=> Click save
=> Type table name Table
=> Click file
=> Click save
=> Click class