Page 52 - Computer - 8

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.

C. Create a table in Access to store the information about the different doctors in a hospital with the
following fields:

Field name Data type Properties
DocID AutoNumber Primary key
DocName Short text Field size 25
Mobile Short text Input mask (___) _ _ _-_ _ _ _

Department Short text
Address Long text Field size 30
(a) Create the table DoctorDetails with the fields given above.

(b) Set the data types of the fields according to the given properties.
(c) Enter 10 records in the Datasheet view.

DISCUSS
DISCUSS Communication Skills
What features of Access 2019 make it different from Excel 2019? Discuss with your classmates.

TEACHER’S DESK
TEACHER’S DESK
Explain to the students, with suitable examples, the use of different data types in Access 2019 for defining
various fields in a database table.

50