Page 117 - Code Craft Computer-8

PROJECTS

A. Design the following table in MS Access 2021.

• Enter five records in the table.

• Insert a new field, 'Marks' at the end.
• Move the field 'Father's_Name' before the 'Address' field.

• Edit record number 4 and replace with new information.
• Add two more records.

• Delete record 5.
• Save the table.

B. Create the database of a hotel with the following objects.

Enter 10 records in a table.

Query

Query Name: QryAvailableStatus
Create a query to display all the rooms with “Available” as the status.

Form

Form Name: FrmRoomDetails

Create a form and enter 5 more records.

Report
Report Name: RprtRoomDetails

117