DBMS: Creating Database andTables in M.S. Access

1. Create a database named "library".

i) Open M.S. Access.
ii) Select Blank Database and type the name of database "library".
iii) Click on "Create" button. The database will be created.

2. Create a table named "Book" having following structure܃
Field Name

• Bookid-Text
• BName-Text
• WName-Text
• PYear-Date/Time
• PName-Text
• Price-Currency

i) After creating the database, a default table will open with name "Table1". Save it with name "Book" by right clicking the 'Table1 tab' and clicking on 'Save'.

ii) After 'Book' table is created, right click on 'Book tab' and select 'Design View'.
iii) In 'Design View', type the name of each Column and assign them their respective datatypes.
note... 'Bookid' is primary key.
iv) Finally again 'Save' the table.

3. Add at least 5 records.

i) To add records we need to go in 'Datasheet View'. To switch to 'Datasheet View', right click the 'Book tab' and select 'Datasheet View'.
ii) In Datasheet View, type the values of each record.
iii) Finally 'Save' the table.