:
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. .
__________________