Bài giảng Làm quen với access

    



 

   


     



          !"#  $ %  &'$  ( !" )& (  !$ *+,-.% ' / 0. 1..23  . "$ ( )$4    5 6''5' 78  ( 9:;?<.3"))"+@*?<. 3AB"> C &;AD+B' !)AB">$ " E7 E<.3 :F)<.3" EFG 9H"2.,  ) +I+.23.4   4  (  J.3 6K>7!)    ,-.+1-C:+: :    ( J.378  / LM  (  )H 6+7!N C .. 1J.3 "  M23' 4  #,/
;H7J.3M "6?!...O7 H   4 PQ
9) ARST0) PR0ARU) ST0VARQ) WXTPSAX Y    Z    4 ARST0)PR0ARU)ST0VARQ"[7Z\]+/ 

 
 
  
^^__` SaQ0WQ0SAb UR
RWbcXTb Ud0e0eAfSAd0eSX0 g/_ ^^__h 0ebiT0AQWQSAQR UR
RWbcXTb Ud0e0eAfSAd0eSX0 j/_ ^^__` SaQ0WQ0SAb SX0ARU9Q0kAR0e Ud0e0eAfSAd0eSX0 l/_ ^^__m cTSAQ0ASab0e SX0ARU9Q0kAR0e Q0A9Q0 m/_ 
\]+ = 64"#,-;
 S'(M.4"6H'"6   M
 V 1"N$6"6Y+",   n 6J.!" 6 /L-. o= Y.!.,J./
 V . 1.2M 4"6'I O'52 .($ 6 "6/
    


 9H  N C  )"[2.,-..\]+) !:'(. "[ -.'5""' /W 1 $4YC N C ' # > p 7.H-.7 )(YH/


 
  


^^__` U
Wc U0SS g/_ ^^__` SaQ0WQ0SAb ^^__h U
Wc U0SS j/_ ^^__h 0ebiT0AQWQSAQR ^^__` SA9k U0SS l/_ ^^__m cTSAQ0ASab0e ^^__m SA9k Q9 m/_




 
 
U
Wc UR
RWbcXTb ^_  U0SS UR0e0eATSAR0eSX0 SA9k SX0ARU9Q0kAR0e ^_  Q9 Q0A9Q0 S*+D+  7 #J. q64 >" .EU
WcF 


!"
#
U
Wc`#  (  ,.q D N C `   $$ )6  !7Z)8+: :B -.)H-.:  ' ./ U:M>4 >" . MZ%".;4*+D+  7. J.H.)r7B  s.EnF  .E 4F/ $
%&'
()

 

!*
+*
P4J.ZU
WcEA<SU
WcF;
 4*+  +1-J.3U
Wc . ,+  Z :23U
Wc    +MC:\ .#/
 A<SU
Wc . ,+4":./
 ,
-
.
/0

t#D   !. C  ( 1J.3) M u4Z u>   : Y7 C(6J.!  4
    



vVW 4 ( 2.,*+'@./SH '.# H7,'w4 U
WcY+ (MJ.3)  (8  7) > " M ":  #D' U
Wc. ,)7M.s.)7 7M.///
'! > C.-4# D(
X0A9Xx0)AyQ Lz0)///Pr7$ 4'
!1 EO F C  4.6 # D/Pr7 47-.  . ,.q )C   (23!E{OF/9:; U7H= MJ.33Z '$  74$ )    PQUtEP 74F)SaX0AWR9AESY45F)UAbiT0PR0EU. 6(F)/// S4U
Wc M C-.7)r7.-.(E.F -4#D()r4(-. 'M.| 6) HQ O"""[ :M'M..   /  456
,
78
 9
9

2:;
4;v Z: 6.' U
Wc  q/L-. J. !Z  " ' q"[P
Q O""/ 2:;
6;v Z  7 . 1 !/Pr# D ( "[Y 4 7U
Wc  q/ 2:;
<;
.'2 Z2  7 1!)!+!+ u}( 1J.3r7)2 Z  /Pr(7$ /P$s. \47-.  . ,.q   /9:;S3 Z  ' $  74)   E( F 1 J. 3 ; ~A9€Sx0) ~UAbix0 Pd0)~AU9‚)~AUA€P)/// 2:;
=;v Z  #J.  7/0Yr7.2O2I .7 6!H.7' /S6| 7 HM}#J. /L= ,-!"C J.$)D J.#"[ q+ q . YY'!2.,./ 2:;
>;S !). u!'!/k= !'!71.Mr)7 .*+7)2OU
Wc+!H 6. 1..  2.,  q) qD '!J.q&7.'(/S    u"!'!!.,  1!/ 
    




  


 

 
 

 
 







!"#$%&'(






 








 
!
"#$
%
&
&'
()
#*

+
,
!
"-

"(.
()
#*/



&)*(+,


$


-$.(/-$"#( 0,1


2
!
2

!-(,3/4,3


 
+


"0
*
 
+1
2
3

 
+


 
!
3%

4
#5

6$
!
7*
()
#*
 $
!
"
"*.
4
*8
"#$
9(&-
8
+#
$"'
"-
: 5
;(*
6.
!
3
"
"8
8
$"'
"-
".
"<"
!
"-

=


"
"8
8
>
$"'
(*
-
=



2
!"#$56"1-,.7(89":"':!";+,
=
3

?"$


>*8
"#
('
7
"
3

=
2"-
.
3
"

+1
@*
"#
!
*
 
+1
%
3
"0
"-
3
+1
8
+1
*.
<<


    

2
 =
3-
@*
"#
!
.
*
(1

@*
"#
*'
3
"<"
98

@*
"#
*'
3
@*
"#/



2"-
1*$=:,>,*,=/("+1/,7=(/?@















2
-".0<89+(,.6
3-
('
7
&
&'
()
#*
!
"-


$
3-
('
7
"8
8
!
A

"
+





    

A
 "B(!".0 3
-"1(,1  
                   ! "#$%#%% & '()* +"*,*"  $-  '. /012! 3#$#%+%4 5&) +"*$63(  " 74  8 9   ! $#$3#%$,1). ',)" +**33%+  ( 5:    ! "#"6#%$3+; ',), +**"$3+  * 7& <   /012! %#"#%$33 7&  ',)" +%(6$%*  ,1& =. >  /012! %#"#%$%$1 .   ) +%(6*(%  31:2&    /012! #$%#%$3(5.? ) +3(6"3(  + 
  4  /012! #"6#%"$$(1 1 )  +"*$*3+  %&   1   ! 6#$#%"$$3= 7 ',)" +,*,", 
3
-":-"17  
5  ?   @8    ?9<0?9 ?&ABC C *"(1D 2'(50E90 F6*+G+,(3$63 ?9 !? ?  :&.+ 7    F6(G+",%$*(  =H
!I ?  J+(=   '"  F6(G+(*$3+ H H?9 .  -  8 K  & '" 50E90 F6*+G+3%,*(6 20
0?9 2I5<<K L & @36; ', '  F6"G+,"3%$

    

C
 3
"1D-"% 


2'  2' & KB  & .   &  ? $"6M*6  "=. A:?. 6M66  (=& 5 "+M66  *=. : ?. +M66  ,: 5 $"M3%  3 . 5 *M66  +?.@   ,$M*6  %2 @ 3666M66 
3
$"$1  
<
5
 N@<     6((  =H
!I 3 #*#% #*#% 6(* 20
0?9 % #*#% #$*#% 6(+  =H
!I  $#*#%$ $#$6#%$ 6*6 ?9<0?9 ( $#*#%$ "#*#%$ 6*, ?9 !? ( $#(#%" $#*#%"
3
-(!(,/$"$1   
<
2' 28N&  6((  "* 6(( " 6 6(*  $ 6(* , $6 6(+ 3 $( 6(+ + $ 6*6 , % 6*,  $*

    

E  ! 3;B

C





3;B


,B

    !   F    D   G !   F     DDDDE
 *6
A
C
D
FGHGIF
EDE

DDDDE
F/J
I
F
K
DDDDL
3
A
"
D
FGEMGIJ
EDE

DDDDL
J
F/J
ED
I
DDDDI
A*
C**
3*
D
EDGEFGIJ
EDE

DDDDI
F
F/J
F
F
DDDDK
3
3""
"
D
NGLNGIF
EDE

DDDDK
F
N
J
ED
DDDEN
 *6
"
O*
D
IGELGIJ
EDE

DDDEN
K
F/J
J
J/J
DDDEF
3
"
C*
D
EEGFGIJ
EDE

DDDEF
K/J
F
F/J
ED
DDDEM
 *6

3
=E
IGMGIJ
EDE

DDDEM
F/J
F
F/J
H
DDDLD
 *6
 "
;
=E
JGLMGIJ
EDE

DDDLD
K
F
F/J
F/J
DDDLJ
;**
A*
2
D
KGLNGIJ
EDE

DDDLJ
L/J
K
F/J
F/J
DDDLH

*
2"
D
EDGLIGIF
EDE

DDDLH
F
J/J
K
ED
DDDNE
 *6
A

D
KGEFGIJ
EDE

DDDNE
F
J/J
J/J
K/J
DDDNL
;
A
P
D
EGNGIJ
EDE

DDDNL
J
I/J
I/J
I/J
DDDNI
3
"
D
ELGHGIF
EDE

DDDNI
F/J
K
K
H/J
DDDNK
;
 "
"*
=E
IGLHGIF
EDE

DDDNK
F/J
H/J
F/J
F
DDDFN
"
C

D
EDGENGIN
EDE

DDDFN
M
F/J
K
J
DDDFF
A*
3"
6
;"
=E
HGLFGIF
EDE

DDDFF
H
I/J
I
ED
DDDFM

3"
C
P*
=E
EDGLEGIF
EDE

DDDFM
F
J/J
F/J
J/J
DDDJN
;*
"
3*6
D
ELGELGIF
EDL

DDDJN
F/J
J/J
H
M/J
DDDJF

A
3""
D
EEGEDGIF
EDL

DDDJF
F/J
F/J
F/J
M
DDDJM
 *6
3""
3"*
D
JGEEGIJ
EDL

DDDJM
F/J
ED
K
M
DDDHD
 *6
3*

D
KGIGIJ
EDL

DDDHD
L/J
F
F/J
K/J


;

 D -6) -(,.%   EDE
 *6
3""
"
 EDL
;
A
C
 
    

H  
3;B
C
CQ

  !   DE
"
'
3%
3"*#
DL
"
'
"1
1
DN
"
3%
'
DF
"
23R
P
A*)
31*

3;B
3
CQ
  !   DE
3"(.
S

*.
DL
A#
#*
>%6
(-
DN
A#
#*

%
6
0
DF
C.
"8
DJ
A#
#*
$"*-
*1
"6
"8
DH
C1
6
P
DI
"*-
#
9#

3;B

PB
I I   DD
TU
"
C1
 DE
;%
CV
C-"
 DL
"7
AS
 DN
Q
2.
;(&-
 DF
 *6U
AS
3.
 DJ
"-
3"W
A%
 DH
TU
*6
36'
 DI
;%
C*61"
T(.
 DK
 *6U
CV
 DM
*1
3"W
"(
RX


3;B

CQ
A
2C:RB
F I        HGEGMF
DI
DE
DE
NDDD
HGEGMF
DI
DL
DJ
JDLD
HGEGMF
DF
DN
DL
NDDD
HGEGMF
DM
DE
DE
NDDD
HGEGMF
DE
DL
DE
JDMM
HGEGMF
DF
DF
DN
NDDD
HGEGMF
DN
DN
DH
HKHE
HGEGMF
DI
DN
DF
NDDD
HGEGMF
DM
DN
DF
HIFJ
HGEGMF
DE
DN
DL
JNIF
HGEGMF
DL
DL
DJ
JDND
HGEGMF
DN
DE
DE
JJDL
HGEGMF
DN
DF
DF
JEDD
HGLGMF
DK
DF
DI
JDHD
HGLGMF
DM
DE
DN
JDED
HGLGMF
DI
DL
DJ
NDDD
HGLGMF
DH
DN
DH
NDDD
HGLGMF
DL
DL
DJ
IMMJ
HGLGMF
DH
DL
DJ
JMEJ
HGLGMF
DK
DE
DN
NIDD
HGLGMF
DD
DN
DF
JNHL

    


J