Page 172 - Computer - 8

7. Program to create a list of strings after accepting the number of elements in the list from the
user. The program should accept strings from the user and add to the list.
8. Program to create and display a list ‘Num_list’ of 10 elements. The program should then delete
elements from the list at odd positions, i.e., 1 , 3 , 5 , and so on. The final list should also be
st
th
rd
displayed.
9. Program to accept a string from the user and display the result of all string functions learned on
the entered string.

D. Access 2019
1. A Departmental store maintains the database of all its products. The table consists of the
following fields:

Field Data Type Properties Description
ProductID AutoNumber Primary Key Unique ID of the product

ProductName Short Text Field size : 20 Name of the product
Manufacturer Short Text Field size : 30 Name of the manufacturer

Category Short Text Category of the product, such as Food
or Sanitary
Unitprice Number 2 decimal places Price of a product
Quantity Number Stock available for the product

(a) Design the table with the above structure and add at least ten records in it.
(b) Create a form for the table using the Form command.
(c) Create a query that displays the records of all products with price less than 250.

(d) Create a query that displays the records of all products with quantity more than 100.
(e) Create a report to display all records, grouped by manufacturer name.
2. A Cab service provider maintains the database of all the cabs it operates. The table consists of
the following fields:
Field Data Type Description

CarNum Number Registration number of the car
DriverName Short Text Name of driver of the car

Origin Short Text Place of the origin of journey
Dest Short Text Place of the destination of journey

Kms Number Total distance from origin to destination
CarType Short Text Category of car (Sedan, Hatchback, SUV)

(a) Design the table with the above structure and add at least ten records in it.
(b) Create a form for the table using the Form Wizard.
(c) Create a query that displays all records with origin “Delhi”.
(d) Create a query that displays all records with distance travelled more than 50 km.
(e) Create a report to display all records, grouped by name of driver.

170