Designing forms
Data entry in much easier through forms .that's is why will learn how to deism and create forms for user to data the database
1. Click create
2. Click more forms
3. Click form wizard
4. Select table 1 the combo box / Select table-2
5. Click ok
6. Click >>button
7. Click next
8. Select columnar
9. Click next
10. Select standard
11. Click next
12. Type form name form 1 / Form - 2
13. Click finish
The form will be generated as below
Data entry using your own designed:
Now entry the following recorder in to the course table using the form 1
Now entry the following recorder in to the course table using the form 1
|
C_ID |
C_NAME |
DURATION |
FEE |
|
KS01 |
NETWORKING |
12 WEEKS |
1500 |
|
KS02 |
DATABASE ORACLE |
12 WEEKS |
1500 |
Now entry the following recorder in to the course table using the form 2
|
S_ID |
S_NAME |
ADMISSION DATA |
BATCH |
C_ID |
|
S1006 |
HASAN |
1/3/2002 |
220 |
KS03 |
|
S1007 |
NIJIM |
3/3/2002 |
240 |
KS04 |
Query wizard -1
1. Click Create
2. Click query design sale of table -1/
3. Click add click close
4. Double click C_ID
5. Double click C_name
6. Double click duration
7. Double click Fee
8. Click file
9. Click save
10. Query name query 1
Query wizard-2
1. Click create
2. Click query design select Table - 2 add.
3. Click close
4. Double click S_ID
5. Double click S_name
6. Double click Admission data
7. Type [entry S_Id] in the criteria row do S_ID field
8. Click file
9. Click save
10. Query name query 2
2. Click query design select Table - 2 add.
3. Click close
4. Double click S_ID
5. Double click S_name
6. Double click Admission data
7. Type [entry S_Id] in the criteria row do S_ID field
8. Click file
9. Click save
10. Query name query 2
Query wizard – 3
1. Click create
2. Click query design
3. Select -Table-1add
4. Select -Table-2add
5. Click close
6. Double click S ID
7. Double click S_name
8. Double click C_name
9. Double click batch
10. Type [entry batch no] in the criteria row do batch field
11. Click file
12. Clicks save
13. Query name query 3
2. Click query design
3. Select -Table-1add
4. Select -Table-2add
5. Click close
6. Double click S ID
7. Double click S_name
8. Double click C_name
9. Double click batch
10. Type [entry batch no] in the criteria row do batch field
11. Click file
12. Clicks save
13. Query name query 3
Report-1
1. Click create
2. Click report wizard
3. Click >>
4. Select query 1
5. Click Next 5 times
6. Report 1 Type finish
2. Click report wizard
3. Click >>
4. Select query 1
5. Click Next 5 times
6. Report 1 Type finish
Report-2
1. Click create
2. Click report wizard
3. Click >>
4. Select query 2
5. Click Next 5 times
6. Report 2 Type finish
2. Click report wizard
3. Click >>
4. Select query 2
5. Click Next 5 times
6. Report 2 Type finish
Report-3
1. Click create
2. Click report wizard
3. Click >>
4. Select query 3
5. Click Next 5 times
6. Report 3 Type finish
*** Entry Batch No 240
2. Click report wizard
3. Click >>
4. Select query 3
5. Click Next 5 times
6. Report 3 Type finish
*** Entry Batch No 240
No comments:
Post a Comment