Microsoft Access

!" Access
Access # $ %& ' ()

%* +, -. # ! *
0 - ! *–/
& 3 4+56 7 % 8. # 9. : # 2 1
0 ) –
%; , <!= ' 0 ) –/
'> : ( # 0 ) –1
@ +, ' # 0 ) –?
%* +, A B C! D . 2 2
I !$H G @ EF 2 2
%( C! A !$H 2 2 2
A C! A !$H 2 2 2
%CJ !C7 2 2
0 K 5*' 2 2
0' B C! # ' 7 2 2
7 (C! 2 2 2
3( 0 ' ># 2 2 2
7 @' ' ># 2 2 2
0 L 2
0 L A !$H 2 2
 Microsoft Access

0 L ) 2 2
%; , $ ' 0 L ! *–/
'> : ( # 0 L ! *–1
% 5* ' 7 2 2
%# E(. A B 0 L 2 2
0 L ' !M 2 2
% O N2 2 2
% OA N2 2 2
A ( ' A 0 L 2 2
B $ B D 93 # % B 0 L 2 2
%F 7 A B 0 L 2 2
A: #A 0 L 2 2 2
%6 = A 0 L 2 2 2
% P; A 0 L 2 2 2
2
) 2 2
%; , <!= ' ) 2/
' > -98# ) 21
) A & ' 2?
' ' ># : ( 2 2
A # 6 ' ># ' . 2 2 2
( 7– 2 2
&' >$2
Q' >$ ) 2 2
%; , $ ' Q' >$ ! * 2/
' > -98# Q' >$ ! * 2 1
Q' >$ ) A & '–?
0 B 7 2
7 ) 2 2
7 AB R 2 2 2
7 A BS 72 2 2
S 7- A . $'T 2 2 2
'7 )A B 7 2 2
 Microsoft Access

& DBASe ! "# $ %

0( )' *+ ,-. ' "# $ % / % ! FoxPro ' FoxBASE
1%2 ' ( % )' 3%2 4 " 5' / - % 1%2 "# $ % /
0 8% 9 * ' (6 3%2 # % 7
9 :+ ! +;< 3* 9 = 3 ! / + Microsoft Access
0 ! >
& ! > 3= # ? % ' ! ' @ +;< ! A 4 " ! +;< 3-% Access
0 ! ' @ +;< $'"B @ C ' ! > % 3= # /
@ +;< & D% @' 3% - E= 6 ! E F ? . @ G 3= # Access
D "# $ % / ( ! H> ' ' ! > I8 J' ) / ' *% K
0( RDBMS L @ +;< ( :9
M8 < .% @ +;< N.% I @ +;< % ! * J O F
' ( , GP J A ! 3 Q ' ' ! .% N.% $ *% R6.
0 S ' ! + '
' G &! % % &J & ' T & + &/ @ G ( = > / Access
0 .% !)' ,8> 3%2 U ( # ' *% K ' C'
- J1 / 3%2 * K ( @ +;< ( 9 3 => Access
0 !*%
& ) ' S & J' ) N & ! +;< 3-% 3 J C ( 2 !F '") /
/ & S; V WB L * *X < ' Y '@ "
0 ! V S; 8* / & S 9A ! 8* ( /-* Z PB
0 > >;+ (
 Microsoft Access

! " #$

Access % "& ' (

*"* +, - . ( )
' W @ G 3= # ' WB > ( @ +;< + *N ! +;< D%
[ $%S %6 D ) 3 = JO F &( ! !C L
0 K .% T '? X &
3 9A ) ' !-% 3 9A & N @ +;< , 3= # + *N ( /-* / 7*
0 ! %
0 ! ! +;< 3-% ! % *% \ # *

/ 0 Access )
! $ N% ! ]' 3-% / I8 ( ! +;< 3-% ( : 9 D ^9
`( 3%2 !_F
0 K D% ! E F •
0 3%2 *% = # ' N 9) & SORT & •
0 3%2 ! +;< ) J' ) 3 ' a ' •
0 D% ) @ " ? %U •
0 N b < !% ' J •
0 "# $ % % N •
0 3 *% ' C& 'G ? % '"# •
0 " ' & 3 #? % 3 •
0 -8 ,1 9 D - •
0 3%2 H# ' @c - ! - •
0!9 % % % ' - •
0( % "# $ % ! - •
0( @ +;< : 9 F - •
 Microsoft Access

000' •

2 ,* 7," " " 8 Access * 1 " 2 3 4 5 6 )

"# $ % / ! d "# $ % / ! +;< 3-% ( ' !A <
` 8+ Access ! +;< 3-% ) !=C d & ! !e
Tables, Querise, Forms, Reports, Macroes, Modules,

(Tables) ! )
f G6 ? X @ +;< , J' ) & ! > K J' )
' ? %D =# - < 9 h ! +;< 3% g = # , J' ) 0 (
0 9 : I =# + *N h! +;< L g ,

(Querise) -)
? % ! $ N% !e / M R6. F J' ) D i 6 T %
Append, Delete, Update, Crosstab ' & ! 6 % ` =*) )' ) ' S E= 6

(Forms) )
0 % ! ' @ =*+ 3B a *% ' J' ) @ +;< *% ' (3) 3 #
( ! ' D ) (3) $ # D 0( )'S J' ) @ +;< ! $#
0 $ N% d I8 !C G6 ,*+

(Reports) 9 4" 2 )
38B > 3%2 : j ' ' @8 P & 3 N % @ +;< C; a *% @ "
0 !)' ,- ! U ,8> ' %' ! 3%2 U ' j%

(Macroes) ' )
0 $ N% # ! \ F> ' D T : ! ! .% ! =*+ '
0 j% J' ) D $ #D ( ! ' JO

(Modules) % )
 Microsoft Access

!*% ! =*+ % % D 9 J 'Q ' % ! , ! 3B ' J)

0 ! !9 % % J) = ' $ N% '

. * #$

:;8" <= 1
0 ! $ N% @ G Microsoft Access ' ' & "# $ % WG% F
Start / Program file /Microsoft Office / Microsoft Access

, *"* +, - <, )>%"

`( ,A , ) D !A <
h ,- )0 ! ,- . N 0 V *% [ 6 % File New "

#?
 Microsoft Access

$ k% k # a *% N ' D= , hBlank Data Baseg J' " New File N

0 ' j%

!k k=A /k & ! ]h * ,- g d != ,- Blank DataBase " [ 6 %

0 d '

#?
 Microsoft Access

/ GkG6 Mk k3-% / & *% Access ) a D% ! !

`: ! ,*+ @ G 3%2 [ 6 % 0 * ! %- '( Access

File/ New/ NewFile/ GeneralTemplates

OK ' h ,-k g k [ k6 % k % !k - "% j% 3-% !-
Microsoft 3kX # a k (k 3g [ ) F N 3B l 1 ' *% [ 6 %
0( [6 % Next * ' J 8> Access

#?
k k B 2 k ! % *% @ G ' j% D% Finish " [6 %
0 *%

," * * A," B;CD , ?= 1 * 1)@

Open ' [6 % j% D% ] (9 B ' [6 % Open " File
0 D

! 5 6)
k 2 Access (kB A /k & k kN ) DataBase D ' Access M P ' ! >'
0 [ 6 % J' ) d! & *% m2 d (
0 *% N J' ) n' ! ! L
 Microsoft Access

Create Table In Disign View " 8 E F 4* ! 5 6 ) >%"

,-k & k Dk = ,k k kN h Create Table In Disign ViewgJ' " '

& Field Name ,kP = #$%& ! a *%h ,- N % g !A < J' )
0 / F

#?
=# G6 o %@ C ' [ 6 % DataType ,P =#? %
0 V *% ' Discription
k k ! J Access J' ) / 9 $ & j% 2 ! %' K J' )
pkP k !=kC k = k g 0 h ,- g & j% J' ) !=C = 9 , 2
0( 2 * J' ) 0 T J &h *% :

,-
 Microsoft Access

Create Table By Using Wizard *4" , " * ( 6" 1 ! 5 6 )@

k k & D = , Data Base J' ) Create Table By Using Wizard " '
0 9 J' ) 2 3. T ' "'

I -J " 5 6 4* *4" " KL1 4* H 6" 4" " . = 7," 9 D G = " ?, Wizard ?=
. = 1* 5N 6- 1 , '4 L 1 = " * ( 6" 1 *4"* * Access 4* , M
P* 1 "4 O= *4 J 6" 4* D H '* 4" "

Create Table By Entering Data 9 :;8" * 4 1 ! 5 6 )Q

J' k) k % !k Data Base kN Create Table By Entering Data k " k
! h ,- g ,- b L N < " ' D= , & 9

#?
0 V *% K J' ) ' # j% 3%2 !8 $% =# + ' D= ,
* *"* R M *4"* * ! 5 6 N" 1 = N +,* N 4
n' k 2 ! ] ,- % N Data Base " % NEW
0 )' J' ) (

#?
 Microsoft Access

0 qX ( ! 3 ' * J' n'

k n' Dk ' k *% !k Import ! +;< D% J' ) D Import Table n' r

k% ! > * n' ' &( Line Table ? % J' ) ( J' ) (
0 % f '

:;8" ' S T" =" ) )

0 % h ,- g ,-

#?
` ? % ! +;< =# ! - L
/ K Text
( K Memo
+ K Number
'T K Date/Time
s J K Currency
Access M + K Autonumber
!1L P =# K Yes/No
'G K OLE Object
!% 3 2 K Hyperlink
: j ,8> @ +;< K Lookup
 Microsoft Access

Field Properties ' S X 2W, V 9 $ U ) )

,- &( !C ! G6. =# ! ,- ! V (*9> L
0( a *% h ,- g

#?

6" , *4" # 7 S <, N 2W, ) ) )

0/ %
0 &<> % ! ( #
0 ! R6. ' ' WB > ''D
0 ! .% =# + Caption
0t # a 1 Default Value
0 ''I Validation Rule
0 L $ u Validation Text
0 =# *% $ "B Requie
0 !B - Aliw Zero Length
0 GP Index
6" , *4" # * : S <, N 2W, ) ) )
0 + %
0 +( #
0 .+ $ > ' +
 Microsoft Access

0 + ,-
0t # a 1
0 + ' P 'M
0L $u
0 =# *% ' $'"B
0 =#^

Primary Key SY" S ) )

k= # k k D % ! J' ) D g0 !# F J' ) !=C = % ! J' ) D =#D
0h )' !=C =
0 ! *% GP != + !=C =
0 ! J' ) / J G (3) !=C =

SY" S * A,"
k= # k k % !kA < k*% = # &( 9 ^9 3B' ) !=C = = # N
k= " " Edit Primary Key " ' V *% [ 6 % =#^ E F
0 "# ! !=C = = # v (* = ,- D ^9 [6 % " % !=C

Relationship ! " 4* G C 4" ) )

: 9k Dk k JO F & ! S 9A J' ) D a % !_F
k fk k# Dk ( (8Y & # @ G6. ' * & $ % , J' ) D !B
kN k J' k) k ,-. J' ) / &( $ N% @' !% ,C #
k k % kN 0 k !k R6. ( " ' % !C @ +;< # :
0 ! S 9A h L g L J' )
" 4 C: * & 6* 4 0 1 ! " 7 1 E1" 4
 Microsoft Access

Indetermmate 7 L = G C 4" ) >%"

Relation " J' ) ' / / L E F &h!=C = ' ' g j% J' ) '
h ,- g Relationship P C ' [ 6 % Tools

#?
^k &h k 4 g J1 % ' * J' ) ' [ 6 % D * J' ) = # !-
0 2 ) /F % L D [6 % OK "
P 6" Z T;8" E *4" = =" 0 * 14 G C 4" T = 7," ?=

One To One <, 1 <, G C 4" )@

w k1 > ' (k J Gk ,k + J' ) ' !=C = # @' / ! / F %I8 * H> '
0 h!=C = = # g0 ! N / F %I8 8
J' ) J' )

.
.

One To Many 0 1 <, G C 4" )Q

, k *k J' ) ' & !=C = * W9A j% * ' $ % , J' ) D
$ kN% / F k% L N%2 % J A ( $ % = # 2 !=C = @ G6. 'S 2'$%
0( D L D N L & N L
d! 2 w @ +;< $ * ' J' ) ' !1 = $ # )'S D
h ,- g 0 h @ G6. ' S 2 & * & $ %g (
 Microsoft Access

#?

D J' ) J' )

G C 4" SY" S S S 6 1 *4"* : 1 "4 0 I = % H 0 1 <, [1"4 4* ?=

* ( 6" G C 4" N" 1 SY" S " *4"* : 1 "4 <, I = % % H , = = 4" D 1
 Microsoft Access

Many To Many 0 1 0 G C 4" )*

k $ S $ & N.% $ : % : ! ! +;< D% D j%
S N.k% k k k% ! " % ' S % ! N.% g 0(
h( L D N.% ' / L ^ 0
0( !=C = y * x =# & j% y $ % x' y * x =# J' )
k = y N.k% *k x = # j% y N.% $ % x' y N.% * x = # " % J' )
0( !=C
k y S $ k% x ' y * x ' y N.% * x =# h * g: ! ) J' )
J' k) & k !k k # j% !=C = F y * x ' y N.% * x = # ' J' ) /
0 ! J' ) ' / I 8 p+ H> ' ' - > I 8 J' )' / D $

3F. ' 9&

( ' 9&
L' .
3F. ' 9&
( ' 9&

#?
0 8 Query D N %' N J' ) / L

! N' S 14 ) )
*% N 2 =# ! u ! &( !A < J' ) ! B A
` 2! ,K z G
0 *% { A > !=C = ! r
0 COPY ' CUT L D r
0 { A L D & *% # X ) =# ' ' ) L D r
0( )$% =#D r
( )! Q'D ' u !=8> 3 Q ' r
 Microsoft Access

* S ) ) )
' J' k) :k k =# & ! f F S @ +;< ! =#
0 % ! 3 # :

` S T" ="
Filter by Selection@ =" 6" 1 * S )>%"
" Records ^ ' [ 6 % j% =#' a *% j% $ # J' )
k< "k & " % & V *% [ 6 % Filter by selection " 2 ' Filter
0 [6 %

Filter Excluding Selection @ =" 1 S )@

=# - (3) & a *% % [ 6 % ! 3%2 "N & ! * % ! / 7*
2 8% ( D= ^ ' [ 6 % & .% a *% ! g j%
0 V *% [ 6 % Filter Excluding Selection " (B P ' a *%

Filter For " * ( 6" 1 * S )Q

6B 1 8% ! j% F ' D= ( FilterFor
0 . Enter * ' *% ' Filter For "

Filter By Form . " * ( 6" 1 * S )*

k Filter k # ^ k k a k*% kj% $ # J' ) $ # = =#D N
k*% ' kF & k a "k Filter By Form " % 2 ' *% [ 6 % Records
0 [ 6 % Aplly Filter ' D= ( j% F

N " Remove Filter / Sort @ =" 1 =" "4 ' S " ." ' ?=
S 4" 1" 4" = 4* Apply Filter * A < S 1 " 7 \ ' ] =! L ^Records
0 !L ^ "4

Find 4" 1" ) ) )

% ! / 7* ' V *% f D % ! " /
0 V *% !=8> /" )
 Microsoft Access

F ' ! ]h ,- g % N & [ 6 % Edit Find *

0 [ 6 % Find Next = ' 0 ' j%

#?

' Replace With | V ) N / " ) (3)

0 % ! !=8> ) ) Replace [ 6 % ' / " ) ''

SORT 4" 1" ) ) )

0 ! @ FC @ G ) =#S *
0 ! @ !B'"% @ G ) =#S *
Query -)
)' - / Query D 0 >d % ( Access d !- Query
(* Query , B / * & a *% !C G6 ' = # !C F *% '
' = #! * + *N ) ' S D & h4 g Data Sheet *% 0 !C
J *+ )'S ' u ' ! a *% J' ) D '
'S & ! J *+ J' ) ! u W /* & ! J *+ " % J' ) & !
)' L D J' ) ' Query / - ) ' ! Y"% 2 ! 8 )
0 ! + *N & ! a *% Query M + *N
 Microsoft Access

0 ! a *% Query D ! *% * ,-

#?
Query ( )' 3%2 ' = # ' J' ) N / ! c (*9>
0 ! >
0 ! % y " 8 N4 x N ! *%

Query 4* * N +,W, ) )
, ( Query N % + *N ' =#$
! R6. ` Field
0
! J' ) / !% ' ( J' ) $ =#$ ! R6. ` Table
0( :
0 ! R6. = # W ` Sort
0 a *% =#$ ! .% ` Show
) + *N ' $ / / F ! F ! ) ` Criteria
0 '&
 Microsoft Access

- 5 6) )
0( : h ,- g ,- & Data Base M P Query [ 6 %

,-

& )' Query 3 " ' ! - L

" 8 2 ,* 4* Query ) ) )

! m2 Data Base P C & Create Query In Disign View " ' D= ,

0: V *%
' ! ,1 !A < =#': ! D= , I J' ) j% =# '
. ( ) Query D ,C A ! !A < i ' K
0 *%

Create Query by Using Wizard *4" , " * ( 6" 1 Query ) ) )

T "' 3. ': D= , Create Query by Using Wizard " '
0 ! ) Query D Access " '

` 2! ,K w G )' Query ( "% 3 '

 Microsoft Access

/ & New Query N [ 6 % Data Base " % New "

@c A ' ( q X w;8> J' (B A ' )' Query N (B A N
0 9 % ! OK = a " ' " D [6 % J' ) (

Show Table %* C 4* ) )
% *% ,- 0 ' ! - ) )'S ( (3) Query J' ) [ 6 % /
0 ( !B 8

#?
J' ) $ % ! 9 B ' Shiw Table " ' Query !B 8 a *%
0 # X Query c (*9> J' ) [ 6 % Add * ' [ 6 % Query

1 =" N ' -) )
% 3%2 a *% W ' a *% = # ' $ - / F !6% )'S
0 !*% u J' ) ' =# P Query ? % / & ! >

-4 L ) )
F / 0 !+ J- % ! %' ! - ^9 Query ! F
0 ! > Criteria (*9> !A <

`( '2 F ! 3B O J' )
 Microsoft Access

'" 5 Q" 6" , '*4 4 4 L

1a S:` 1 1" 1 , 1 S 4" _ S:_

P 12/10/82 b,4 '* U= , 1 S 4"

b,4 , 1 b,4 * *4" . + ' V = #2/10/82#
X** 2 *4" ;: * 7 1 O= *4
P 1a "` , a S:` 4" * " ?, S 4" _ " _ Or _ S: _
P b,4 * 7," 7 1 ,4 ' Between #1/3/82# and #6/7/82#
P 1 S * 7," " ?, 1" 1 S 4" In (“ S: “ , “ " “)

P 1 a S:` " ^N 0 4" N S ' Not “ S: “

N H* ^ _Cd c 1 N4" '
P*4" = '" L1 Like “C “
& SCD N H* & 5 _ad 1 4 C: '
P = Like “*a”
P* T M Jc " ?, 1 4 C: '
P =& N L1 N Like “[j-M]*”
T aT` c 1 a. =` J N*4 4 ' Left([. = ],1)=” T ”
P 1

[ a `) ) )
j% =# F ! * & =#D a ! F ! N 9)
3 ' ! j% !1L y ' x @ G 1 / Access & ' Criteria M
0 ! \ C 3%2 F ! * ! !

[ a ,`) ) )
F J= 1 / B' & % =#D ' 1 / ! J 8% N 9)
y x'y'xW ! Access g 0 ) OR J = F 1 ' '
0h
V 7 1 , 1 b,4 N ' 4 X“ " V ! D # = &];: 4* , 1 O(% N ' 4 ?=
*4" N* : " A , e,"4 ! - ;: 1 N* : N ' 4 = 2 4" DX # #
P =
 Microsoft Access

0: ! #. )'S o JA& 2! 6% )'S N

N "4 - N ' -) )
'S 2 0 / F ) & R6. !A < -%2
N & Query D F
M @ +;< ! j% F )'S / g0 ! Query & )
h ! '
! [] ' Criteria E & !A < (*9> & ) ' S ? % / (
a *% Access M w + F N ' $ F & % ' , '
0 !

" "4 X "4 - A -V Query Prameters , 1 " 8 N4 4* "4 - * *4" 1 ;: ?=

P g U = "4 "4 - N" *"* T = * 'f #? @ =" Query N

,-
% ! R6. . ' ' 9 ' P ?% )'S !_F

Total Query ' 2 'T A 1 , ' -) )

=#D / % 1 j% & J' ) ' C; B % ! )'S ? % /
! ( / $ & B J' ) , % C; 0
0 ' ! C; !
 Microsoft Access

Total g ? *N " ' 9 Query J *F % & ? *N C; Query D N

'"# !A < ( 2 ,- ! C Total !# X L & D= h
0

,-

(9 B !% # / (9 B ' V "# !A < & 9 $ c Query ! =#

0 Query ' =# $ ' H R6. Total

`( 3. , Total J = D !% # / (9 B
0 ! ' 8 F =# ( !F / ` Group by •
0 ! a *% =# ' 1 ! * ? *N ` Sum •
0 ! a *% =# ' 1 ! * / % ` Avg •
0 ! a *% =# ' 1 / * ` Min •
0 ! a *% =# ' 1 / . ` Max •
0 ! .% 9 =#/ 1 ! , F ` Count •
0 ! a *% =# ' 1 % F { P% ` StDev •
0 ! a *% =# ' 1 2 ^% ' ` Var •
0 ! a *% / B' = # ' 1 ` First •
0 ! a *% / 2 =# ' 1 ` Last •
0 'Field J = = #$% ) ! 8+ ! ) ` Expression •
$ ! R6. F / % 3 =# ! ` Where •
0( 6% ) Query N % =#& ! , )'S
 Microsoft Access

& "# ! Query ! &@8 P , - '2 : # Total qL

* 2 3 Q' % ! B & ( ! 6 % Query !+ % C; Query D
0 3& ! ! 6 % Query !=-

Action Querise U N ' -) )

0 ! u ) & N !. )S ! ) Query
h * ,- g 0 "# ! J' ) )

,-

H! ? " " ' - N" 1 P = U2 1 #1 D U N ' - N" " " #Y e, = ?=

0 C U- h "H! N4 1 U N - N" " " #CD

U N' - " = = 0

Update Query N 6 . + 1 N -) ) )
0 ! u J' ) D ' $ * !_F 1 !_F & $ 3 )' S
D= $ 3 )'S " & a " Query Update -
0h ,- g ! .% # a *% @ G Query N Access
 Microsoft Access

,-
' L F & % $ !.6 3 !
0h ! $ N% ! 6 % Query D -% * ( g R6. @ u j%
0( = # ) 1 ! 8 V *% ! Update To L wc *F

Append Query D F%" N ' -) ) )

\ PB ) J' ) &J' ) ) / Y ' )'S ? %/
0 ! J' ) D =#D *% \ PB (3) Query / H> ' & V *% !
! D= !> PB )'S " ! a " Query Append !*
0h ,- g ! a *% Append !B 8 Access &

,-
 Microsoft Access

$% ' & V *% R6. \ PB 2 !B' ) ! ) /

( Show L > # ! a *% h ,- g Query N Access & OK a " ' J' )
!B' ) ! = # [ 6 % 2 ( /-* ! , Append To t + &
0 ! \ PB 2

,-

& ! ! 6 % Query !=- * Criteria 'Sort Query ? % /

'"# J' ) 3 % 3%2 !8 ' \ PB J' ) $ - *% }6.
0 3 & %

Delete Query i N' -) ) )

"% : (. F '( 2 3%2 { A ' M D ' [6 %
"% F ' % % >: (. j% ! j% & (9 %
0 !# A ) ' S % / ( 3 ' ,-. w F> ' & (
0 a *% ,- % N Access ! [ 6 % Query Delete ! >'
 Microsoft Access

,-

!A < & ! Delete L t + ' ( Show Sort L > # Query /

! G L% * 0hc (*9> 4 g& N J' ) D =#! *
'( '2 L ( J' ) $ % Form *= Delete L
! =# M1# ( W=L / '2 < 6 / ( "N = # $% Where *=
0 ' F %
0 { A ! =#' ) Query % ! F ' F

FORMS )
' J % ! = # b > ,P & ! ! 3 #( - Access
( $ # "' / 7* Access 0 "# o < j% !- # ' ! 83
! $ N% 3 # !A < ^ ' h T ' a g !B 8 ! )
0
B " ' M1# % ! 9 & 9 * !# % "' /
0 j% 3 #
a *% ' ' Access J' ) , : 1 9 L % ! % ! L% *
D =#! * D % !*% wc *F ( W % @ >' ! / /- B'
0 % ! ' 1 - / 3 #0 8
Query J' ) D S ! 3 #' ! 3 # ' ' (3)
0(

. 5 6) )

: Create Form In Design View " 8 E F 4* . 5 6) ) )

0 [6 % $ #d! > DataBase M P !B A
$ #D & ! ] ,- D = Create Form In Design View " '
2 ' *% !A < $# % ! > $ # !A < (B A '( $
0 Z PB j% 3 #' 3 % % ! & > 6B ) j% =#
0 : qX $# ) " ! %
h ! qX = # '"# ! % g
 Microsoft Access

,-

,8> & 8 J GP % ! !A < P C i' &( j% $ # JA

0 2 ( ! , > ! F $%' K $ # i'

Create Form By Using Wizard *4" , < ?1 . 5 6) ) )

D= , j% hCreate Form By Using Wizardg " " ' D*- $ # (
0 ! ] ,- b L N &
 Microsoft Access

,-
(*9 f G6 * j% =#' [6 % j% J' ) N /
0 [6 % Next " ^ & J 1 % J' ) (
Access 0 [ 6 % Finished " ( 3% ' T N " ' @c
% ! g0 ! a *% ! * j% @ G6. $ # D
0h ! $# @ 8F & J *+ j% @ u ' ' !A <

. 5 6N 4 , 6) ) )
h ,- b L g New Table $ % N D D= " % New "
! ]
[6 % &( q X w;8> J' n' ' )' $ # / (3) n' /
" ' J' ) / (*9> j% )'S ' J' ) [ 6 % ' 3 ' D
0h( ! 0000 ' !% & L 3 #g 3 j% $ # % ! OK

,-

4* 4" 1" " * ( 6") )

M1# * g & *% 3%2 3 # !A < ! )' Access F "
h !A < " % ! !A <
 Microsoft Access

N 1 j% D 4" 1" 4" = ) ) )

% WB > " % ! a *% " % Access ! ! # !
0 ! Q' =) ' ~% *% R6. " % / h Formattigg !

'! ) ) )
yJ x! '! & = # j% ! )$ # ' $;> =
0 % ! %

% N4 ? 6* @ ="
? %' & [6 % J ! >' & [ 6 % 3%2 % ! 3B ' D=
0 % ! ,- 9 ( A ' % u

,-

! ci
&
V *% { A 3%2 Del * % ! 2[6% F J D { A
% ! { A J w 8 ! C ' !*% ! u J { A ,8> Access
0 Undo
 Microsoft Access

…' D '4" D 3%2 * % & { A: J / % !

0 Format @ u (3) % ! / 7*

' S * "
) 2 =# n #$ #E F $ & ! m2 !B $ # D
& V "# $ # o < ! =# %& *% { A =# 8 &
,- g = # ! * (9 B [ 6 % View Field List " = # D '"#
0 a *% & h

h ,- g

0 ! > Query = # (9 B % w 1 >

0 .- $ # ' D= = # (9 B %2 & $ # = # D '"#
` " 8F)
8F) ) " & "# J ? % 9 % ! " 8F)
( a *% ,- "

$ %

&

'( '

) *

! " #
! " #

+% &
/ & -., * -
 Microsoft Access

,-

% *4" , )
"# ! $ # ) J E F ! "' & J "' "
0 ! 2 J F# m (B A 9 % % 3 0 % ! J F# m J F# & % ! >
0 "' . * O
"4 N , ! = 4* k D 7," N S L%"4 6* : ?=
P ' ! L '*4" , ," "

Label j 0 1 )

N W9 .- ' D= W9 " % ! &$ #D )/ '"#

' " & ~% & ( # % ! ' v j% / % ! S' * F 0
0 u 6B @ G W9 …

TextBax 4* )

.- ' D= $ #^ ' D= ! " $# ! D '"# (3)

7%2 % ! Access ! S' * ! >' 0 ) !
*% ! Unbound *= & ! a *% ! *% '
0( . % ,G =#| / .% !
1 % ! JO F & 8 P 1 a *% (3) % ! !
0( =# ' + [ X H*) ,C A a *%

Check Box , Option Buttoms 64 1 N '4* N" , 2H LM * N ' *)

Toggle Buttoms

0 ! h • = g ! FX'' =# 3B / wc C
! FX' ' * " & " 8F) ^ & a *% = # (9 B 3B ? %/ N
2 !8 =C ,- S' 0 D= ! h " g! * " &
D= / 0 ! a *% h ( J '"# % .% g )' , *
0 $# ' = # (9 B & • = = # D . '
 Microsoft Access

ComboBox & ListBox % N '4* C N '4* )

Access 0 ! a " 39B $;> W=m & ' ' % ' Access
0h! 9 B ' 8 g & V "# $# 39B/ ? %' ! )

% N '4* C N '4* 7 1 9 ( )

1 % !
&( ! D ' !% # / (9 B D !8 8 D
a *% / %2 & *% [ 6 % !% # / (9 B 1 *% ' ! D
/ Access & ! J *F L ' ' !% # / 39B ( ! ' * / 0
1 % ! t #a L _> / ' %! 8 J
4 % ! (CG / g % )' (9 B '! '
(CG / u & Limit To List ( C G & Yes [ 6 % ' 8 @ CG
0 h( No t # a L
& [ 6 % 3%2 !- ! ) ' ! a *% " !9B D
" F 0 ( a *% J A * !9B ' " & !% # / (9 B {;

(* 8B a * % Access & E F %
. (9 B '
0 8 " ! * ) "# ! 2 (
& !*% ) 1 v ) !9B D & 8 D {; ` -%
0 % a " % ! (9 B ' 1 3

Command Button *)

0 ! $ N% !. h ! % " % .# * g # * D
2& ! $ N% % a 9 ( ! * ( # * "'
Form N / 3B %* "# $ # ! * ! JO F 0 !
0 '2 ! : # 2 ' F & !=8> & J' /# -
% !*% Access M ! J *+ # * % ! / 7*
' ) * / $ N% / 0 3 $ N% =A D
0(
 Microsoft Access

.- ' D= $# ' ' D= # * " $#D # * '"#

# * " ' Access S' * ! >' & E F # * % ' ,P
0 ! a *% h ,- g

,-
! # * ? %[6 % - " ' / !B 8 / B' 8 % ! L% *
0 ! a *% a ! ' (9 B + *N & '2 ! : # $ N% %
/ ! ) * h ,- g $' !B 8 Next * '$ ca [6 %
' ! & , * N & [ 6 % Text ! * % ! & t+ 'G
0 a *% # *

,-
 Microsoft Access

Finished " [6% ! : # # * ( ' % - 2 !B 8

0 ! # *

Image l?: )
' ! D= $# ' - F 0 i $# ' 'G ! ) ^-+ [ > "
! a *% Insert Pictures !B 8 Access & E F G / [> . !
! & G / 'A, #[6 % 2 % ! Open % (
0 "# $ # , * 3= # ! .1% 3= # & !- # 3= # %

Unbound Object and Bound Object J U= J N'@D)

Frames
! > ,P ' % E F 3%2
. '$ # ' D= ' " ' / D [6 %
0 "# $ # OLE d! % ! & OLE d ! ' A
0 [ 6 % J' ) = # !- OLE w;8> ` -%
! >' ' ! a *% OLE d ! = # @ P 1 OLE d ! [ > D
0 ! u ! ( A '
! ( A ' ! >' ! .% OLE € ! D .% 1 OLE d ! [ > D
0' ! - '' 3 # N $ 2 '"# . [ > / & % ! !> ( Y

REPORTS 9 4" 2)

0U !A < 3 )' * (9 8+ Access n "

a *% wc *F & 9 : U , > JP ! d!
0 % ! U Q' L 3 " & % ! >
" Open " N & ! [ 6 % Database Report ! ,B /*
h ,- g % 0 ! Preview
 Microsoft Access

,-

0 a *% !A < *% Print Preview N % ! 3 "

n % ! Enter = .# ' n " [ 6 % Report " ' D = , ! 9
0 a *% Print Preview N
u 3 #' ) ' S & 3B' ) ' %* !*% 3 " # a *%
0 3%2 ! ,- . ! a *% P% 3%2 Print Preview N 0
0 ( Form N 8 9 !A < *% Report N
! 9 ' ! !A < 3 " ( n " " ' D ' A Access
0 "' $ 3 # !A < N %

9 4" 2 " * ( 6" 7 5 6) )

0( ,- [6 % Report " Database N

,-
 Microsoft Access

` )' 3 " N (3) ' ! ,- - L

0 *% 3 3 " ! n " " ' b < ' !A < b <

Create Report In Design View " 8 2 ,* 4* 9 4" 2 ) ) )

,- b L N D = , Create Report In Design View " '
n " ' N % ! (9 B ' " 8F) & ! a *%
0 8 h N n " g N % % ! Print Preview

,-

Create Report By Using Wizard m4" 2 *4" , < 1 m4" 2 ) ) )

P S 3%2 9 ! 3 " % ! ( * > 1%2 n " "'
, ' + =# !F*) ' ' % ! : 91 ! ' f =#
0 + = # ! 3% H*) J' )
4 (6 " = = 94 Y4* * ( 6" *4" , " m4" 2 56 * Y ?=
P
,- % N D= , Create Report By Using Wizard " ' ! >'
0 ! ]
 Microsoft Access

,-

& '2 ! : # n " ! )'S J' ) = #[6 % - " ' =A /

0 ! Access "' %* n'
0 '2 ! : # ' 3 " ( - h ,- g F =A

,-
! )'S J' ) , + = # * != H*) n " & ' =#
0 : #( 2 ! 8
' ' 2 H*) & n " @ G [6 % ' =#D 3 % !
0 ' / % ! / 7* 0 *% : # J' ) , H*)
"'/ & ! 8 P ' ! * ! + *N & + *N != H*) n "
0 ! , ' + =#! * ! + *N ' + *N L
 Microsoft Access

*! N"4"* N" [1"4 N" *"* +, - 1 = 4* N 1 2N 4" 2 ?=

P 6" ( 4 H 1 ! "! *4 4 ' J" " 1 , '*4 4 " -

* F 6" 1 N 1 2)
=A / Grouping Options * % ! [6% ' qL - F
' P S ! ) & a *% Grouping Options !B 8 D=
! ' 8 T =#D w;O 0 ' D ' 1
0 ' =# 2 ' & E= 6 J ' 6 ( /-* &
!B 8 & ( @' & E= 6 ? % E F % ! ! ' P ? %
( (* ' ( 3%2 S * ' ( ! = # , Grouping Interals
' ?% W ' % ! )' !% # / ! 9 B 3%2 $
' P + *N , & (+ •T =# !% # / (9 B & [6 % 2
h 1 > ' (+ & ' & & & ,G# & J g ( ! + ' !6
' ! F [6% - &! !% # / (9 B
0 '2 ! : # & $ N% 2 S
' !BA @ C/ [ 6 % Normal / , S '
0 : /+b> < =#/ ' 1 % !
N 6j j I, 2
! % ! ] ' ! W W h ,- g F =A
0 "

,-

H 7 L "4 2 ' 4* S $( N '*4 4 N 6 j j S 7," ?=

P"4 ' 2* 5 =
 Microsoft Access

N 1n 8
0 '2 ! : # =# > P% a " - & n " " ' F =A
= #$%' # > - = #g % o< - ! ,- L% *
$%' % ! ): =# 2 g!B' ) o <&h ! ) 2 v (*
! :j =#J< 2 g < o<'h ! ) PC c =#
0: h !% 9- % IL

,-
& *% ! : # n " D8 a " - & ( 2 ,- n " " ' F =A
v (* ! [6 % ! BA& ! a * (9 B ' " ' 7*
0 ! . G
 Microsoft Access

,-
2 =A 8 ' *% ! : # n " ( ' + N - & h ,- g " ' 2 =A
F 'n " c ! '! !% + & ( "' ' $ # "'
0 ! a *% P C

,-
n " ! D= Finish ! [6 % Modify the ReportS Design
0(# a *% !A < *% n " & 9
9 4" 2 5 6 +,* N 4) ) )
,8> ! ' ' ';+ g 3 ' & [ 6 % Database " % New "
h ,- g 0 ! N &h K
 Microsoft Access

,-
Auto-Report Columner
0 ! > !% =# ! 3 " ( (3)

Auto-Report tabular
n " ( !% J' ) / 0 % > - =# ! p+ " / [6 %
0 3 ( =# , 3 Query 8

Chart Wizard
{ ( % ! 2 & ! a *% *% "' " / [6 %
0

N % ! 2 . ! G W9 "' " / [ 6 % Lable Wizard

0 389 ! 9 389
$ R6. 3 )'S S n " % ! ` -%
h0 #X =# 3 " % !*% & 3 # ' 3B' ) {; g0 % a *% 2 '

% ' )
! [ 9P ^9 ` % * > 3 Q ' data base N F d! '
% B $ / 7* 0 '2 ! : # / H ' - '
' -=*+ ! * ^9 0 ( -=*+ !9B' D 0 % ! >
# C Access ' 0 ! $ N% ! ) ' !% (9 B
0 ! !V )
% B '2 ! : # D 9 J 'Q ' ! % / % - J)
y !*% 3B ) '") / x ,C A # .

5 6) )
MACRO d! ! d! 8
9 data base N '
0h ,- g ! .% ' (9 B [6 %
 Microsoft Access

,-
`( d 8 data base " % ' d!
! ) ' D `New
^ ' ! [ 6 % (9 B ) ' $ %g ! ) ) ' D `Run
h [ 6 % RUN *
[ 6 % (9 B ' $%g u ) ' D o< ! ) ` Design
h V *% [ 6 % Design * ^ '

*4" 14* 6" J " +,*4* * ( 6" *4 N' *"9 ( RUN o * E ?=

P = , , 'J +,* = '

N ' (%p ) ) )
% *% ,- ! a *% Macro N ^9 & data base " % New [ 6 %
0( 2
 Microsoft Access

,-

% ' O (3) ( " $* /

!8 a / ' 0 $ N% ' ! ! a ! * ` Action •

0 ! $ N% ! (9 B 3%2

2& ( $ N% J A ' ?X / ‚ a ! C ` Comment •

!* > ' 3 %' ‚ % )' & 9 @P X / & !
0 ,-. ( /-*

a O % ! a *% N ! * % Action Argument WB > ` Argument •

! J & ! $ N% 3. ! ' 9 ! 36% 20 % % 2
0

N 'I ) ) )

` 8+ 3%2 =*) & "# Action (9 B % ! % )' ! = 6 3. ? %

0 ! J *+ $ # ! )'S = # D ` Apply Filter •

0 ) %" \ ! ' ` Beep •
 Microsoft Access

0 ! d ! ` Close •
0 (1 L ! R6. F ! ` FindRecord •
0 ! 3B 8 ` GotoRecord •
0 % ! O A ) N ` Maximize •
0 ! U [6 % ]' ` PrintOut •
0 ! ^9 ` Quit •
0 ! ) ! R6. !' ` RunMacro •
000' •

( ! 3. , ' $ N% % ! ' D ( ! a % *% (9 B 3 /
% ! ' ! ! != ' 0 2 ! [ 9A 8 a /
0 ! V $ N%

I <, N ' 4 ) ) )
! J a ) n' ! 3 6 % ' . J *+ 2 a d ! a D 3% 2
a JO F % % 2 ' ' a O & *% ! R6. &
0 J' ) $ ! R6. , !% 2 Open table
v " % Action J = %2 % ! 0 % ! ! !. $ % ` -%
0 ! a *% ! ?' v !#' A (9 B " / B' ^9 0
Minimize & MI v ' ! a *% Manimize & M v JO F
0 ! .%

I <, N = 24 * g U
R6. 3%2 2 W=m & "# ! a & !% # / (9 B ! >'
a " - 9 !% # / (9 B Action Arguments 3B = O
0 v 2 1 0 % '2 ! : # [ 6 %

AutoExec 4 * 5 N ' ) )
& ! ) L $ !' N ! ) Access
! ' 2& K AutoExec $ % %2 ' N !'
0 ! ) L & ! > 2
AutoExec ' % ! Shift = / %/ ` -%
0 J F# m