Question

Create
Pollution data. Database Access 2007)
External Data Database Tools Fields
2. Ascending Selecion-
Al Descending Advanced
Fiter
Remove Sort Ver
Sort Fit
Σ Total
ng Speling
Save
Replace
Go To
Refresh
Find
More
Records
Select
Find
-
PM10
PM2pnt5
144
153
134
Polution india
Queries
Pollution India Query
forms
Pollution India
Reports
Pollution India
Pollution India
City
- 1 Gwalior
2 Delhi
- 3 Raipur
4 Firozabad
5 Patna
6 Amritsar
7 Kanpur
8 Agra
9 Ludhiana
10 Ahmedabad
(New)
96
149
92
Click to Add
329
286
305
218
164
210
202
200
196
67
88
88
88
100
INSTRUCTIONS
Create a Database with the name Pollution data.
Add a table Pollution_India with column names City, PM2pnt5, PM 10.
City should be a Text Field and PM2pnts and PM10 should be Numeric Fields with data upto 2
decimal points.
Enter data as shown in the given above figure.
Create a Form for the table and save it.
Enter a new row in the table by using the form:
City:
Lucknow
PM2pnt5:
110
PM10:
300
-
Display a report for the table by using the Create Report option and give it the Heading 'Pollution in
Major Cities' and appropriate labels.
Select the appropriate colour theme for the report.
Customize the margins for the report.
In the Report Footer, display the Current Date and Page Number for the report.
Display the cities where the PM10 levels are 200 and above and PM2pnt levels are 100 and above,
by using the Create Query option.
Save and close the table.​

Answer 1

Answer:

110 pm 10 300 pm 2pnt 2209yy