.
, . (Queries) (New). , \ (Insert \ Query). (. 2), .
. 2.
:
Ø - (Design View);
Ø - (Simple Query Wizard);
Ø () - (Crosstab Query Wizard);
Ø - (Find Duplicates Query Wizard);
Ø , - (Find Unmatched Query Wizard).
/ . , , , . , , , .
, .
. (Queries) : \ (. 2), (Design). . , Access (Query), , : , , . .
(. . 1) :
Ø , ;
Ø (, , , , SQL-);
Ø , ;
Ø ;
Ø ( , ).
, QBE.
|
|
, , .
(Show Table), ( )
\ .
Access . (Query) , .
SQL
\ SQL (Query \ SQL), SQL - ( , ). (QBE -), , , SQL. , - .
:
Ø \ (File \ Save);
Ø \ (File \ Save As)
Ø \ (File \ Export);
Ø (Save) ;
Ø .
3.
3.1. -
QBE SQL
.
R , R[B], ,
SR[B] = , , R , .
R[B] = { r[] }
.
, , . , . , .
QBE ( ) ü ( ) .
1.
.
:
_1 = [_, _]
QBE. :
_1
_ | _ | |
ü | ü |
SQL :