Name: vedanshi joshi
class: 10/a
roll no: 37
subject: it summer assignment 01
topic: practical file
academic session: 2024-25
Table:
primary key:
created table:
create query in design view:
1. Click on the Queries button on the pane of the
opening screen. A screen with different options
appears.
2. Click on Create Query in Design View option.
3. The Add Table or Query dialog Box appears.
4. Select the first table and click on the Add Button.
5. Click on Close button to close the Add Table or
Query dialog box.
6. In the Design grid for query, choose the fields of
the tables, whether the field is to be visible or not and
the search criteria for the query.
7. Click on Run Query from the interface or press F5
key. The output of the query appears.
Query 1:
query 2:
query 3:
query 4:
create form using wizard:
1. Click on Forms View from the left pane.
2. Click on Use Wizard to Create Form. The Form
Wizard dialog box opens up.
3. The First step Field selection gets selected. Choose
the Table or Query from the first screen.
4. After the choice of fields is made, click on Next >
button. The Second step Set up a subform gets
selected.
5. Click on Next > if you do noy want a subform.
6. The next step Arrange controls will get selected.
Choose your arrangements of the main form.
7. Click on Next button .
8. Select the data entry mode.
9. Click on Next button. The next step Apply Sytles
gets selected.
10. Select the style of the form and its field border.
11. Click on Next Button. The last step Set name gets
selected.
12. In the last stage, you choose the name of the form.
It also lets you enter what you want to do with the
form, work with it or modify it.
13. Click on Finish button and the form will appear.
Create reports using
wizard:
1. Click on Reports from the left pane.
2. Click on Use Wizard to Create Report. The
Report Wizard opens up.
3. The 1st step Field Selection gets selected, by
default. Select the field names to be in the reports.
4. Click on Next button. The 2nd step Labelling fields
gets selected.
5. Label the fields as you want.
6. Click on Next button. The 3rd step Grouping gets
selected.
7. Enter the criteris to group the fields by.
8. Click on Next Button. The 4th step is Sort options
gets selected.
9. Enter the required sort options.
10. Click on Next button. The 5th step Choose layout
gets selected.
11. Choose the layout for the report.
12. Click on Next button. The 6th step Create report
gets selected.
13. Create Report by giving an appropriate title to the
report.
14. Click on Finish button. The report is created.
SQL queries:
1. Enter the password: mysql
2. Create database 10a;
3. Enter use 10a database
4. Write the SQL commands acoording to the
question.
query 1:
query 2:
query 3:
query 4:
