Page 37 - Code & Click - 8

C. Write ‘T’ for True and ‘F’ for False statement.
1. You can enter data in a table in Design view. _______

2. A Relational database stores data in the forms of tables. _______
3. A table can only have one primary key. _______
4. The Description column of the field can be left blank. _______
D. Answer the following questions.
1. What is a DBMS? Write four advantages of a DBMS.

2. Describe the various database objects available in Access 2016.
3. Describe the various parts of the Design view screen.
4. What is a Primary key? Write the steps to set a primary key for a table.

Mind Stretching
1. Sandhya wants to create a table in Access for storing contact details of her friends. She wants
to store the name, contact number, address, and date of birth of each friend. Suggest her the
suitable data types for different fields in the table. Logical Thinking
2. A fast food restaurant maintains the database of all its dishes for inventory purpose. The database
includes the fields – ArticleNum, DishName, Type, Flavour, Price, and Quantity. According to
you, which field should be chosen as the Primary key and why? Computational Skills

Lab Work Computational Skills

A. Create the table in an Access database to store the information of the cars manufactured by a company.
The table should include the following fields:

CarNo ModelName Type Weight Colour Price
Assign the suitable data types to the fields and enter 10 records.
B. A Hotel maintains the database of all its customers. The table consists of the following fields:
Field name Data type Properties

CustomerId Number Primary key
CustName Short text Field size: 25
ContactNum Short text Input mask (___) _ _ _-_ _ _ _
RoomNo Number
DateOfArrival Date/Time Format: Medium Date
DateOfDeparture Yes/No Format: Medium Date
BillAmt Number Decimal Places: 2
(a) Create the table ‘CustomerDetails’ with the fields given above.
(b) Rename the Field name CustName to CustomerName and DateOfArrival to ArrivalDate.

(c) Enter 10 records in the Datasheet view.

Discuss Communication Skills

What features of Access 2016 make it different from Excel 2016? Discuss with your classmates.

35