+
1 2 2
  1. #1
    Status
    Offline
      amr mohammed
    50%
    Sep 2008
    Alexandria, Egypt, Egypt
    431
    6145

    access


    :
    1- ( ).
    2- ( ).
    3- .
    4- .
    5- Menu Bar.
    6- Toolbar .
    7- .
    8- Modules .


    :
    :
    Text ( Primary key )
    Text
    Number
    Date/Time
    Number
    .
    ( ) ( ).

    :
    Text ( Primary key )
    Text
    Number
    Date/Time
    Number
    ( ) ( ).

    1- ( ):
    1) Queries New Design View.
    2) Query " ".
    3) " " " ".
    4) Sum Query Design bar ( ).
    5) " Group By ".
    6) " " Combo ( Sum ) " " " Group By ". " " .
    7) Query .
    8) Run.

    2- ( ):
    1) Queries New Design View.
    2) Query " ".
    3) " " " ".
    4) Sum Query Design bar ( ).
    5) " Group By ".
    6) " " Combo ( Sum ) " " " Group By ". " " .
    7) Query .
    8) Run.

    3-
    :
    1) Queries New Design View.
    2) Queries ( ).
    3) " " " " Add Close.
    4) Join " " " ".
    5) Query " ".
    6) " " " Sum of " " Sum of ".
    7) Calculated Field Build Query Design.
    8) " Expression builder ". Double Click " Sum of " ( - ) ". Double Click " Sum of ".
    9) . " " :
    :[SumOf ] - [SumOf ]
    10) Query Run.


    Relationships Join:
    Relationships Join

    " " .

    4-
    Design View .
    .

    5- Menu Bar
    Menu Bar ( ) Access.

    :
    1) View Toolbars Customize Database Window..
    2) " Customize " 3 ( Pages ).
    3) " Toolbars ".
    New.
    " ".
    4) Commands.
    Scroll Bar " Categories " " New Menu ".
    Click New Menu " New Menu " Commands.
    New Menu .
    5) New Menu .
    Right Click Name " ".
    New Menu " " Name.
    New Menu " " Name.
    New Menu " " Name.
    6) " " .
    All Forms "Customize" " ".
    7) " " .
    All Queries " Customize " " ".
    8) " " .
    All Reports " Customize " " ".
    9) Macro " ".
    10) Toolbars Properties.
    11) :
    Selected Toolbar: .
    Toolbar Name: .
    Type: Toolbar ( Menu Bar Tool Bar Popup ) Menu Bar.
    Close.
    12) Close.

    6- Toolbar
    Toolbar Access Database Window Toolbar.

    :
    1) Database Window.
    2) View Toolbars Customize.
    3) Toolbars New.
    4) Toolbar Ok.
    5) Commands.
    6) Category ( Save Print Dž ).
    7) Close.

    7-
    :
    1) Tools Start Up.
    2) :
    Display Form: Combo f1 .
    Display Database window: .
    Display Status bar: .

    Application Title: Microsoft Access.
    Application Icon: Access ( ).
    Menu Bar: " ".
    .
    3) OK.
    4) .


    Extension " *.ico ".
    Shift .

    8- Modules

    :
    " " :
    Text ( Primary key (
    Text
    Salary ( ) Number
    Tax ( ) Number
    Insurance ( ) Number
    Subtraction ( ) Number
    Bonus ( ) Number
    Overtime ( ) Number
    Addition ( ) Number
    Net ( ) Number

    :
    1) .
    2) Ok.
    3) Design View.
    4) Text Box Salary Right Click Properties.
    5) " After Update " Events .
    6) " Choose Builder " Code Builder.
    7) :
    ( Salary ).
    ( AfterUpdate ).
    Private Sub Salary_AfterUpdate () End Sub:

    Private Sub Salary_AfterUpdate()

    [Tax] = [Salary] * 0.4
    [Insurance] = [Salary] * 0.2
    [Subtraction] = [Tax] + [Insurance]
    [Bonus] = [Salary] * 0.01
    [Addition] = [Bonus] + [Overtime]
    [Net] = ([Salary] + [Addition]) - [Subtraction]

    End Sub
    8) Copy Module AfterUpdate Change. .
    __________________






    ( )

    :

  2. #2
    Status
    Offline

    10%
    Jul 2009
    29
    0