ms office 2003 in tamil

8/13/2019 MS OFFICE 2003 IN TAMIL

1/540


2/540

2

2Microsoftaccess (Title Bar).

. (MenuBar)(File), (Edit), (View), (Insert), (Tools),(Window), (Help) .

. (Tools ) (Bar) . (ToolBar).

-3

3(ToolBar).

1) (New):.

2) (Opn):: .

3) (Save): .

4)

(File Search):

.
http://vikupficwa.files.wordpress.com/2010/01/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-21.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-22.jpghttp://vikupficwa.files.wordpress.com/2010/01/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-21.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-22.jpg


3/540

5) (Print): .

6) (Print Preview):

7) (spelling): .

8) (Cut): .

9) (Copy) .

10) (Paste):

.

11) (Undo): .

12) (Office Link): .

13) (Analysis):

.

14) (Code):

15) (Microsoft Script Editor) :

16) (Properties):

17) (RelationShip) : .

18) (Microsoft Office Help): .


4/540


5/540

(General), (Database) ..

4..

.

4(Database Wizard) . .

(Steps) .

1. .

2. , , (Description)

.

3. .

4. (Primary Key).

5.

6.

I.

(New)(Table) .

II. MainMenu(Insert).


6/540

III. (Design view)).

Create a new

file .

2Getting Started Create a newfile. 2NewfileBlank Date Base .

5

5. Filename..db4..db1

Create.

6

6db4Data Base (Access 2003 file format)

.. (Open),

(Design), (New) .
http://vikupficwa.files.wordpress.com/2010/01/15-01-2010-61.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-51.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-61.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-51.jpg


7/540

.. 1. (Objects), 2. (groups)..

.(Table),

(Query), (Form), (Reports), (Pages),(Macro),(Module)

(Object), , , ,(New), (Macro),(Module)(New).

, ,(ControlPanel).

1) Create by Design view

2) Create By using Wizard

, .

1. Create Table in Design View2. Create Table by Using Wizard

3. Create Table by Entering Data

.(Favorite) . .

.

, . ,Ok .

.

(Status Bar).,


8/540

,,.

.

.

Create Table in Design View New.

7

7Table 1Table design view .

Table design view .

1) (field inputs).2)(field properties).

(field inputs),, .

(field properties), , ,, , , ,, .

. . .

164 ., , .

, ,,
http://vikupficwa.files.wordpress.com/2010/01/15-01-2010-71.jpg


9/540

.. .Ascii031.

.

(Date type)

Text :1255

Memo :165538

Number: .

Date / Time :

Currency:

Auto Number:

Yes/No:

OLE & Object :, , ,

Hyperlink: , ,, ,

8

(GeneralProperties)8.

1. (Field Size) 1-255

2. (New Value)

3. (Format)

4. (input mask)
http://vikupficwa.files.wordpress.com/2010/01/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-8.jpg


10/540

5. (Decimal Places)

6. (Caption)

7.

(Default Value)

8. (Validation Rule)

9. (Validation Text)

10. (Required allow 0 length)

11. (Indexed)

12. (Unicode Comparission)

Number:, , .

Text, Memo:,

@, &: , .

Date, Time:, , 23/11/05 10.32AM

Yes/No:1 -Yes, ONo, 1-True, O-False, 1-On, O-Off

(Decimal point):,015. .

.

(Caption):.

.(Validation):..


11/540

Field NameEmployee Code No..Date type AutoNo.Description. 9-.Description.

9

9-Employee Data(Field).Data Type F6. General.Format(Popup Menu)9-. Standard. .

10

TableFile Save as. 10Save As Save Table Table 1 To Employee 1

(As) TableOk .

(Field). .

, .

.


12/540

:

Insert => Row Insert Row. ,

.

:

.

1. Delete .

2. Edit Delete Row.

3. DeleteRow.

.

:

.

:

, . , .

:

, .

,. .. .


13/540

(Table)26Create table by using wizard.

11

11Table wizard .Business. Sample TableEmployee. Field

NameField>. Field Name.Field Name

Rename Field. Renamefield.(Field)Dearness allowanceOKNext.

12

12Primary Key. Next .Primary Key.


14/540

13

13 . Finish.

14

Employee 1 . Table14.

15

Create Table by entering

data6New.15Table1Table. Field 1-Code No., ,,,Yes12-12-1996125007500

employee-1 . 15

.
http://vikupficwa.files.wordpress.com/2010/01/15-01-2010-152.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-142.jpghttp://vikupficwa.files.wordpress.com/2010/01/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-13.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-152.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-142.jpghttp://vikupficwa.files.wordpress.com/2010/01/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-13.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-152.jpghttp://vikupficwa.files.wordpress.com/2010/01/15-01-2010-142.jpghttp://vikupficwa.files.wordpress.com/2010/01/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-13.jpg


15/540

RenameEmployee Code No.. Employee 1.

Table 46

New. 16New Table. 5Table

1. (Data Sheet View Spread Sheet):.

2. (Design View) : (Create Table in Design View).

3.(Table Wizard):.

4. (Import Table):.

5.(Link File):

.

.

16

ImporttableOK.
http://vikupficwa.files.wordpress.com/2010/01/15-01-2010-162.jpg


16/540

17

17Import.

Directory-FilenameImport.

18Import object.TableOption17 . .

18

..


17/540

19

Edit . 19Delete

19Delete.

20

1. 2. structure,structure and data,

data append.20 , .20Paste .. pasteoption. .

3. (Primary key)

. . ,


18/540

, .

1.

. .

2. .. 21Primarykey.

3. 21Edit. Primary key.

21

4. . 21(ToolBar)(Primary Key) .

5.Primary keyAuto Number field.

2003---3

2003---3
http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.files.wordpress.com/2010/01/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-211.jpghttp://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2010/03/14/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-3-%e0%ae%85%e0%ae%9f%e0%af%8d%e0%ae%9f%e0%ae%b5%e0%ae%a3%e0%af%88%e0%ae%af%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/


19/540

.

, (Records) . (Fields) .

,

(3-1).

Key stroke

(Next field) Tab

(previous field) Shift Tab

(first field of current record)

Home

(last field of current record)

End

(next record) Down Arrow

(previous record) Up Arrow

(first field of first record)

Ctrl + Home

(last field of last record)

Ctrl + End

(scrollup one page)

Pgup

(scroll downone page)

PgDn

(go to record number)

F5

3-1


20/540

(Navigation Button) . (Status bar) . .

1. , ,, .

, , .

(Record No)

(Enter key)

.

- 1

. 2000 . Getting Started Open . ok .

. . .
http://vikupficwa.files.wordpress.com/2010/03/accs3-1.jpg


21/540

(Enter) .

(Enter) . .

,

.

(Insert) -2-

(New Record)

. .

2

(Edit) . -3- Go to . (New Record) .
http://vikupficwa.files.wordpress.com/2010/03/accs3-2.jpg


22/540

3

.

4

(Record) . -4- Data Entry .

. (Edit) -3- Delete Record .
http://vikupficwa.files.wordpress.com/2010/03/accs3-41.jpghttp://vikupficwa.files.wordpress.com/2010/03/accs3-3.jpghttp://vikupficwa.files.wordpress.com/2010/03/accs3-41.jpghttp://vikupficwa.files.wordpress.com/2010/03/accs3-3.jpg


23/540

5

-5. . yes/ no

.

, ,

. ,, .

.

1. (Edit) -3- Delete Column .

2. (Insert) -2- Column .

3. . -6- Delete Column .

-5.


24/540

. yes/ no .

6

, Error .

, .

1.

2. /

3. /(Yes/no) .


25/540

-7-

(Invalid )

.

-7

1) (edit) -3- (Find)

.

2) -8- (binocular) .

3) Ctrl+F

Find Next .

4) Cancel


26/540

F2 . .

-8

:

3

Edit

Find -8- Find and Replace Replace .Find What . Look in . Match . Search All

. Replacewith Replace . -9- Doyou want to continue? (yes) (No) .
http://vikupficwa.files.wordpress.com/2010/03/14-3-2010-3-081.jpg


27/540

Replace All .

-9

-10-

ok .

- 10

F2 ()
http://vikupficwa.files.wordpress.com/2010/03/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-10.jpghttp://vikupficwa.files.wordpress.com/2010/03/14-3-2010-3-09.jpghttp://vikupficwa.files.wordpress.com/2010/03/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-10.jpghttp://vikupficwa.files.wordpress.com/2010/03/14-3-2010-3-09.jpg


28/540

.

Ctrl + ( ) .

Ctrl + Alt + Space Bar

Text Or Memo,

Ctrl + Enter

Shift + Enter ()

Ctrl + ; ()

Ctrl + :( ) Ctrl + +( )

Ctrl + -( )

Space Bar

Esc ()Undo .

:

1) ((Auto Number Field)) 11


29/540


30/540

1)

2) .

3) .

4) . .

:

) :

1) .

.

2) . ()

Format 12- Column width


31/540

12

13 . Column width Ok .

13

) () :

1)

.

2) . . ()

.
http://vikupficwa.files.wordpress.com/2010/03/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-13.jpghttp://vikupficwa.files.wordpress.com/2010/03/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-12.jpghttp://vikupficwa.files.wordpress.com/2010/03/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-13.jpghttp://vikupficwa.files.wordpress.com/2010/03/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-12.jpg


32/540

12 Row Hight .

14 (Row Hight) Ok .

14

:

Format .

-12- Data sheet .

-15- Data Sheet Formatting Ok . Cell Effect ? ? . Gridlines Shown

? . . Border and Line Styles . Direction ? .


33/540

- 15

:

Format .

12 Fonts .

1) Fonts 16- font

2) Font Style Bold

3) Size 12

4) Ok .


34/540

16

:

. Format 12 Hide Coloumn . . Unhide

Coloumn .

:

. Format . 12-

Freeze Column . Unfreeze Column .

:

:


35/540

( ) . .

. .

-

17

Record . 17- Sort . Sort Ascending Order or Sort Descending Order .

-18
http://vikupficwa.files.wordpress.com/2010/03/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-18.jpghttp://vikupficwa.files.wordpress.com/2010/03/14-3-2010-3-17.jpghttp://vikupficwa.files.wordpress.com/2010/03/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-18.jpghttp://vikupficwa.files.wordpress.com/2010/03/14-3-2010-3-17.jpg


36/540

:

Records 18- Filter Filter By Selection . Filter Excluding Selection . Filter By Form 19- Filter By Form .

-19

:

File . -20- Page setup .


37/540

20

21 Page setup Margins . (top), (Bottom), (Left), (Right) Print Headings Ok


38/540

21

:

20 Print Preview

. 22 .

Select File Print Preview Select Multiple Pages .


39/540

22

-22- , , Close . .

20- print . 23- print printer printer . print range Copies

Ok

.


40/540

23

:

About these ads

---4

.

,

(Records)

.

(Fields) .

.

. keystroke

1. ( next field) Tab

2. (previous field) Shift+Tab
http://en.wordpress.com/about-these-ads/http://en.wordpress.com/about-these-ads/http://vikupficwa.files.wordpress.com/2010/03/e0aeaee0aebee0aeb1e0af81e0aea4e0aeb2e0af8de0aeaae0ae9fe0aeaee0af8d-23.jpghttp://en.wordpress.com/about-these-ads/


41/540

3. (First field ofcurrent record)

Home

4. (Last field ofcurrent record)

End

5. (next record) Down arrow6. (Previous record) Up arrow 7. (first field of first

record)

Ctrl +Home

8. (Lat field of lastrecord)

Ctrl + End

9. (Scroll up one page) PgUp10. (scroll down one page) PgDn11. (go to required record

number)

F5

(Navigation Button) . (Status bar) . . 1 . , , .

, , .

(Record number) (Enter key) .

- 1

. 2000 2003 .
http://vikupficwa.files.wordpress.com/2011/06/4-11.jpg


42/540

Getting Started open . ok

. . .

(Enter key)

.

(Enter key) . .

, .

(Insert) -2- (new record) .

- 2


43/540

(Edit) . -3- Goto (new record) .

- 3

.

- 4

(Record)
http://vikupficwa.files.wordpress.com/2011/06/4-4.jpghttp://vikupficwa.files.wordpress.com/2011/06/4-3.jpghttp://vikupficwa.files.wordpress.com/2011/06/4-4.jpghttp://vikupficwa.files.wordpress.com/2011/06/4-3.jpg


44/540

. -4- Data Entry .

Delete . (Edit) -3- Delete Record .

- 5

-5. . Yes / No .

, ,

, , . , , . .

1. (Edit) .-3- Delete Column .

2. (Insert) -2- Column .

3. . -6- Delete Column .

-5.

. Yes / No .


45/540

- 6

, Error .

, .

1.

2. /

3. /(Yes / No).

-7- (Invalid) .


46/540

- 7

1) (Edit) -3- (Find) .

2) -8- .

3) Ctrl + F

(Find Next) .

4) Cancel

F2

.

.


47/540

- 8

:

3Edit (Find) -8-Find and Replace Replace .

Find What

. Look in . Match . Search All.

Replace with Replace .

-9-

Do you want to continue?

. (Yes) (No) .

Replace All .


48/540

- 9

-10- Ok .

- 10

(Edit technique)

. (Edit technique)

1.

2.

3. F2 ()

4.


49/540

.5.

Ctrl + ( )

6.

Ctrl + Alt + Space Bar

7. Text Or Memo, Field

Ctrl + Enter

8. Shift + Enter

9.

Ctrl + ;()

10.

Ctrl + : (

)

11. Ctrl + + ( )

12. Ctrl +( )

13.

Space Bar

14. EscUndo

:

1) (Auto Number Field ) 11

- 11

2) ( Calculated Field)

3) () (Locked or Disabled)


50/540

4)

:

1) 2 (Edit) . (Cant Undo)

2) Undo Typing .

3) Edit -> Undo saved documents CurrentField/Record .

4) Edit -> Undo

:

.

1)

2) .

3) .

4) . .

:

) :


51/540

1) . .

2) .

()

(Format ) 12- Coloumn width

- 12

13 . Column width Ok .

- 13

) () :

1) .


52/540

2) . .

() . 12 (Row Hight ) .

14 (RowHight ) Ok

- 14

:

Format . -12- Data sheet .

-15- Data sheet Formatting Ok .

Cell Effect ? ?

. Gridlines Shown

?

.

.Border and LineStyles . Direction? .


53/540

- 15

:

Format . 12 Font .

1) Font 16- Font

2) Font Style Bold

3) Size 12

4) Ok .


54/540

- 16

:

. Format 12 Hide Coloumn . . Unhide Coloumn .

:

. (Format) . 12- Freeze Column . Unfreeze Column .

:

:

( ) . .


55/540

.

.

- 17

Record . 17- Sort . SortAscending Order or Sort Descending Order .

- 18

:

Records 18- Filter Filter By Selection . Filter ExcludingSelection . Filter By Form .19-Filter ByForm

.


56/540

-19

:

File . -20- Page setup .

- 20

21 Page setupMargins . (top), , (Bottom), (Left), (Right), (Print Headings) Ok

..


57/540

- 21

:

20 Print Preview . 22

.

Select File Print Preview Select Multiple Pages .


58/540

- 22

-22- ,, , Close . .

20- print .

23-

print

printer

printer . .print range Copies Ok . .


59/540

- 23

---6

,

. , (query) , . .

1 . (select query ) .

2. ( total query) .

3. (action query )


60/540

4. (Cross tab query)- .

5. ( SQL)

6. (n) (Top(n) ) .

() . .

.

. ., . . , .

. , .

.


61/540

1

1 .

1. (view )

2. (save)-

3. (query type)-

4. (run)

5. (show table)-

6. (properties )

1 . (object) .

2 . (new button) ( ) .


62/540

2

2 (New Query) ,

1 . ( Design view )

2 . ( query wizard )

3. ( Cross tab qury wizard )

4 . (Find duplicates query wizard )

5 . (Find unmatchedquery wizard)

ok .


63/540

3

3 query1 .select.Query Show Table .

Show Table Add . Close .

3 Query1Select.Query . . . (field Name), (Table Name ),(Index), (criteria), (show) . .

6 (F6) , .


64/540

1 . ,

. .

2 . .

3 .

Dropdownlist .6 .

1 . (Edit)

.

5

(Edit)

Delet . .

2 . . Shift .

3 . .

4 . .


65/540

Ctrl . .

. .

1 .

.

. .

2 . (-) .

.

View .


66/540

4

4 Data sheet view . ,

.

. .

Delete .


67/540

.

-2(F2) .

/

. view .

4 (view) Table Name . .

.

.

(New Query) .

Delete . .

Memo,OLEobject (sort).

.


68/540

, . sort . . (Ascending order)

.

. . .

(criteria) . .

. . Edit .

5

5 Delete .


69/540

.

. Criteria . Both . criteria . . .

.

, View

Data Sheet . Print . Print . Print ok . .

, . .File Save . , ok

.

1 . Close .

2 . Close .


70/540

3 . Ctrl F4 . .

. (Queryobject) .

(New query) .

(Design view)

.

Show table ok .

Close , Showtable .

. .

.

. Edit . delete .


71/540

. Showtable . Show table

Add . Close .

. .

6

6 . View .

table name .


72/540

, Shift . .

, Show table , .

7 .


73/540

7

. view . join

properties .

join properties 8 . ok .

, . delete . .

. (inner Joint orEqual Joint), (Outer Joint), (self Joint),


74/540

(Cross product joint orCartesian joint)

( Equal Joint)

.

(Right Outer Joint) .

( Left Outer Joint) .

View .

joint Properties .


75/540

8

8 joint Properties

(Equal Joint )

.

.

.

(Cross product jointor Cartesian joint) , , . , .

, .


76/540

6X8=48 .

--7

, .

, .

(square) (^), (multiple) (),(division) (/), (addition(+) , (subtractions)(-), .

:

, . =(X )

,

:

, . = ()+()

.


77/540

:

. . = ( )-() .

:

. . =( ) / ) . .

(integer division)

1009-6=15.28 } 100/6=16.66

100/6= 16 .

109/6.6=14 ( 6.6 7 )

(^)

.

4- 2^2 .

(relational operator)

(equal)(=), ( not equal ), (less than)() .


78/540


79/540

(Single value field criteria)

.

, . . QBEcriteria . . . .

wild card(?) . .

? (wildcard). .


80/540

-7.1

1 (objects) (queries) . products . new .


81/540

2

2 show table . add . close show table .


82/540

3

3 . (mouse) (pane) . criteria 3 .

(view) . (data sheet view) .

.

(non-matching value)


83/540

.

.

(lessthan () (equal (=) .

=

. .

yes, no. Not,

.

OLE

OLE . is not null .

(Complex criteria)

. and, or .

and ,or and, or .


84/540

4

1,2,3 , (criteria) (or) 4 .

. .

and,or .


85/540

5

1,2,3 (criteria) 5 . or .

or


86/540

6

. 1,2,3 (criteria) 6 .

or .


87/540

7

1,2,3 (criteria), (or) 7 .

QBE or

or . or (,) .


88/540

8

1,2,3 (criteria) 8 .

(view) (view) . (Datasheet view) .


89/540

9

9 6,7,8 .

or.

between, and .

between, and . between and between, and .


90/540

.

.

---8

(Creation of Forms)

, , . .

, .

.

250 .

1) (Columnar Forms) :

.


91/540

. (Switch Boards), ,

2)(Data Sheet) : .

3) (Tabular Form) : .

4)/ (Main / Sub Form) : .

5) (Pivot Table Forms) : .

6)(Graphics ) : , , ,

7) (Design View ):

8) (Form Wizard):, , .

9) (Chart Wizard):

10) (Pivot Table Wizard): .

, ,


92/540


93/540

6) -1 New Form Auto Form:Columnar .

-1

-2 . .

.


94/540

-2

1) (Insert). (Forms) .

2) (Objects) (Forms) .

(New) (Open) .

3) (Combo box) . , .

4 Form . (Form Wizard) (Form Wizard) .

. 3 Create form by using wizard


95/540

(New) .

-3

4

Form wizard

. . Available Field .> >> . Selected Field

.


96/540

-4

<

.


97/540

-5

6 Columnar, Tabular, Data Sheet, Justified .

Columnar, Next .

-6


98/540

(Style Form)

-7 Form wizard . standard Next .

-7

-8 What title do you want for your form? Finish

.


99/540

-8

sheet1 -3 .

. Open . -2 .

1) .

2) (Properties) .

3) .

4) . .

(Tool bar)


100/540


101/540

-10

---9

(ControlTools)

(Control ) (Lable) (Text Box) .

.1. (Text Box)

2.

.

) (Option Group)

,


102/540

) (Toggle Button)

(up), (down)

) (OptionButton)

. / .

) (Check box)

) (Combo Box)

(Pop up list )

) (List Box) , .

) (CommandButton)

. .

) (Sub FormControl)

) (TabControl)

.

3.

(Graphics And Picture Control)) (Unbound Object Frame)

, , ,

) (Bound Object Frame)

, , ,

) (Line)

) (Rectangle) ,


103/540

) (Page Break)

(Label Control)

, , , . .

. . . .

. .

.

.

, , (Toggle Button, Option Button, Check Box)

Yes/No, True/False, On/Off , .

(Option Group)


104/540

, , .

.

(List Box)

. .

.

, , .

(Combo Box)

. .

(Tab Control)

. .

. .


105/540

. .

1. Form .

2. Create Form in Design View .

3 (New) .

4.New Form Design view .

5. (create new form) ok .

-1

1 .


106/540

.

.

1 .

2. .

. . .

. View . 2 Field List . 2 .


107/540

-2

1.

..

2., , , , , .

3. ,

.

4. .


108/540

. . .

.

-3

1.3 . Shift .

.

2 Ctrl . .


109/540


110/540

-4

. .

.


111/540

Shift

.

.

-5

. Undo Move Undo Sizing .


112/540

. Format

. Align . Left , Right, Top , Bottom .

-6

To Grid.. view . Grid format . snap to grid . . format .

horizontal spacing vertical spacing .


113/540

-7

format . size . to grid, to tallest, to narrow, to widest .

-

8


114/540

shift . format group .

.

format . Ungroup .

.

. . delete cut

(key board)

Delete

.

. . Copy . . Paste .

.

1. .


115/540

2. .

3. . .

4. . Cut .

5. . Paste . .

---10

1 . 1. 2. 3. .


116/540

1

, ,

.

.

: . .

: . .

: .

.


117/540

1. , (view) . (properties) .

2. . (properties tools) .

3. .

4. .

.

1.(format): , , , , , ,

.

2.(data): , , , , , , .

3.(Event): , ,

.

4.(others) : (.) , . ,, , , , , .


118/540

.

1.

2.

3. . .

4. .

5. .

6. .

.

1.

.

2. . (.) .

3. .


119/540

4. , ,, .

1. .

2.

3. . captioned properties .

4.

5.

1. ( )

2. (

)

3. (, )

4. .

5. .

, .


120/540

yes no .

.

1. .

2. .

3. .

2

Table Product . . Cur Reserve Price shift . complete


121/540

. 2

.

(View . Header/Footer .

1.

2. Text Box

3. . + . unbound

.

4. Mem features

5. . 3


122/540

3

1.

2.

3. .

.

1.

2. Bold

3.

4. 14 .


123/540


124/540

4

1. (View) . Tab Order

. Tab Order .

2. Auto Order .

3.

4. Ok .


125/540

5

5 .

1.

2.

3.

4.

Expected Profile

5. .

6. Control Source Property (cur sale pricecur cost )


126/540

7. Currency

8.

6

6 .

7


127/540

OLE Picture . .

image .

image: Picture . (Directory) .

. 7 .

2003---11

2003---11

.. .

.
http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/http://vikupficwa.wordpress.com/2011/08/16/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-11%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%99%e0%af%8d%e0%ae%95%e0%ae%b3%e0%ae%bf%e0%ae%b2%e0%af%8d-%e0%ae%a4%e0%ae%b0%e0%ae%b5%e0%af%81/


128/540

,

.

, : .

., . . -1- .


129/540

-1

: .

1. .

2.


130/540

-2

3. -2- On site, On field

4. Next

-3

5. -3- Yes ,the Default choice is : on field


131/540

6. Next

7. -4- . . 100,200,300

-4

8. Next

9. -5- Store the value in thisfield : in auction type


132/540

-5

10. Next

11. -6- Option button Raised

.

-6

12. Next


133/540

-7

13. -7- (Caption) . (Caption) .

14. finish -8-

. -8

:


134/540

Properties (Properties)

Name .

:

. Format Align . . (Fit)

Yes / No :

1. Yes / No .

2. Yes / No .

3. Yes / No

.4. Yes / No .


135/540

-9

:

1.

2. -9- Picture

3. Builder

4. Browse Ok 5. -10-


136/540


137/540

4.. -11- (combo boxwizard) /

.

-11

5 Next

6. -12- / Next .


138/540

-12

7. -13- (Available fields ) (Selectedfields) >

Next .

-13


139/540

8. -14- (sort) . (Ascending

order) Next

-14

9. -15- Next


140/540

-15

10. -16- Storethevalueinthefield Next

-16

11. .


141/540

. . Finish

-17

:

1. Seller .

2. -18-

3. Change to . Combo Box .


142/540

-18

4. (RowSource) Builder .

5. -19- Showtable

Add

3. .

7. Showtable Close


143/540

-

19

SQL Builder :

1. Company Last Name, Contact ID, Contact Type .

2. Last Name Contact Name, CharLast Name & , & Char First Name

3. Sort Ascending .

4. Contact Type Seller Or Buyer

.

5. Criteria Seller (or) Buyer .

6. .

:


144/540

1.Seller -19- Properties . -20-

ComboBoxSellerID 3 .

2. Yes

3. 2,2,0 .

4. 3

.5. 4 . 6. Yes , -20-

-20


145/540


146/540

, ,

-1-

-1

1.

2.

3.

4.

5.


147/540

1 .

2. -2- Edit .

3. Duplicate .

-2

4. -3-


148/540

-3

5

6. -4- Fill/Backcolour, fill / Fontcolour . 7. Transparent


149/540

-4

8. -5- Format . sent back .

Duplicate -

4-

-5


150/540


151/540

3. /(font/front color)

4. B .

5. 10 12 .6.

7. -6-

1.

2.

3 .


152/540

1.

2.

3. Shift . .

4 . Format . SpecialEffects

5. Format 3

6.

1.

2. . Format .

3. SpecialEffects

4. SpecialEffects

5. -7-


153/540

6.

. SpecialEffects . 7-

-7

Bitmap

1

2. (properties)


154/540

3. (properties) (Pictureproperties) .

4 Bitmap (Directory) . .

5 Bitmap

1.

2. . Format .

3. -

8- Format Auto Format .


155/540

-8

4. Auto Format

5.. Customize

6. -9- CustomizeAutoFormat

7. OK

8.

OK

9. -9-


156/540

10. OK

-9

2003--

-

13-(subform)

2003---13-(sub form)

.
http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.files.wordpress.com/2011/08/12-9.jpghttp://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/http://vikupficwa.wordpress.com/2011/08/27/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-13-%e0%ae%89%e0%ae%b3%e0%af%8d%e0%ae%aa%e0%ae%9f%e0%ae%bf%e0%ae%b5%e0%ae%ae%e0%ae%a4%e0%af%8d%e0%ae%a4%e0%af%88sub-form-%e0%ae%89%e0%ae%b0/


157/540

(Form) :

.(Continuous): .

(Data Sheet) :

(Wizard ) (Sub Form) 1. (Object) (Forms ). ( Toolbar ) ( New ) .


158/540

-1

2. -1- Newform Form Wizard tbl sales Ok

-2

3. -2- Form wizard

. Available Field


159/540

> . Tables/Queries

tbl sales lineitems > Selected Field Next

-3

4. -3-

How do youwant to view your data? ?? Formwith sub Form Next


160/540

-4

5. -4-What Layout would you like for your subform? Next

-5


161/540

6 -5- What Style would you like? Stone Next

-6

7. 6 Finish


162/540

-7

7

-8

(Continuous Form).-

8- .


163/540

. (Continuous Form)

. . Form Footer Visible Property No .

No .

(Adding sub formin the main form)

1.FormSales .

2. (object)

(Form) .

3. subsaleslineitems FormSales .PaymentMethod .


164/540

4. L(Subformcontrolpaymentmethod) (Delete)

.

5. .

6. .

.

.

1. .

2.

.

(ReferenceControl)


165/540

SumofLineitems

Sumoftotal lineitems () .

(Calculated)

-9


166/540


167/540


168/540

(Combo Box)

Buyer sales Buyer Buyer- tbl

contact

Buyer-

Source Builder (query )

2003--

-14- 2003---14- . .
http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/01/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-14-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88-%e0%ae%a4%e0%ae%af%e0%ae%be%e0%ae%b0%e0%ae%bf%e0%ae%a4%e0%af%8d%e0%ae%a4/


169/540

.

. .

(Report

Header)

(PageHeader)

(Group Head)

.(Details)

(GroupFooter)

(PageFooter)


170/540

(Report Footer)

.

.

1. (Tabular Report)-1-

-1

2.(Column Report)-2-


171/540

-2.

3.

4. -3-


172/540

-3

1. .

2. .

3.

4.

.


173/540

1. Insert=> Report =>

2. (object)(Report) Toolbar=> New =>

3

(new)

(report) .

4.

. .

(report) (new)


174/540


175/540

6. (LabelWizard):

(Report Wizard) .

(choose the table or query where the objects data comefrom ) Tbl Sales Ok

-5

-5- ?(Which Field do you want on your report? Available Field?) Available Field >

>> Selected Field


176/540

. tables/queries

Available Field . Next

-6

-6- report wizard

? (Do you want to add any grouping level?) . > >> Category

Priorities


177/540

Priorities

-

7

-7- Grouping intervals What grouping intervals do you want for group level fields? Group level fields ids invoice number, dtminvoice date Group interval normal,month

ok


178/540


179/540

-9

Summary Option .

-9- Summary Option . Detail andSummary Summary Only Calculate Repeat Total for Sum

., , Ok . -8- Sorting report wizard Next .


180/540

-10

-10- report wizard How could you like to lay our your report?

. (Layout) (Orientation) Next


181/540

-11

-11- report wizard What Style Would You Like? .

Next


182/540

-12

-12- report wizard tblsales1 what title do you want for your report?

. preview report modify the report design Finish file=saveas=> save as

save file=print=> print Ok .


183/540

2003---15-

2003---15-

1. F11 (function key) .

2. (object) (report) .

3. (new)

. (new report) (dialog box) .

4. (design view) .

5. (combo box).

(drop down menu) tbl Product .

6. ok .

7. -1-
http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/http://vikupficwa.wordpress.com/2011/09/05/%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-16-%e0%ae%aa%e0%af%81%e0%ae%a4%e0%ae%bf%e0%ae%af-%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%95%e0%af%8d%e0%ae%95%e0%af%88%e0%ae%af%e0%af%88-%e0%ae%a4/


184/540

-1

. .

shift .

. . ctrl

.

. .


185/540

(Label)

1.-1- . .

2. (Label) .

3. .

4. .

5. Sample List of Companies (Enter ).

-2

.

1. Sample List of Companies


186/540

2. Format Bold . 3. 18

4. -2-

(Function)

.

1.-3-

2 (text box) .

3. (vertical scroll bar) .

4. (label control). 5. page .

=page ( Enter)

.6.

7. .


187/540


188/540

1.-4-

2.

3. Can Grow

4. Can Grow yes

-4

1. Sorting and Grouping

2. -5- Sorting and Grouping .


189/540

3. tblproduct

4. chrcategory .

5 .

-5

1. Sorting and Grouping

2. -5- Sorting and Grouping Chr Category

Header 3. Group

4.


190/540

5. Yes

Sorting and Grouping (Selector Bar) .

.Sorting and Grouping

(Selector Bar) GroupHeader . (Enter) No

. No .

. . Box)Edit. Before

section)


191/540

-5- (LineTools)

shift . 2pt

-4- . now()

Control Source Properties

=

. dste() =Controls Format Properties General Date . .

file=>save as=> . .

2003---16- (creation ofsub report)
http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/http://vikupficwa.wordpress.com/2011/10/05/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d-2003-2/


192/540

2003---16- (creation of sub report)

,

.

(Calculate Running Sum)

1. -1- dtm invoicedate-

invoicesubtotalcontrol

-1

2. .
http://vikupficwa.files.wordpress.com/2011/10/1.jpg


193/540

3.

4. runningsum .

5. runningsum .

6. overall .

7. (labelcontrol ).

8. runningtotal .

9. -2-

-2

(Calculating percentageusing total)


194/540

1. (Detailsection ) Invoice total control Invoice Percent .

2. Amt Due .

. ControlSource = (invoice total) / (Sum of invoice total)

4. TotalPercent . -3-

-3

(Change Report Width)

.

.

(calculating group summaries)

1.

.


195/540


196/540


197/540

-4

(Creating a querythat uses a query)

-5

-5- TableSales QryCalculatedTotalextension byinvoice,

Qry calculated total payment by invoice . tablecontact
http://vikupficwa.files.wordpress.com/2011/10/5.jpghttp://vikupficwa.files.wordpress.com/2011/10/4.jpghttp://vikupficwa.files.wordpress.com/2011/10/5.jpghttp://vikupficwa.files.wordpress.com/2011/10/4.jpg


198/540


199/540

View=>Total => .

(Add-ins subreport form in a report)

1.rpt examplestartreport .

-7


200/540

1. subform/subreport .

3. InvoiceNumber

. Amountdue .

4. -8- (sub report wizard)

-8

5.

use an existing reportform

.

6. Subsalesreportexamplereport .

7. next


201/540

-9

8. -9- define myown Form/Report Field

Idsinvoicenumber Sub Form/Sub report field Ingsinvoicenumber

9. next

10.. -10-

finish


202/540

-10

11. -11- paymentsubreport 12.

payment

(fontcolor) (Backcolor)


203/540

-11

(Creating a sub report referring to a summary control)

-12
http://vikupficwa.files.wordpress.com/2011/10/12.jpghttp://vikupficwa.files.wordpress.com/2011/10/11.jpghttp://vikupficwa.files.wordpress.com/2011/10/12.jpghttp://vikupficwa.files.wordpress.com/2011/10/11.jpg


204/540


205/540

= (rsub sales payment example)(report) ! (tax total payment)

rsubsalespayment txt report totalpayment -13-

-13

-2003 ---17 (Creating meeting table)

-2003 ---17 (Creating meeting table)
http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.files.wordpress.com/2011/10/13.jpghttp://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/http://vikupficwa.wordpress.com/2011/10/12/%e0%ae%85%e0%ae%b1%e0%ae%bf%e0%af%8d%e0%ae%a8%e0%af%8d%e0%ae%a4%e0%af%81-%e0%ae%95%e0%af%8a%e0%ae%b3%e0%af%8d%e0%ae%b5%e0%af%8b%e0%ae%ae%e0%af%8d-%e0%ae%85%e0%ae%95%e0%af%8d%e0%ae%9a%e0%ae%b8%e0%af%8d/


206/540

.

1. (Object) (Report)

.

2. (New ) .

3. -1- New Report label wizard .

-1

4. (table or query)(dropdown box) tblcontact ok


207/540

-2

-2- label wizard . . Product Number C2160

Dimensions . Number across 3

Next .


208/540


209/540

-4

-4- Available fields > proto type label

next

-5
http://vikupficwa.files.wordpress.com/2011/10/53.jpghttp://vikupficwa.files.wordpress.com/2011/10/43.jpghttp://vikupficwa.files.wordpress.com/2011/10/53.j

ms office 2003 in tamil

Documents