Contents
Overview 1
Creating a Form 2
Saving Form Results 10
Modifying Data in a Database 24
Review 36

Module 2: Updating
Data in a Database

!" " #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3("
!
!
"#$%&'()*%#!*#!)+*,!-%./'0#)!*,!,/120.)!)%!.+(#30!4*)+%/)!#%)*.05!6+0!#('0,!%$!.%'7(#*0,8!
7&%-/.),8!70%7908!.+(&(.)0&,8!(#-:%&!-()(!'0#)*%#0-!+0&0*#!(&0!$*.)*)*%/,!(#-!(&0!*#!#%!4(;!*#)0#-0-!

V&(7+*.!E&)*,)P!J.%))!J0&#(!Q=&0()*<0!E,,0),R!
B-*)*#3!@(#(30&P!O;#0))0!JA*##0&!
B-*)%&P!X0*-!F(##0.A0&!QJY6!G#,*)0R!
=%7;!B-*)%&P!X0*-!F(##0.A0&!QJY6!G#,*)0R!!
I&%-/.)*%#!@(#(30&P!@*&(.90!L(<*,!!
I&%-/.)*%#!=%%&-*#()%&P!U0##;!F%0!!
I&%-/.)*%#!6%%9,!J70.*(9*,)P!U/9*0!=+(990#30&!!
I&%-/.)*%#!J/77%&)P!J/,*0!F(;0&,!QG#9*#0!6&(*#*#3!J%9/)*%#,8!"#.5R!
60,)!@(#(30&P!J*-!F0#(<0#)0!
=%/&,04(&0!60,)*#3P!B&*.!@;0&,!
=&0()*<0!L*&0.)%&8!@0-*(:J*'!J0&<*.0,P!L(<*-!@(+9'(##!
M01!L0<09%7'0#)!O0(-P!O*,(!I0(,0!
=L!F/*9-!J70.*(9*,)P!U0##;!F%0!
G#9*#0!J/77%&)P!L011*!=%#30&!
@(#/$(.)/&*#3!@(#(30&P!X*.A!60&0A!
G70&()*%#,!=%%&-*#()%&P!U%+#!M*99*(',!
@(#/$(.)/&*#3!J/77%&)P!O(/&(!Z*#3T!Z()+;![0&,+0;!
O0(-!I&%-/.)!@(#(30&8!X090(,0!@(#(30'0#)P!F%!V(9$%&-!
O0(-!I&%-/.)!@(#(30&8!"#)0&#0)!J0&<*.0,P![*9(&;!S(#-(9!
V&%/7!@(#(30&8!=%/&,04(&0!"#$&(,)&/.)/&0P!L(<*-!F&('190!
V0#0&(9!@(#(30&P!X%10&)!J)04(&)!
!
" #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3(" " ..."
!
!
4/3-5&6-$5"7$-(3"
!
6+*,!'%-/90!)0(.+0,!,)/-0#),!+%4!)%!.&0()0!(!$%&'!1;!/,*#3!H%&'!I(30!M*\(&-!
(#-!,(<0!$%&'!&0,/9),!)%!(!)0?)!$*908!(#!0?*,)*#3!-()(1(,08!(#-!(!#04!@*.&%,%$)!
E..0,,!-()(1(,05!6+*,!'%-/90!(9,%!.%<0&,!*#$%&'()*%#!%#!+%4!)%!/7-()0!(!

85(3(/-,-.$/)""
=>>"#./&-(3"
?,2)"
@>"#./&-(3"
.A" " #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3("
!
!
#$%&'("B-5,-(0C"
N,0!)+0!$%99%4*#3!,)&()03;!)%!7&0,0#)!)+*,!'%-/90P!
!"
=&0()*#3!(!H%&'!
6+*,!,0.)*%#!-*,./,,0,!+%4!)%!.&0()0!(!$%&'!1;!/,*#3!H%&'!I(30!M*\(&-5!
B?79(*#!+%4!)%!&/#!H%&'!I(30!M*\(&-!(#-!,090.)!)+0!);70!%$!*#7/)!(#-!
7&0,0#)()*%#!(#-!%/)7/)!%7)*%#,5!!
!"
J(<*#3!H%&'!X0,/9),!
6+*,!,0.)*%#!-*,./,,0,!+%4!)%!,(<0!$%&'!&0,/9),5!B?79(*#!+%4!)%!,(<0!$%&'!
&0,/9),!)%!(!)0?)!$*908!(#!0?*,)*#3!-()(1(,08!(#-!(!#04!@*.&%,%$)!E..0,,!
-()(1(,05!
!"
@%-*$;*#3!L()(!*#!(!L()(1(,0!
6+*,!,0.)*%#!-*,./,,0,!+%4!)%!'%-*$;!)+0!-()(!*#!(!-()(1(,05!H*&,)8!0?79(*#!
+%4!)%!.&0()0!(!$%&'!)+()!(99%4,!;%/!)%!0-*)!<(9/0,!$%&!,70.*$*.!$*09-,!*#!(!
-()(1(,05!>0?)8!0?79(*#!+%4!)%!/7-()0!-()(!*#!(!-()(1(,05!
!
!
" #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3(" " ="
!
!
#

E$)0&!.%'790)*#3!)+*,!'%-/908!;%/!4*99!10!(190!)%P!
!"
=&0()0!(!$%&'5!
!"
J(<0!$%&'!&0,/9),5!
!"
N7-()0!)+0!-()(!*#!(!-()(1(,05!
!
!
6+0!,('790!(779*.()*%#!$*90,!$%&!)+*,!'%-/90!(&0!9%.()0-!*#!)+0!$%9-0&!
e"#0)I/1eMMMX%%)e^_WCeJ('7(77,e@%-DC5!F0$%&0!<*04*#3!)+0!,('790!
(779*.()*%#!$*90,8!;%/!'/,)!.%#<0&)!)+0!
e"#0)I/1eMMMX%%)e^_WCeJ('7(77,e@%-DC!$%9-0&!*#!;%/&!.%'7/)0&!*#)%!(!
M01!$%9-0&5!
6%!.%#<0&)!e"#0)I/1eMMMX%%)e^_WCeJ('7(77,e@%-DC!$%9-0&!*#)%!(!M01!
$%9-0&P!
^5! G70#!H&%#)I(30!CDDD5!
C5! =&0()0!(!%#0K7(30!M01!/#-0&!+))7P::9%.(9+%,):^_WC:J('7(77,:@%-DC5!
!
!
B'.%("D2J(6-.A("
!"#$%"&'()#*+#"&)%&'),#"-#
."(/0)#1"$'23#*+(#
"45)21'&)36#
?(,%K./"
7+#18'3#."(/0)9#:"/#,'00#0)*%+#
1"#2%)*1)#*#-"%.#4:#/3'+;#18)#
<"%.#=*;)#>'?*%(6#@"/#,'00#
*03"#0)*%+#&*%'"/3#.)18"(3#
1"#3*&)#-"%.#%)3/013#*+(#

<%"+1=*;)#ABBB#$%"&'()3#
18)#<"%.#=*;)#>'?*%(#1"#
2%)*1)#*#-"%.6#
?(,%K./"
!8)#)*3')31#,*:#1"#2%)*1)#*#
-"%.#'3#4:#/3'+;#18)#<"%.#
=*;)#>'?*%(6#
" #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3(" " N"
!
!
F5(,-./0","G$5H"*3./0"G$5H"8,0("L.M,5%"
!
B('(6-./0"-O(";C+("$I"4/+&-
!
B('(6-./0"-O("85(3(/-,-.$/"D+-.$/3
!
B('(6-./0"-O("D&-+&-"D+-.$/3
C!"#$%&'()*#+,-*./0).%,*-.%12.3233(D
!
!
H&%#)I(30!CDDD!7&%<*-0,!)+0!H%&'!I(30!M*\(&-!$%&!.&0()*#3!(!$%&'5!M+0#!;%/!
.&0()0!(!$%&'!/,*#3!)+0!H%&'!I(30!M*\(&-8!;%/!#00-!)%!,70.*$;P!
!"
6+0!*#$%&'()*%#!;%/!4(#)!)%!.%990.)8!4+*.+!-0)0&'*#0,!)+0!$*09-,!)%!79(.0!%#!
;%/&!$%&'5
!
!"
6+0!9(;%/)!%$!$*09-,8!4+*.+!+097,!;%/!*#!%&3(#*\*#3!)+0!$%&'!*#)%!
7(&(3&(7+,8!9*,),8!%&!)(190,5!
!"

-%".#18)#-"00",'+;#*((%)33#
O--+)QQ'$6,'O$3-Q=@N!QB,H+
,++3Q#$%>!QF&3-5(0I$5HR
O-H6#
" #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3(" " S"
!
!
1(H$/3-5,-.$/)"F5(,-./0","G$5H"*3./0"G$5H"8,0("L.M,5%"
!
!
"#!)+*,!-0'%#,)&()*%#8!;%/!4*99!,00!+%4!)%!.&0()0!(!$%&'!/,*#3!)+0!H%&'!I(30!
M*\(&-5!
!"
"#$%#!#&'!()%*!+$,'!-./$%0!
^5! G70#!@*.&%,%$)!H&%#)I(30!CDDD5!
C5! =&0()0!(!%#0K7(30!M01!/#-0&!+))7P::9%.(9+%,):^_WC:L0'%=%-0:@%-DC4015!
W5! G#!)+0!(.1'!'0#/8!7%*#)!)%!2'38!(#-!)+0#!.9*.A!+$,'5!
f5! G#!)+0!4'5'%$1!)(18!.9*.A!()%*!+$,'!-./$%08!(#-!)+0#!.9*.A!675!6+0!
H%&'!I(30!M*\(&-!%70#,5!
g5! =9*.A!2'8#!)%!.%#)*#/0
5
!
!
B('(6-./0"-O("-C+("$I"./+&-"
6+0!"#7/)!6;70!7(30!%$!)+0!H%&'!I(30!M*\(&-!7&%'7),!;%/!)%!,70.*$;!)+0!);70!
%$!*#$%&'()*%#!;%/!4(#)!)%!.%990.)!$&%'!(!/,0&5!H%&!0?('7908!)%!.%990.)!)+0!
#('08!(--&0,,8!(#-!7+%#0!#/'10&!%$!(!/,0&8!,090.)!)+0!.%#)(.)!*#$%&'()*%#!
%7)*%#!*#!)+0!4*\(&-5!
B'.%("D2J(6-.A("
!"#()."+31%*1)#8",#1"#

*#$%&'()*%#Pb!
" #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3(" " U"
!
!
C5! J090.)!9)5#$9#!.5<)%*$#.)58!(#-!)+0#!.9*.A!2'8#5!
!
!
F(,0-!%#!)+0!);70!%$!*#7/)!,090.)0-8!)+0!4*\(&-!-*,79(;,!(#!(--*)*%#(9!7(30!
)%!,090.)!)+0!,70.*$*.!*#7/)!$*09-!$%&!)+0!$%&'5!6+0!7(30!+(,!-*$$0&0#)!%7)*%#,!
$%&!-*$$0&0#)!*#7/)!);70,5!
W5! B#,/&0!)+()!)+0!2$*'8!?.#1'8!6%,$5./$#.)58!-)%@!;&)5'8!(>A8!BC*$.1!
$00%'DD8!(#-!-'E!$00%'DD!FGHIJ!.+0.A!1%?0,!(&0!,090.)0-5!
f5! =9*.A!2'8#!)%!&0)/&#!)%!)+0!7(30!)+()!9*,),!)+0!]/0,)*%#,!;%/!.&0()0-5!
c%/!.(#!.9*.A!(#;!%$!)+0!]/0,)*%#,!(#-!/,0!@%<0!N7!%&!@%<0!L%4#!
1/))%#,!)%!'%<0!(!,090.)0-!]/0,)*%#!/7!%&!-%4#!%#!)+0!7(305!
g5! =9*.A!2'8#5!
!
B('(6-./0"85(3(/-,-.$/"D+-.$/3"
E$)0&!,70.*$;*#3!)+0!*#7/)!);708!;%/!#00-!)%!,70.*$;!+%4!$*09-,!4*99!(770(&!*#!
)+0!$%&'5!H%&!)+*,8!,70.*$;!)+0!7&0,0#)()*%#!%7)*%#,!*#!)+0!I&0,0#)()*%#!G7)*%#,!
7(30!%$!)+0!H%&'!I(30!M*\(&-5!6+0!7&0,0#)()*%#!%7)*%#,!0#(190!;%/!)%!-0$*#0!
)+0!9%%A!%$!(!$%&'!7(305!
6+0!3&%/7!%$!$%/&!&(-*%!1/))%#,!()!)+0!)%7!%$!I&0,0#)()*%#!G7)*%#,!0#(190,!;%/!
)%!%&3(#*\0!)+0!$%&'!(,!#%&'(9!7(&(3&(7+,8!#/'10&0-!9*,),8!1/990)0-!9*,),8!%&!
-0$*#*)*%#!9*,),5!
6+0!:'D!(#-!5)!&(-*%!1/))%#,!/#-0&!)+0!-)=10!:)=!1.@'!$!?$E1'!)<!K)5#'5#D!
<)%!#&.D!;$,'L!%7)*%#!0#(190,!;%/!)%!79(.0!(!)(190!%$!.%#)0#),!%#!)+0!$%&'!7(305!
J090.)!)+0!GD'!?$E1'D!#)!>1.,5!()%*!(.'10D!.+0.A!1%?!)%!90)!H&%#)I(30!/,0!
)(190,!)%!%&3(#*\0!$%&'!$*09-,5!
H%&!0?('7908!$%&!)+0!.%#)(.)!*#$%&'()*%#!$%&'8!;%/!'(;!-0.*-0!)%!&0)(*#!-0$(/9)!

F;!-0$(/9)8!)+0!"$M'!%'D=1#D!#)!$!3'E!;$,'!%7)*%#!*,!,090.)0-5!H%&!)+0!.%#)(.)!
*#$%&'()*%#!$%&'8!;%/!.(#!&0)(*#!)+0!-0$(/9)!%7)*%#5!
!"
"'1'9#!)=#;=#!);#.)5D!
^5! X0)(*#!)+0!-0$(/9)!%7)*%#8!(#-!)+0#!.9*.A!2'8#5!"#!)+0!#0?)!0?0&.*,0!;%/!4*99!
,70.*$;!)+0!%7)*%#!$%&!,(<*#3!)+0!$%&'!&0,/9),!*#!(!-()(1(,05!
C5! =9*.A!(.5.D&!)%!.&0()0!(!$%&'5!
!
H&%#)I(30!CDDD!*#,0&),!(!&0.)(#3/9(&!(&0(!*#!;%/&!M01!7(30!%/)9*#0-!4*)+!(!
-(,+0-!9*#05!6+*,!(&0(!*#-*.()0,!)+0!$%&'!(&0(!(#-!.%#)(*#,!$%&'!$*09-,8!,/.+!(,!
)0?)!1%?0,8!&(-*%!1/))%#,8!.+0.A!1%?0,8!-&%7K-%4#!'0#/,8!(#-!7/,+!1/))%#,5!
6+0!"=E*.#!()%*!(#-!H'D'#!()%*!1/))%#,!(&0!(9,%!*#.9/-0-!*#!)+0!$%&'5!E$)0&!
$*99*#3!%/)!(!$%&'8!/,0&,!.(#!.9*.A!)+0!"=E*.#!()%*!1/))%#!)%!,/1'*)!)+0!$%&'5!
N,0&,!.(#!.9*.A!)+0!H'D'#!()%*!1/))%#!)%!&0,0)!)+0!$%&'!)%!*),!-0$(/9)!,)()08!
-090)*#3!(#;!)0?)!)+()!)+0;!0#)0&0-5!
" #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3(" " @"
!
!
!"
"$M'!$50!#'D#!.5!$!E%)3D'%!
^5! X0#('0!)+0!+0(-*#3!K=D#)*'%!H',.D#%$#.)5!()%*8!(#-!-090)0!(99!
/##0.0,,(&;!*#$%&'()*%#!$&%'!)+0!$%&'5!
c%/&!$%&'!,+%/9-!&0,0'190!)+0!$%99%4*#3!*99/,)&()*%#P!
!
!
C5! J(<0!)+0!7(30!(,!K=D#)*'%OK)5#$9#P&#*5!
W5! I&0<*04!)+0!7(30!*#!;%/&!1&%4,0&5!
!
H%&!'%&0!*#$%&'()*%#!%#!.&0()*#3!$%&',8!&0$0&!)%!.%/&,0!^_^CEP!!"#$%&'(#)%"*#%*
+,-*.,/,0%12,"#*3,(4"%0%5),65!

*#/3)%#)+1)%3#'+#*#-"%.6#
" #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3(" " =="
!
!
B,A./0"G$5H"9(3&'-3"-$",";(W-"G.'("
C!"#$%4'#()5--6/0).%,*-.%12.3233(D
!
!
=%#,*-0&!(#!0?('790!%$!(!M01!,*)0!)+()!7&%'7),!;%/!)%!,*3#!(!3/0,)!1%%A5!
!
B'.%("D2J(6-.A("
!"#38",#8",#1"#3*&)#-"%.#
%)3/013#1"#*#1)H1#-'0)6#
?(,%K./"
@"/#2*+#3*&)#-"%.#%)3/013#1"#
*#1)H1#-'0)#"%#*+#K!LM#-'0)6#
1('.A(5C";.+"
<%".#7+1)%+)1#GH$0"%)%9#
"$)+#Z&(3-2$$<RO-H"-%".#
18)#-"00",'+;#*((%)33#
O--+)QQ'$6,'O$3-Q=@N!QB,H+
,++3Q#$%>!QZ&(3-2$$<RO-
H6#
=!" " #$%&'("!)"*+%,-./0"1,-,"./","1,-,2,3("
!
!
c%/!.(#!$*99!%/)!)+0!$%&'!(#-!,/1'*)!;%/&!<*04,!(1%/)!)+0!,*)05!6+0!-()(!)+()!
;%/!,/779;!*,!,)%&0-!*#!(!)0?)!$*905!6+0!,*)0!7&%<*-0,!(!9*#A!)%!)+0!$*90!,%!)+()!(#;!
/,0&!.(#!,00!4+()!%)+0&,!+(<0!4&*))0#!(1%/)!)+0!,*)05!
6%!7&%<*-0!)+*,!$/#.)*%#(9*);!)%!;%/&!M01!,*)08!;%/!.(#!.+%%,0!)%!,(<0!)+0!