Page 122 - Code & Click - 8

C. Python
Write the following programs in Python.
1. Program to display the series 2, 5, 8, 11, … upto 15 terms.
2. Program to display first 10 numbers in the series 8, 15, 23, … and the sum of the numbers
displayed.
3. Program to accept two numbers from the user and display all odd numbers between the two
numbers in descending order.

4. Program to calculate the sum of squares of the first ten multiples of 3.
5. 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.
6. Program to accept a string from the user and display the result of all string functions learned
on the entered string.

D. Access 2016
A Departmental store maintains the database of all its products. The table consists of the follow-
ing 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.
E. Photoshop 2022
Create the following drawings in Photoshop 2022. Apply various filters on them to make them
eye-catching.

(a) (b)

120