DBMS: Creating Database and Tables in M. S. Access

1. Create a database named "school" in M. S. Access.

Please Visit: www.lovebookessence.blogspot.com

Please Visit: www.lovebookessence.wordpress.com

i) Open M.S. Access, and create a new database.

ii) Save it with the name "school". Click on 'Create' button. Database will be created.

2. Create a table named "studentinfo" with following structure-

Field Name

• Class - Number
• RollNo - Text
• Name - Text
• Status - Look up Wizard
• Photo - OLE Object
• DOB - Date/Time
• Remarks - Memo

i) A default table with name 'Table1" will be created. Save it with name "studentinfo" by right clicking on the 'Table1 tab' and then clicking on 'Save'.

ii) Then right click on 'studentinfo' tab and select 'Design View'.
iii) Here type each column name and then their respective data types.
Note....

• To set the data type 'Look up Wizard' of column 'Status', firstly select the data type 'Look Up Wizard'.
• A dialog box will appear. Here select 'I will type in the values that I want'. Click on 'Next'.

• In next step, type the values for the list i.e. 'Senior' and 'Junior'. Click on 'Next'.

• Click on 'Finish'.

iv) Then 'Save' the table.





3. Fill at least 5 records.

i) Switch to 'Datasheet View' to type records. Right click on 'studentinfo' tab and select 'Datasheet View'.
ii) Here type values of the records.
iii) Then 'Save' the table.

Please Visit: www.lovebookessence.blogspot.com

Please Visit: www.lovebookessence.wordpress.com