FYBCOM Computer Practical

F. Y. B. Com. (Computer Practical)

5|[S8LS, < !

!P Windows Desktop GF GLR[GF EFUF[ VF[/BL ATFJF[P

s!f Desktop sZf Icons s#f Start Menu s$f Taskbar

ZP Recycle Bin GFDGL Windows BF[F,F[ TYF T[GF GLR[GF EFUF[ V[F/BL ATFJF[P NZ[S EFUGF[ p5IF[U V[S JFSIDF\
H6FJF[P

s!f Titlebar sZf Minimise Button s#f Close Button s$f Maximise Button s5f Scrollbar s^f Windows Frame
s&f Scroll Button s*f Control Menu Button

#P Start Menu GF H]NF H]NF lJS(5F[GL IFNL AGFJL NZ[SGF[ p5IF[U V[S JFSIDF\ H6FJF[P

$P Start Menu GF[ p5IF[U SZL GLR[GF 5|F[U|FD X~ SZ[FP

s!f Calculator sZf Paint s#f Notpad

5P p5ZF[ST +6[I Windows G[ Cascade VG[ Title :J~5[ UF[9JF[P

^P Calculator, Paint VG[ Notpad GL Windows A\3 SZF[P

&P Desktop 5Z VFJ[, Icons G[ Name 5|DF6[4 Type 5|DF6[4 Size 5|DF6[4 Date 5|DF6[ UF[9JF[P

*P Desktop 5ZG]\ Wallpaper AN,F[P

(P Desktop 5ZG]\ Screen Saver AN,F[P

!)P Windows G[ A\3 SZF[P

5|[S8LS, < Z

!P Windows Explorer G[ X~ SZF[P

ZP Windows Explorer GF H]NF H]NF EFUF[ VF[/BL ATFJF[ NZ[SG]\ SFI" V[S JFSIDF\ H6FJF[P

#P Windows Explorer G[F p5IF[U SZL TDFZF GFDG]\ V[S Folder AGFJF[P

$P Accessories GFDGF Folder DF\YL GLR[GL +6 OF.,F[ TDFZF GFDGF Folder DF\YL SF[5L SZF[P MS Paint, Wordpad,
Calculator

5P TDFZF GFDGF Folder G]\ GFD AN,LG[ "My Folder" V[J]\ GFD VF5F[P

^P "My Folder" DF\YL MS Paint OF.,G]\ GFD AN,L "X Paint" SZF[P

&P "My Folder" G[ V[S 0=F.J 5ZYL ALHL OF., 5Z Move SZF[P

*P Notpad.exe GFDGL OF., XF[3F[P

(P "My Folder" GFDG]\ Folder N}Z SZF[ TYF OZL T[G[ 5]Go:YFl5T SZF[P

!)P My Computer GFDGF Icon GF[ p5IF[U SZL TDFZF SF[d%I]8Z ;FY[ HF[0[, ;F3GF[GF[ bIF, D[/JF[P

!!P Control Panel GF[ p5IF[UF[ XF[3F[ TYF Control Panel GF[ p5IF[U SZL Date VG[ Time AN,F[P

!ZP GLR[GF 8](;GF[ p5IF[U V[S<A[ JFSIDF\ XF[3F[P

s!f Media Player sZf Disk Defragmenter s#f Scan Disk

5|[S8LS, < #

!P J0"G[ X~ SZF[P

ZP J0"GF :S|LGGF H]NF<H]NF EFUF[ VF[/BL ATFJF[ VG[ NZ[S EFUGF SFIF[" V[S ,L8LDF\ ,BF[P

#P GLR[GF ,BF6G[ 8F.5 SZF[P

           English is used all over the world and so it is an international language. English is a very important langauge. We see
           a lot of English around us. It is called a window to the world. Books on technical subjects are in English. Let us have
           good English.

$P p5ZGF ,BF6G[ PRACT01 GFD 5Z ;\U|C SZF[P

5P p5ZGF ,BF6G[ KF5F[P

^P p5ZGF ,BF6GF[ l5|g8 l5|jI} SZF[P

&P 0F[SI]D[g8G[ A\3 SZF[P

*P J0"DF\YL ACFZ GLS/F[P

(P J0"G[ OZL RF,] SZF[P

!)P p5ZF[ST 0F[SI]D[g8 SFIF"lgJT SZF[P

!!P p5ZGF 0F[SI]D[g8G[ PRACT01 GFD 5Z ;\U|C SZF[P

!ZP GLR[ 5|DF6[GL S;"Z D}JD[g8 SZF[P

< XaNGL X~VFTDF\

< XaNGF V\T[P

< ,F.GGL X~VFTDF\

< ,F.GGL V\T[P

< 5[Z[U|FO8GL X~VFTDF\

< 5[Z[U|FO8GL V\T[P

< 0F[SI]D[g8GL X~VFTDF\

< 0F[SI]D[g8GL V\T[P

5|[S8LS, < $

GLRGF[ 5+ 8F.5 SZF[P 5+ 8F.5 SZTL JBT[ ;]3FZF < J3FZF wIFGDF\ ,[JFGF GYLP

Jay Shri Ram Corporation

D-4/6, Model Town,

Delhi-110009

March-April 12, 2003

To,

M/s. Sham Sunder & Co.

Phirozshah Mehta Road,

Delhi-110 006

Dear Sir,

I shall be obliged if you can send the following items as soon as possible.

1. 50 meters of green curtain cloth (Cat 132)

2. 10 meters of table cloths.

You may send these by rail parcel or by truck to the above address. I assure you that your bill will be paid within.

15 days on receipt.

Yours Faithfully

V.K. Anand (Manager)

!P 5+G[ PRACTO2 5Z ;\U|C SZF[P

ZP JT'/FSFZ[ NX"FJ[, ;]3FZF SZF[P

#P 5+G[ 5]Go;\U|C SZF[P

$P K[(,[ SZ[, ;]3FZF SF-L GFBF[P

5P SF-L GFB[, ;]3FZFG[ 5]Go:YFl5T SZF[P

^P GoTo 0FI,F[U AF[S;GF[ p5IF[U SZL S;"ZG[ 5F\RDL ,L8L 5Z ,. HFVF[P

&P (a) Corporation XaN 5;\N SZF[P

(b) I shall be .. ,L8L 5;\N SZF[P

(d) ;DU| 5+ 5;\N SZF[P

(e) I assure you... JF/] JFSI 5;\N SZF[P

*P 5+GL K[(,L +6 ,L8LVF[ 5;\N SZF[ VG[ 5;\N SZ[, ,F.GG[ RFZ JBT SF[5L SZF[P

(P p5ZF[ST SF[5L SZ[, ,BF6G[ 5;\N SZL N}Z SZF[P

!)P 5|YD +6 ,L8LVF[G[ DwIDF\ ,FJF[

!!P TFZLBG[ HD6LAFH] UF[9JF[P

!ZP 5+GF AFSLGF ,BF6G[ Justify SZF[P

5|[S8LS, < 5

J0"DF\ GLR[GF ,BF6G[ T{IFZ SZF[P

S.Kumars & Sons

43, The Mall,

Shimla.

May 15th, 2003

Mr. Anand Ray,

1522, Sector 28-B,

Chandigadh

Subject : Returned Goods

Dear Mr. Ray.

We are sorry to learn that goods dispatched by us were damaged in transit. Although we take all precautions, once in a while goods get damaged due to mishandling by the Goods carrier. We have already dispatched the replacement for the damaged goods. We are sorry for the in convenience causes to you.

Yours Sincerely,

G. Sunder

Sales Manager

!P p5ZF[ST 5+G[ PRACTO3 5Z ;\U|C SZF[P

ZP 5+GL 5|YD +6 ,L8LVF[ DwIDF\ UF[9JF[ VG[ T[DG[ (Bold) UF8L SZF[P

Font GL UF[9J6L GLR[ D]HA SZF[P

Font : Arial, Style : Bold, Size : 18, Color : Red.

#P TFZLBG[ HD6L AFH] UF[9JF[P

$P Subject .. JF/L ,L8L GLR[ 0A, V\0Z,F.G SZF[P

5P 5+GF V\T[ VF5[, +6 ,L8LVF[ HD6L AFH] UF[9JF[P

^P 5+G[ 5]Go;\U|C SZF[P

&P ;DU| 5+GL ,L8LVF[ JrR[ ,F.G :5[;L\U 1.5 GL SZF[P

*P 5+DF\YL "We" XaN H XF[3F[P

(P "May" XaNGL HuIFV[ "June" XaN Replace SZF[P

!)P 5+DF\ Spelling Checking SZF[ VG[ 5+DF\ ZC[,L :5[,L\U E},F[ :5[,L\U R[SL\UYL ;]3FZF[P

!!P 5+G]\ U|FDZ R[SL\U SZF[P

!ZP theasurus GF[ p5IF[U SZL Goods XaNGF 5IF"U XF[3F[P

5|[S8LS, < ^

(A) GLR[GF[ 5+ J0" DF\ 8F.5 SZF[P

Driver's Handbook

No person is permitted to drive a motor vehicle on the road unless he/she holds a valid driver's licensee for the type of
vehicle being driven. The driving licenses are classified in the following categories :

* Scooter / Motorcycle

* Cars

* Heavy Vehicles

* Crans

!P sVf 5+G]\ XLQ"S DwIDF\ UF[9JF[ VG[ GLR[ 5|DF6[ Font GL UF[9J6L SZF[P

Font : Arial, Style : Bold and Italic, Size : 14 poionts, Color : Red

sAf AFSLGF ,BF6 DF8[ sA],[8[0 l,:8 l;JFIf GLR[ 5|DF6[ Font GL UF[9J6L SZF[P

Font : Times New Roman, Style : Regular, Size : 10 points.

sSf A],[8[0 l,:8 DF8[ GLR[ 5|DF6[ Font GL UF[9J6L SZF[P

Font : Courier New, Style : Italic, Size : 10 points

ZP ,BF6DF\ A],[8GF 5|SFZ (Style) AN,F[P

#P A],[8[0 l,:8G[ G\AZL\U l,:8DF\ O[ZJF[P

$P XLQ"S 5KL 12 points GL HuIF ZFBF[P

5P 5|YD 5[Z[U|FO 5KL 6 points H[8,L HuIF ZFBF[P

^P 5[Z[U|FOGL HD6L AFH] 0.5" TYF 0FALAFH] 0.3" TYF 5[Z[U|FOGL ,L8LVF[ 1.5 JrR[ GL ,F.G :5[;L\U ZFBF[P

&P G\AZL\U l,:8 DF8[ 0FAL AFH]G]\ DFHL"G 1" SZF[P

*P 'Heavy Vehicle ' ,BF6G[ K[SL GFBF[P

(P 5+GF V\T[ JT"DFG TFZLB VG[ ;DI NFB, SZF[P

!)P ,BF6GL VFH]AFH] IF[uI AF[0"Z UF[9JF[P

(B)

!!P GLR[ 5|DF6[GL ,F.G 8F.5 SZF[P

(A+B)² = A² + 2AB + B²

H₂SO₄

C + O⁴₂ = CO₂

(C)

!ZP sVf "NGU" p5Z Auto Text Entry V[JL ZLT[ T{IFZ SZF[ S[ HIFZ[ TD[ NGU VYJF ngu 8F.5 SZF[ tIFZ[
VF5F[VF5 North Gujarat University ,BF. HFIP

sAf V[S V[JL Auto Correct Entry T{IFZ SZF[ S[ H[YL HIFZ[ TD[ 'absence' 8F.5 SZF[ tIFZ[ J0" T[G[
VF5F[VF5 'absence' O[ZJF[P

5|[S8LS, < &

!P J0"DF\ GLR[ D]HA 8[A, T{IFZ SZF[P

No.	Name	C.C.	BOM	Eco.	A/c.	Total
1	RAM	58	80	45	44
2	SHYAM	60	70	44	45
3	MOHAN	62	75	43	51
4	SOHAN	63	56	46	62
5	BAKUL	65	67	61	63

ZP K[(,L ,F.G 5KL GJL ,F.G sZF[f pD[ZF[ T[DF\ lJUT EZF[P

#P Name GFDGF SF[,D VFU/ GJ]\ SF[,D pD[ZF[ T[G[ Surname V[J]\ GFD VF5F[P T[DF\ lJUT EZF[P

$P S[,SI],[XG ;UJ0GF[ p5IF[U SZL NZ[S lJnFYL"GF S], U]6 XF[WF[P

5P Surname JF/] SF[,D N}Z SZF[P

^P Surname GFDG]\ SF[,D 5]Go:YFl5T SZF[P

&P SOHAM GFDJF/L ZF[ N}Z SZF[P

*P SOHAM GFDJF/L ZF[ 5]Go:YFl5T SZF[P

(P Auto Format ;J,TGF[ p5IF[U SZL 8[A,G[ VFSQ"S AGFJF[P

!)P Total GFDGF SF[,DG[ pTZTF S|DDF\ UF[9JF[P

!!P Name GFDGF SF[,DG[ R-TF S|DDF\ UF[9JF[P

!ZP 8[A,G[ Text :J~5DF\ O[ZJF[ VG[ OZL 5FKL Text G[ 8[A,DF\ O[ZJF[P

5|[S8LS, < *

[A]

!P J0"DF\ GLR[ 5|DF6[ 0F[SI]D[g8 T{IFZ SZF[P

SN. Description Quantity Rate

1. Computer 12 30500

2. Floppy Disk 123 120

3 Printer 1 8000

4 CD 5 20.50

5 Computer Desk 10 1200.50

GF[\3 o GLR[ 5|DF6[ Tab Setting SZJFG]\ K[P

Colomn Tab-Type Position

2. SN Right Alighed 0.5"

3. Description Left Alighed 1"

4. Quantity Right Alighed 4"

5. Rate Decimal 5.5"

6. Drawing Toolbar G[ SFIF"lgJT SZF[P J0"VF8"GL DNNYL GLR[ 5|DF6[G]\ 8F.8, T{IFZ SZL p5ZGF ,BF6 5Z
D}SF[P

SHYAM HARDWARE HOUSE

STOCK POSITION

7. Drawing Toolbar G[ A\3 SZF[P

8. p5ZGF ,BF6DF\ SF[.56 V[S Clipart Image NFB, SZF[P

[B] Drawing Toolbar GL DNNYL GLR[ 5|DF6[ 0F[SI]D[g8 T{IFZ SZF[P

5|[S8LS, < (

!P J0"DF\ GLR[GF[ 5+ T{IFZ SZF[P

S.KUMAR & SONS

43, The Mail, SHIMLA

May 15, 1999

Mr. Anand Roy

1522, Sector 28-B

Chandigadh

Subject : Returned Goods

Dear Mr. Roy,

We are sorry that goods dispatched by us were damaged in transit. Although we take all precautions once in while, goods get damaged due to mishandling by the goods carrier. We have already dispatched replacement for the damaged goods. We are sorry for the inconvenience caused to you.

Yours Sincerely,

G. Sunder

Sales Manager

ZP 5+GL ;HFJ8 SZF[P

#P :5[,L\U R[SL\U VG[ U|FDZ R[SL\U SZF[P

$P 5+G[ V\T[ Page Break NFB, SZF[P

5P 5+G[ N; JBT Copy SZF[P

^P Page Setup GLR[ 5|DF6[ UF[9JF[P

Top Margin 1.5"

Bottom Margin 1.5"

Left Margin 1"

Right Margin 1"

Header Margin 0.8"

Footer Margin 0.7"

Gutter Margin 0.5"

&P 5+DF\ GLR[G]\ Header Page Lenght 10" SZF[P Header GL ;FY[ Time, Date, Page Number D}SF[P

*P 5+DF\ GLR[ 5|DF6[ Footer ;[8 SZF[P

By Sunil Shrivastav

(P 5+GF[ Print Prieview SZF[P Zoom SDFg0GF[ p5IF[U SZF[P

!)P 5+G[ l5|g8 SZF[P l5|g8 0FI,F[U AF[S;GF lJlJ3 lJS(5F[ RSF;F[P

!!P GJF[ 0F[SI]D[g8 Open SZL T[DF\ GLR[G]\ JFSI 8F.5 SZF[P

My First Examination

!ZP p5ZF[ST JFSI 5Z Change Case GF lJlJ3 lJS(5F[GL RSF;6L SZF[P

5|[S8LS, < !)

!P J0"DF\ GLR[GF[ 5+ T{IFZ SZF[P

University Grant Commission

National Education Testing

F-48, South Extension-I

New Delhi

No.F.5-32/98

Miss Ragini Sharma

77, Golf Links

New Delhi.

Sir / Medam,

With reference to your application in response to your advertisement No.4/98 for the Junior Stenographer (English) in the office of the University Grants Commission. You are requested to appear for a written examination in General English and General Knowledge on the 24th February, 1998 at 10.00 a.m. at the following examination centre :

Faculty of Arts

University of Delhi

Delhi-100 007

Please Note that :

1. You should bring your own pen / ball pen. Answer books will be supplied by the commission at the examination hall.

2. No.TA/DA will be paid for me above examination

3. Candidates qualifying the examination will be called for the shorthand test at a later date.

4. You are requested to remain present at examination hall before half an hour.

ZP 5+GL 5|YD RFZ ,L8LVF[ DwIDF\ ,FJF[P

#P 5+DF\ IF[uI HuIFV[ TFZLB NFB, SZF[P

$P 5+G]\ :5[,L\U R[SL\U VG[ U|FDZ R[SL\U SZF[P

5P 5+DF\YL examination XaN XF[WF[P

^P examination XaNGL HuIFV[ test XaN D}SF[P

&P Please Note that 5KLGF ,BF6GF 5|YD D]N'F DF8[ GLR[ 5|DF6[ OF[ZD[8L\U SZF[P

Font : Arial, Type : Bold and Italic, Size : 14

*P D]N'F G\AZ Z YL $ ;]3LGF ,BF6 DF8[ p5Z D]HAG]\ OF[ZD[8L\U 5[.g8ZGL DNNYL SZF[P

(P Auto Format ;UJ0GF p5IF[UYL 5+GL UF[9J6LDF\ YTF O[ZOFZF[ RSF;F[P

!)P Please Note that 5KLGF ,BF6G[ A[ SF[,DDF\ UF[9JF[P

!!P 5+G[ Print SZF[P

5|[S8LS, < !!

(1) Access DF\ STUDENT GFDGF[ V[S Blank Access Database AGFJF[P

(2) Table Design View GF[ p5IF[U SZL GLR[ 5|DF6[G]\ 8[A, T{IFZ SZF[P

lO(0G]\ GFD	5\|SFZ	SN	GF[\3
Stud_No	Auto Number	--	GFD BF,L CF[J]\ HF[.V[ GlCP
Stud_Name	Text	40	lO(0 BF,L CF[J]\ HF[.V[ GlC4 "M" S[ "F" 5{SL SF[. V[S S[Z[S8Z CF[J]\ HF[.V[P HF[ "M" S[ "F" 5{SL SF[. S[Z[S8Z G CF[I TF[ "Enter M of "F" V[JF[ D[;[H K5FJF[ HF[.V[P
Fee	Currency	--	lO(0 BF,L CF[J]\ HF[.V[ GlCP ZSD #)) YL J3] VG[ ^)) YL VF[KL CF[JL HF[.V[P HF[ T[D G CF[I TF[ "Fee must be>300 and <600" V[JF[ D[;[H VFJJF[ HF[.V[P
Subject	Text	10	O(0 BF,L CF[J]\ HF[.V[ GlCP lJQI ''BM','SP','STAT', VYJF 'COMPUTER' 5{SLGF[ C[FJF[ HF[.V[P "Invalid Subject' V[JF[ D[;[H VFJJF[ HF[.V[P

GF[\3 o 8[A,G[ Stud_Info 5Z ;\U|C SZF[P

(3) Form Wizard GF[ p5IF[U SZL 0[8F V[g8=L DF8[G]\ OF[D" T{IFZ SZF[P

Form Columnar 5|SFZG]\ CF[J]\ HF[.V[P

Form GL Style Sandstone ZFBF[P

Form G[ Student Entry 5Z ;\U|C SZF[P

(4) p5ZF[ST 8[A,DF\ !) SF(5lGS Z[SF[0" NFB, SZF[P

(5) H]NF<H]NF Navigation Buttons GF[ p5IF[U SZL

s!f 5|YD Z[SF[0" 5Z HFVF[

sZf V\lTD Z[SF[0" 5Z HFVF[P

s#f RF[YF Z[SF[0" 5Z HFVF[P

s$f ;FTDF\ Z[SF[0"DF\ lJQI ;]3FZF[[P

s5f 5F\RDF[ Z[SF[0" N}Z SZF[P

(6) Report Wizard GF[ p5IF[U SZL GLR[ 5|DF6[ ZL5F[8" T{IFZ SZF[[P

s!f ZL5F[8"DF\ TDFD lO(0; NXF"JJFGF K[P

sZf Subject VG[ T[DF\ Name R-TFS|DDF\ VFJ[ T[ ZLT[ UF[9JJFGF K[P

s#f ZL5F[8"GF[ Layout Tabular ZFBF[P

s$f ZL5F[8"G[ Student Information 5Z ;\U|C SZF[P

5|[S8LS, < !Z

(1) Access DF\ INVENTORY GFDGF[ V[S Blank Access Database AGFJF[P

(2) Table Design View GF[ p5IF[U SZL GLR[ 5|DF6[G]\ 8[A, T{IFZ SZF[P

lO(0G]\ GFD	5\|SFZ	SN	GF[\3
Item_No	Auto Number	--
Item_Name	Text	40	GFD BF,L CF[J]\ HF[.V[ GlCP
Item_Rate	Currency	--	lO(0 BF,L CF[J]\ HF[.V[ GlC4 ZSD 5) YL J3] VG[ 5)) YL VF[KL CF[JL HF[.V[P HF[ T[D G CF[I TF[ "Rate must be>50 and <500" V[JF[ D[;[H VFJJF[ HF[.V[P
Item_Units	Number	--	Units TZLS[ VF5[, ZSD ) S[ T[YL DF[8L CF[JL HF[.V[P

GF[\3 o 8[A,G[ Item_Master 5Z ;\U|C SZF[P

(3) Form Wizard GF[ p5IF[U SZL 0[8F V[g8=L DF8[G]\ OF[D" T{IFZ SZF[P

Form Tabular 5|SFZG]\ CF[J]\ HF[.V[P

Form GL Style Sandstone ZFBF[P

Form G[ Item Master 5Z ;\U|C SZF[P

(4) p5ZF[ST 8[A,DF\ !) SF(5lGS Z[SF[0" NFB, SZF[P

s!f RF[YF[ Z[SF[0" ;]3FZF[P

sZf K9'F[ Z[SF[0" N]Z SZF[P

(5) Query Wizard GF[ p5IF[U SZL 8[A,DF\YL GLR[GL lJUTF[ XF[3F[P

s!f H[ VF.8DGF[ Rate 60 YL J3] VG[ 100 YL VF[KF[ CF[IP

sZf H[ VF.8DGF[ Rate 400 YL J3] VG[ HyYF[ 500 YL J3] CF[IP

s#f H[ VF.8DGF[ Rate 200 YL J3] VYJF HyYF[ 300 YL J3] CF[IP

(6) Report Wizard GF[ p5IF[U SZL GLR[ 5|DF6[ ZL5F[8" T{IFZ SZF[[P

s!f ZL5F[8"DF\ TDFD lO(0; NXF"JJFGF K[P

sZf ZL5F[8";DF\ VF.8DGF GFD R-TFS|DDF\ VFJJF HF[.V[P

s#f ZL5F[8"GF[ Layout Tabular ZFBF[P

s$f ZL5F[8"G[ Inventory Stock Report 5Z ;\U|C SZF[P

5|[S8LS, < !#

(1) Access DF\ GLR[GF :8=SRZJF/] Table T{IFZ SZF[P

lO(0G]\ GFD	5\|SFZ	SN	GF[\3
No	Auto Number	--	Primary Key
Name	Text	40	BF,L G CF[J]\ HF[.V[P
Department	Text	4	GLR[GF 5{SL SF[.V[S C[FJ]\ HF[.V[P "PROD" VYJF "FINC" VYJF "MARK"
Category	Number	--	! VYJF Z VYJF # VYJF $

p5ZGF 8[A,G[ Employee Master 5Z ;\U|C SZF[P

(2) Access DF\ GLR[GF :8=SRZJF/] Table T{IFZ SZF[P

lO(0G]\ GFD	5\|SFZ	SN	GF[\3
No	Auto Number		Primary Key
Basic	Auto Number		X}gI VYJF T[YL J3] C[FJF[ HF[.V[P
DA	Auto Number		X}gI VYJF T[YL J3] C[FJF[ HF[.V[P
HRA	Auto Number		X}gI VYJF T[YL J3] C[FJF[ HF[.V[P
PF	Auto Number		X}gI VYJF T[YL J3] C[FJF[ HF[.V[P
IT	Auto Number		X}gI VYJF T[YL J3] C[FJF[ HF[.V[P

p5ZGF 8[A,G[ Employee Tran 5Z ;\U|C SZF[P

(3) p5ZGF A\G[ 8[A,F[DF\ 5F\R<5F\R SF(5lGS Z[SF[0" pD[ZF[P

(4) p5ZGF A\G[ 8[A,F[ JrR[ Relation :YFIL GLR[ 5|DF6[GF[ Report T{IFZ SZF[P

NORTH GUJARAT UNIVERSITY

PATAN

PAY BILL

-------------------------------------------------------------------------------------------------------

No. Name Department Basic DA HRA Gross PF IT DED NET

-------------------------------------------------------------------------------------------------------

GF[\3 o Report Department VG[ Category 5|DF6[ UF[9J[, C[FJF[ HF[.V[P

5|[S8LS, < !$

(1) Access DF\ GLR[ 5|DF6[G]\ Table T{IFZ SZF[P

lO(0G]\ GFD	5\|SFZ	SN	GF[\3
No	Auto Number	40	Primary Key
Name	Text	4	BF,L G CF[J]\ HF[.V[P
Subject	Text	1	"SP" or "BM" or "STAT" or "COMP"
Sex	Text	3	"M" or "F"
Caste	Text	--	"SC", "ST", "BA" or "GEN"
Marks	Number	--	> 0 VG[ < 100
Fee	Number	--	> 300 VG[ < 600

p5ZGF 8[A,G[ Student Table 5Z ;\U|C SZF[P

(2) p5ZGF 8[A,DF\ lJUTF[ NFB, SZJF Form Wizard GF[ p5IF[U SZL H~ZL 0[8F V[g8=L OF[D" AGFJF[P

(3) p5ZGF 8[A,DF\ !) sN;f SF(5lGS 0[8F NFB, SZF[P

(4) SJF[ZL lJhF0"GF[ p5IF[U SZL GLR[GL lJUTF[ XF[3F[P

s!f Subject="SP" VG[ Marks>60 CF[IP

sZf Caste="SC" VYJF "ST" CF[IP

s#f Sex="F" VG[ Fee>300 CF[IP

s$f Subject="SP" VG[ Sex="M" TYF Marks<50 CF[IP

s5f Marks<80 VG[ Fee>600 CF[IP