ÍNDICE INTRODUÇÃO AO MS-ACCESS:................................................................................................1 R ECAPITULAÇÃO :............................ .................... ..................... ..................... ..................... ..................... .................... ..................... ..................... ..................... ................ ..... ECAPITULAÇÃO :..................
1
Tabelas:................. Tabelas:.. ............................. ............................ ............................ ............................ ............................ ............................. ............................. ............................ ..................... ....... 1 Consultas:......................................................................................................................................1 Formulários:........ Formulários:.................. ..................... ..................... ..................... ..................... .................... ..................... ..................... ..................... ..................... .................... ..................1 ........1 Relatórios:........... Relatórios:...................... ..................... .................... ..................... ..................... ..................... ..................... .................... ..................... ..................... ..................... .................. .......1 1
SEGURANÇA:..................................................................................................................................2 A NTES DE COMEÇAR :................... :.............................. ..................... .................... ..................... ..................... ..................... ..................... .................... ..................... ................... ........ PROTEÇÃO DOS DADOS.................... ............................... ..................... ..................... ..................... .................... ..................... ..................... ..................... ..................... ................ ......
2 2
CONSULTAS:..................................... CONSULTAS:....................... ............................ ............................. ............................. ............................ ............................ ............................ ...................... ........ 4 USANDO SQL NO MS-ACCESS..................... ............................... .................... ..................... ..................... ..................... ..................... .................... ..................... ............... .... 4 CONSULTAS U NIÃO..................... ............................... ..................... ..................... ..................... ..................... .................... ..................... ..................... ..................... .................... ......... 4 CONSULTA DEFINIÇÃO DE DADOS.................... .............................. ..................... ..................... .................... ..................... ..................... ..................... ..................... .............. 6 Tipos de dados do SQL compatíveis com o Access.............. Access......................... ..................... .................... ..................... ..................... ............... .....
CONSULTA PASSO ATRAVÉS..................... ................................ ..................... .................... ..................... ..................... ..................... ..................... .................... ................... ......... CRIAR SUB ................................ ..................... .................... ..................... ..................... ..................... ..................... .................... ..................... ................ ..... RIAR SUB-CONSULTAS.....................
8 8
DIFERENÇAS ENTRE CONSULTAS CONSULTAS AÇÃO E CONSULTAS CONSULTAS SELEÇÃO............... SELEÇÃO............................ ............. 8 ALTERANDO DADOS COM CONSULTAS AÇÃO...................................................................9 CONSULTA CRIAÇÃO DE TABELA: .................... .............................. ..................... ..................... ..................... ..................... .................... ..................... ..................... ............ CONSULTA ECLUSÃO: .................... .............................. ..................... ..................... .................... ..................... ..................... ..................... ..................... .................... ............... ..... CONSULTA ATUALI"AÇÃO: .................... .............................. ..................... ..................... ..................... ..................... .................... ..................... ..................... ................... ......... CONSULTA ANEAÇÃO: .................... ............................... ..................... ..................... ..................... .................... ..................... ..................... ..................... ..................... ............. ...
9 1! 1! 11
ESTRUTURANDO FORMULÁRIOS.............. FORMULÁRIOS............................. ............................. ............................ ............................ ............................ .................. .... 12 CRIANDO CONTROLES .................... .............................. ..................... ..................... ..................... ..................... .................... ..................... ..................... ..................... .............. ...
12
Controles vinculados! n"o vinculados e calculados............. calculados........................ ..................... ..................... ..................... .................... ............ .. 1# $e%inindo propriedades propriedades de controle............ controle...................... ..................... ..................... .................... ..................... ..................... ..................... ..................1& .......1&
PERSONALI"ANDO FORMUL#RIOS ..................... ............................... .................... ..................... ..................... ..................... ..................... .................... ..................... .............
14
Alterando ordem de tabula'"o ............... ......................... .................... ..................... ..................... ..................... ..................... .................... ..................... ............. 1( Criando outros controles utili)ando a cai*a de %erramentas.......... %erramentas.................... ..................... ..................... ..................... .............1+ ..1+ Fornecendo uma uma lista de op',es com com uma cai*a de lista-em lista-em ou uma cai*a cai*a de combina'"o.... 1
CRIANDO UM FORMUL#RIO$SUB-FORMUL#RIO SEM A A%UDA DO ASSISTENTE.................... .............................. .................... .................. ........ 1& inculando um %ormulário e um sub/%ormulário............. sub/%ormulário....................... .................... ..................... ..................... ..................... .................. ....... 10
CALCULANDO UM TOTAL PARA UM 'RUPO DE RE'ISTROS.................... .............................. ..................... ..................... ..................... ..................... .............. 19
ESTRUTURANDO RELATÓRIOS.............. RELATÓRIOS............................ ............................ ............................ ............................ ............................. ....................... ........ 21 ADICIONANDO
............................... .................... ..................... ..................... ..................... ..................... ..................... ..................... .................... ............... ..... SEÇ(ES.....................
21
Cabe'alo do Relatório...............................................................................................................#1 Cabe'alo da 2á-ina.............. 2á-ina......................... ..................... .................... ..................... ..................... ..................... ..................... .................... ..................... ................. ...... #1 2ara adicionar cabe'alo cabe'alo e rodap3 a um relatório relatório ou pá-ina............ pá-ina...................... .................... ..................... ...................#1 ........#1 Cabe'alo do 4rupo.............. 4rupo........................ .................... ..................... ..................... ..................... ..................... .................... ..................... ..................... .................. ........ #1 2ara adicionar cabe'alo cabe'alo e rodap3 a um -rupo....... -rupo.................. ..................... ..................... ..................... .................... ..................... ............. .. #1 Se'"o detale...............................................................................................................................## Rodap3 do -rupo............. -rupo........................ ..................... ..................... ..................... .................... ..................... ..................... ..................... ..................... .................... .............. .... ## Rodap3 da pá-ina.............. pá-ina......................... ..................... .................... ..................... ..................... ..................... ..................... .................... ..................... ..................... ............## ..## Rodap3 do relatório.......... relatório..................... ..................... ..................... ..................... .................... ..................... ..................... ..................... ..................... .................... .............## ...##
USANDO EPRESS(ES EM RELAT)RIOS .................... ............................... ..................... ..................... ..................... ..................... ..................... .................... ................ ...... 2*
MACROS................................ MACROS.................. ............................. ............................. ............................ ............................ ............................ ............................ ............................. ................... .... 24 O QUE É UMA MACRO+................ +........................... ..................... ..................... ..................... .................... ..................... ..................... ..................... ..................... .................. ........ PORQUE USAR MACROS+................ +........................... ..................... .................... ..................... ..................... ..................... ..................... .................... ..................... .................. .......
24 24
Fa)er seus seus %ormulários e relatórios trabalem trabalem 5untos............ 5untos...................... .................... ..................... ..................... ..................... ........... #( 6ncontrar e %iltrar %iltrar re-istros automaticamente automaticamente.......... ..................... ..................... ..................... ..................... .................... ..................... ............. .. #+ $e%inir valor em controles............. controles........................ ..................... .................... ..................... ..................... ..................... ..................... .................... .................... .......... #+ 4arantir a precis"o dos dados................. dados............................ ..................... ..................... ..................... .................... ..................... ..................... ....................#+ ..........#+ $e%inir propriedade propriedade de %ormulários! relatórios relatórios e controles..... controles................ ..................... .................... ..................... ....................#+ .........#+ Automati)ar trans%er7ncias de dados....... dados................. ..................... ..................... ..................... ..................... .................... ..................... .....................#+ ..........#+ Criar o seu próprio ambiente de trabalo personali)ado................ personali)ado........................... ..................... .................... ..................... ............#+ .#+
CRIANDO UMA MACRO..................... ................................ ..................... .................... ..................... ..................... ..................... ..................... .................... ..................... .............. ...
26
2ara criar uma macro............ macro....................... ..................... .................... ..................... ..................... ..................... ..................... .................... ..................... .................. .......# # A 8anela 9acro............ 9acro...................... ..................... ..................... ..................... ..................... .................... ..................... ..................... ..................... ..................... ................. ....... # Adicionando a',es a uma uma 9acro................ 9acro.......................... .................... ..................... ..................... ..................... ..................... .................... ..................# ........# $e%inindo ar-umentos.......... ar-umentos.................... .................... ..................... ..................... ..................... ..................... ..................... ..................... .................... .................... .......... #0 Salvando uma 9acro...................................................................................................................#0 Criando um -rupo de macro.............. macro........................ .................... ..................... ..................... ..................... ..................... .................... ..................... ................. ...... #;
LISTA DE AÇ(ES DE MACRO..................... ................................ ..................... .................... ..................... ..................... ..................... ..................... .................... ................. ....... *2 R ESPONDENDO ............................... ..................... ..................... .................... ..................... ..................... ................. ....... *4 ESPONDENDO A EVENTOS EM FORMUL#RIOS..................... Fa)endo Formulários Formulários trabalarem trabalarem em con5unto........ con5unto................... ..................... ..................... ..................... .................... ..................... .............&( ..&( Atribuindo macros macros de valida'"o a eventos eventos de %ormulário e de controle ............... .......................... .................... ......... &+ 6*ibindo mensa-ens mensa-ens de valida'"o di%erentes di%erentes para condi',es di%erentes............ di%erentes....................... ..................... ............ .. &
CRIANDO NOSSOS PR)PRIOS MENUS.................... .............................. .................... ..................... ..................... ..................... ..................... .................... .................... ..........
*8
$e%ini'"o do 9enu............... 9enu......................... .................... ..................... ..................... ..................... ..................... .................... ..................... ..................... ....................&0 ..........&0 $e%ini'"o da >arra de 9enu......... 9enu.................... ..................... ..................... ..................... .................... ..................... ..................... ..................... .....................&; ..........&; Atribuindo uma uma >arra de 9enu a um %ormulário........ %ormulário................... ..................... ..................... ..................... .................... .....................&; ...........&;
MÓDULOS..... MÓDULOS............... ..................... ..................... ..................... ..................... .................... ..................... ..................... ..................... ..................... .................... ..................... .............. ... 40 ESTRUTURA DO M)DULO.................... .............................. ..................... ..................... .................... ..................... ..................... ..................... ..................... ..................... ............. DECLARANDO VARI#VEIS..................... ............................... ..................... ..................... .................... ..................... ..................... ..................... ..................... .................... ............
4! 4!
Tipos de $ados............................................................................................................................(1
USANDO DADOS CONTIDOS NOS FORMUL#RIOS..................... ................................ ..................... .................... ..................... ..................... ..................... .............. ... 42 OB%ETOS DE BANCO DE DADOS.................... ............................... ..................... .................... ..................... ..................... ..................... ..................... .................... ............. ... 4* VALIDAÇÃO DE CAMPOS COM M)DULOS..................... ............................... ..................... ..................... .................... ..................... ..................... ..................... ............... 44
Introdução ao MS-Acces MS-Access: s: Recapitulação: Tabelas: U, /03/ /5 ,5,/ 557/ / ;/< ;/< , =0 >,?7 >,?7 /5 /5 , R@;5>/5 0;75 C,/5 /075
Consultas: O=/ 50;/7 >@;5>/5 ,/5 >,?7/5 75 =05. V/ / 75> 7, /750 /750 /,/ , 5;5 5;5 7, /77/ >;0> >; 0> /5.
Forul!rios: O=/ 7/ 0 G/ /0/ /7>/05 > 7>< H;=;3/ ;3/ /5 7/5 ,/5.
Relat"rios: O=/ O=/ >57 >57 /5 /5 /5 />, />,/5 /5 />@7; />@7;?/ ?/55 5@7/ 5@7/ 5 5;;J5 / 5K>;/.
Se#urança: Antes de coeçar : DG-5 >;> , ; >5>G / =7/ /5 / @>/ >=0/< SSTEM.MDA< /7 / M;>/5/ A55 >,?7 5 5;;J5 5 /J5 5K>;/ 5 /7;@>J5 =>> >>,75. E, , ,=;7 ,0;5K>;/< / =7/ /5 / @>/ >=0/ ,=, /7, 5 ;7/>,J5 5>/ 5@>7 / 5 @>/. S / 5 >;G/ SSTEM.MDA /> >;/ / 7;;/< G/ 73/ />K ;7;;> / M;>/5/ A55. U, G? ; , ; >5>G 55 >;G/< 5 5>K >;5/ /;K-0/ 7/G,7 5/ ,75 75 /J5< =>> >>,75 / 75 ;7/>,J5 5>/ 5@>7.
$roteção dos dados P>/@> , ;7/>,3/ / 5> , > ;,/>7 7/ 57G/0G;,7/ , =7/ /5 / M;>/5/ M;>/5/ A55. A55. A>G5 A>G5 >/3/ >/3/ / 5 =7/ /5< G/ />K /7>/0> / , 5K>;/ / , @>/ 5K>;/5 / ?> /, /=/5 / =7/ /5. A 5@>7 5@>7 / M;>/5/ M;>/5/ A55 /,/5 GK>;5 >5 >;5, 5> 7/ 0@> 75 5@>7 5 /70: @>/5 >=0/< 5K>;/ /75 / @>/< /55< >;=;J5 >,;553/. 1 2 * 4 6
P> >/@> , =7/ /5: A>;=;> 5 5 7 / / 5 5K>;/ Administrador 5; 5;> / A 55 L/@ /@> > /,/ /,/ A,;7;5>/> D;7;> @>/5 5K>;/5 D;7;> >,;55J5 / @>/ C>;> 5K>;/5 T;>> >> 5 5 >,;55J5 J5 /5 /5 @> >/5 U5K>;/5 >;/5 A A,;7;5 7;5> >/> />5 C/0/> /5 5K>;/5 G3/ ,;7;5>> / =7/ /5 7/ @>/ A,;7;5>/>5
I,/>7: I,/>7: V/ >;5 >;5 >,/G> >,/G> 5 >,;55J5 >,;55J5 / 5K>;/ 5K>;/ ,;7;5> ,;7;5>/> /> / @>/ 5K>;/5< 5K>;/5< ;70; //5 /5 5K>;/5 5K>;/5 , , @>/ >=0/. >=0/. A G/ >,/G 55 >,;55J5< /5 5K>;/5 />3/ > >,;55J5 ;7G/07K>;5 > /=/5. T7/< , G?< 5 >,;55J5 >,/G;5< /5 5K>;/5 55>3/ > 5/,7 5 G/ >;=;. P> 55@>> >/3/ / =7/ /5< ;,/>7 ;,/>7 >57> , 57 /7 /7 / ,; ,;7;5 7;5> >/ />> 5 /7 /7 55 / >/>; >/>; K>; K>;// ,; ,;7; 7;5 5> >/> /> 5; 5;@7 @7 5. 5. A;;/70,7< G/ />K >57> , 57 5 /75 >;5 > 5K>;/5 / ;75>-0/5 > >57> 5 55 >>;5 575.
O=5>GJ5: A 5@>7 7 >03/ 7> /75 / @>/ >=0/ / M;>/5/ A55 5 >;=;J5 >,;553/ , 5 =7/ /5. O M;>/5/ A55 >,?7 ;7/>,3/ /7 /, / @>/ >=0/ >;=;J5 >,;55J5 7/ >;G/ .MDB / =7/ /5.
E%erc&cio: I,0,7 5@>7 7/ =7/ /5 / >5/< >;7/ >5 @>/5: · · ·
DBA - ,;7;5>/> T/5 5 >,;55J5 '>75 - 5K>;/ 5/,7 > 0;> D;@;/>5 - 5K>;/ /, >,;55J5 > 0;>< @>G3/< H053/ 0;?3/
Consultas: 'sando S() no MS-Access A S>> Q> L7@@ SQL , 0;7@@, ,;/ 5 7 /750< 0;?3/ @>7;,7/ =7/ /5 >0;/7;5. C /750 >; 7/ MSA55 , , ;75>3/ SQL 55/; ;7 5 J5 0 /750. N/>,0,7 ,;5 /7G7;7 5> @> QBE 5 >>,75 @>K;5 5>>3/ /750 / A55 > >;> ,/;;> /7505. M5 5 G/ 5K ,;0;>;?/ /, SQL< / 5> ;75>J5 SQL >:
Consultas 'nião É , /750 5; SQL >; , >50/ /77/ /5 //5 /5 >@;5>/5 5;;/5 , 5 / ,;5 =05. P0/ /7>K>;/< , /750 =5 , , 55/;3/ >; , 75 /77/ /5 5/,7 >@;5>/5 /5 ,/5 >0;/7/5 7/7>, , /7;3/ 5;;. P/> H,0/< , /750 7;3/ =0 0;75 =0 />7/>5 >50 , Resultado /7, //5 /5 >@;5>/5 5;;/5 , ,=5 5 =05< 0;75 />7/>5. A /750 7;3/ 5@;>< /75;5 5 ;75>J5 SELECT >/>7, /5 7/,5 ,>5 ;5 5, 7/ 7 =0 F/>7/>5 /,/ 7 =0 C0;75< 5, / B>5;0. A 5@;7 /750 7;3/ /75;5 5 ;75>J5 SQL SELECT >/>7, /5 7/,5 /,7;5 ;5 53/ 75 =05 F/>7/>5 C0;75 53/ / B>5;0. SELECT N/, ,>5< C; FROM F/>7/>5 ERE P;5WXB>5;0X UNION SELECT N/, ,>5< C; FROM C0;75 ERE P;5WXB>5;0X
A 5@;7 /750 7;3/ 50;/7 / 7/, /5 5 ,>55 ;5 5, 75 =05 F/>7/>5 C0;75 055;; 0=;,7 /5 /5 /> ;. SELECT N/, ,>5< C; FROM F/>7/>5 UNION SELECT N/, ,>5< C; FROM C0;75 ORDER B F/>7/>5< C; A /750 7;3/ 5@;> >7/,; / ,/ XN/, ,>5X > XN/, / 0;7$/>7/>X 7 5 /750 SELECT N/, ,>5 AS N/, / 0;7$/>7/>< C; FROM F/>7/>5 UNION SELECT N/, ,>5 AS N/, / 0;7$/>7/>< C; FROM C0;75 A /750 7;3/ 5@;> ;0;? ;75>3/ UNION ALL > >>> >@;5>/5 0;/5: SELECT N/, ,>5< C; FROM F/>7/>5 UNION ALL SELECT N/, ,>5< C; FROM C0;75
Consulta De*inição de Dados E5 ;/ /750 >; , =0 5, ;;/7> 77, >@;5>/ 0< ;7>557 7/ >;5,/5 >;> =05 ,/>K>;5. V / H,0/:
CREATE TABLE S)CIOS C;@/ COUNTER < N/, TEXT !< R TEXT !< CONSTRAINT C;@/D/S;/ RIMAR! "E! C;@/ N/ H,0/ ;, >; , =0 S;/5 /, /5 5@;75 ,/5: C,/ C;@/ N/, R
T;/ C/7/> TH/ TH/
T,7/ 4 =5 ! !
A 0G> G CONSTRAINT ;7; , 5@; G, / 7/, , 7; ,/ C;@/D/S;/< 7> >75;5 G, / 7/, / ,/ ? > 5 7; /;/70,7 050 RIMAR! "E! > ;7;> G >;,K>; =0.
Tipos de dados do S() copat&+eis co o Access T;/ / BINAR
T,7/ 1 =
BIT
1 =
BTE COUNTER
1 = 4 =5
CURRENC
8 =5
D5>;3/ P> /7505 , =05 7H5 , >//5 =7/ /5 ;7, , ;/ /5 B;7K>;/. O M;>/5/ A55 73/ 5 / ;/ /5 B;7K>;/. V0/>5 S;, N3/ ,/5 /7, 75 , 7> /;5 G0/>5. U, G0/> ;7;>/ 7> ! 2. U, 7Y,>/ ;7>,7/ /,;,7 0/ M;>/5/ A55 7/ , 7/G/ >@;5>/ ;;/7/ , =0. N/ % =5 7@;7< / ;/ / > 5 G0/> L/7@. U, ;7;>/ ;,75;/7/ 7> -922.**&.2!*.68.4&&<8!8 922.**&.2!*.68.4&&<8!&.
T;/ / DATETIMEC/750 DOUBLE SIN'LE
DOUBLE
SORT LON' LON'TET LON'BINAR TET
T,7/ 8 =5
D5>;3/ U, G0/> / /> 7> /5 7/5 1!! 9999.
4 =5
U, G0/> /7/ 07 >;53/ 5;,05 /, , ;7>G0/ -*<4!282*E*8 -1<4!1298E4 > G0/>5 7@;G/5< 1<4!1298E-4 *<4!282*E*8 > G0/>5 /5;;G/5 !. 8 =5 U, G0/> /7/ 07 >;53/ 0 /, , ;7>G0/ -1<&9&69*1*4862*2E*!8 -4<94!66484124&E-*24 > G0/>5 7@;G/5< 4<94!66484124&E-*24 1<&9&69*1*4862*2E*!8 > G0/>5 /5;;G/5 !. 2 =5 U, ;7;>/ >/ 7> -*2.&68 *2.&6& 4 =5 U, ;7;>/ 0/7@/ 7> -2.14&.48*.648 2.14&.48*.64&. 1 = /> ">/ , ,KH;,/ 1<2 @;@=5. C/750 >> TH. C/,/ ">/ , ,KH;,/ >/H;,,7 1 ;7;/ @;@=. U5/ > /=/5 OLE. 1 = /> ">/ 2 >>5. >>
EH>;/ C>;> , /750 D;7;3/ D/5 > >;> , =0 /, 5@;7 5>>: N/, / C,/ T;/ / / T,7/ C;@/ / P>// C/7/> N/, / P>// TH/ 4! Q7; P/> U7; TH/ 2! P>/ U7;K>;/ M/ U7;5 , E5/ NY,>/ I7;>/ C@/>; TH/ 1 F/>7/> TH/ 4! O 7/, =0 5> >; 5>K Informações dos produtos . C/,/ G >;,K>; 5>K ;0;?/ / ,/ Código do Produto .
Consulta $asso Atra+,s A5 /7505 55/ >G5 73/ 53/ H5 0/ A55< 05 53/ H5 0/ 5>G;/> SQL< /> ;55/ 73/ /55G0 5> / SQL / A55< G;5/ 0 73/ 5@ / >3/ ANSI /,/ /5 5>G;/>5 SQL. E5 /750 ,7;0 /5 /5 ;>,7 7/ 5>G;/> 73/ 5 =05 ;0;?5 73/ >;5, 5> 7H5.
Criar sub-consultas > >;> , 5=-/750< G/ 5 @> QBE< ,5 ;75> , ;75>3/ SQL SELECT /,/ >;>;/. P> ,;/>5 ;7/>,J5 /750 Criando uma Sub-consulta 7>/ SQL: sub-consultas 7 / MS-A55.
Di*erenças entre consultas Ação e consultas seleção Q7/ 5 >; , /750< / MS-A55 >; , /750 503/< 73/ 5> 5 5/0 , ;/ ;>7 7/ ,7 #$%&'()*. Q7/ , /750 503/ H< / MS-A55 H;= / Dnaset < /5 >@;5>/5 >>/5 55 =05. P/-5< 73/< G;50;?> / 75 ?> 0>J5 , 55 /5. E7>7/< / ?> 0>J5< 05 53/ ;75>;5 >@;5>/ >@;5>/. C5/ , @>7 7Y,>/ 0>J5 5;,;0>5< G/ / /> ,/ 57/ , consulta aç!o" U, /750 3/ ? ;5> 0>J5 , 75 , />3/. P/> H,0/< 5/ 5 H0;> //5 /5 >//5 7, 5;/ 5/7;7/5< G/ / H> , /750 3/ >,/G //5 555 >//5. P> 5 @>7;> 0>J5 ;755 73/ 5, ;5 5 G/ H> +%*,/)+,*%) , /750 3/< / MS-A55 H;= 7 70 B7/ /5< , /7 5;0 > ;7;;> 5 >/ /7505 3/. C/750 A7H3/ C/750 A0;?3/ C/750 C>;3/ T=0 C/750 EH053/
Alterando dados co consultas Ação Consultas Ação: C/, 5 /7505 3/< G/ / >;> 7/G5 =05 / 0>> /5 /5 =05 K H;575. T/5 5 Consultas Aç!o 53/ ;5 /, =5 7, consulta seleç!o < 73/ > 5 >;> 0> ;/ /750 3/< G,/5 >;> 5 /7505 503/ 7/5 >>3/ /5 /5 5,/5 ,7;0> 05 /7505 3/< /7/ 55;, 0;?>< H0;>< H/>> 7H> /5. O MS-A55 >//>;/7 >/ ;/5 /7505 3/.
Consulta criação de tabela: C>; , 7/G =0 >;> /> / > /> =0 /, , 7/G/ 7/, ;7;/ 0/ 5K>;/ ;;/77/ /5 >@;5>/5 5;;/5 0/ >;>;/.
Consulta e%clusão: EH0; /5 >@;5>/5 , / ,;5 =05 7, , >;>;/.
Consulta ane%ação: A;;/7 , @>/ >@;5>/5 , / ,;5 T=05 > /> / ,;5 =05.
Consulta atualiação: A0> / /5 , , @>/ >@;5>/5 , / ,;5 =05.
Consulta Criação de Tabela: ·
·
·
A5 >;>,/5 /750 503/ /, /5 ,/5 5/5< 0; 7/ =/3/ /750 criaç!o de tabela < , 5@; />7 / 7/, =0 5> >;. S /> 755K>;/< G/ / >;> 5 =0 , />/ =7/ /5< 0;7/ 7/ =/3/ outro banco de dados />7 / 5 7/,. D/;5 >55;/7 / =/3/ OZ. Q7/ G/ 0;> 7/ =/3/ #$ecutar < / MS-A55 ;7/>, 75 0;75 >@;5>/5 5>3/ ;70/5 7 7/G =0< 75 ,75@,< G/ / /7;>,> >;3/ / 70> ;7053/. S G/ 0;> 7/ =/3/ %odo &ol'a de Dados< /750 503/ 5>K H G/ G>K /5 >@;5>/5 G3/ > 7/G =0.
E%erc&cio I C>; , /750 C>;3/ =0 > 0;5> / (ome do produto) Quantidade em esto*ue / &ornecedor < Código do &ornecedor < /7 7; , 5/ 5 ,7/> 2!. O 7/, =0 5 5>K Produtos em +ai$a . S0G /750 /,/ Cria Produtos em +ai$a .
Consulta e%clusão: ·
·
·
Q7/ 5,/5 H0;> GK>;/5 /5 , =0 /, /5 0@75 /5 , /,,< 75 G,/5 >;> , /750 503/ > H;=;> 55 >@;5>/5 /;5 >75/>,>K 7, /750 H053/. Q7/ G/ 0;> 7/ =/3/ #$ecutar < / MS-A55 ;7/>, 75 0;75 >@;5>/5 5>3/ H05 =0< 75 ,75@,< G/ / /7;>,> 0;,;73/ / 73/. S G/ 0;> 7/ =/3/ %odo &ol'a de Dados< /750 503/ 5>K H G/ G>K /5 >@;5>/5 G3/ H0/5.
E%erc&cio II C>; , /750 > H0;> //5 =0 >//5< //5 /5 >//5 5, /, 7; , 5/ =;H/ 2!. S0G /, / 7/, EH0; P>//5 , B;H.
Consulta Atualiação: ·
A /750 0;?3/ 0;? /5 /5 , / ,;5 ,/5< >;-5 /750 503/ /, /5 ,/5 5/ /;5 >55;/7 / =/3/ consulta atuali,aç!o 7 0;7 atuali,ar para G/ /0/ / G0/> / H>553/ ;>K 0;?> / ,/.
E%erc&cio III C>; , /750 > 0;?> / ,/ U7;5 , 5/ , ![ 5 / G0/> /> ;>7 ! ?>/ / ! 5 /> ;@0 ! ?>/. S0G /, / 7/, Atuali,a Produtos.
Consulta ane%ação: ·
·
·
A /750 7H3/ 7/5 >,; 7H> /5 , =0 />. P> ;55/ G,/5 >;> , /750 503/ /, /5 ,/5 5,/5 7H>< /;5 0;,/5 7/ =/3/ /750 7H3/ 5K >/7 /750 7H3/. Q7/ G/ 0;> 7/ =/3/ #$ecutar < / MS-A55 ;7/>, 75 0;75 >@;5>/5 5>3/ 7H5 =0< 75 ,75@,< G/ / /7;>,> 7H3/ / 73/. S G/ 0;> 7/ =/3/ %odo &ol'a de Dados< /750 503/ 5>K H G/ G>K /5 >@;5>/5 G3/ 5> 7H/5.
E%erc&cio I. C>;> , /750 > A7H> /5 ,/5 > =0 Informações do produto"
Estruturando *orul!rios Criando Controles Q7/ /, , />,0K>;/ , =>7/< G/ ,5,/ ;;/7 //5 /5 /7>/05. S >;/ , />,0K>;/ /, / 55;57 />,0K>;/< /-5 ,=, 5> ;;/7> /7>/05 > H;=;> /5 ;;/7;5 / > />7> / />,0K>;/ ,;5 >7 / ,;5 K;0 5>. P/> H,0/< G/ / 5> ;;/7> , ; ;70 ;75>J5 5/=> /,/ ;0;?> , />,0K>;/ 7/ modo formulrio .
Controles +inculados/ não +inculados e calculados Q7/ 5 ;;/7 , /7>/0 , />,0K>;/< >,;7-5 /7 0 /=, ;7/>,3/ H;=. P/> H,0/< G/ / ;;/7> , /7>/0 ;H H/ H;= , >// /,7; >;> / ,/ N/,D/P>// =0 >//5. A ;H H/ /=, /5 G0/>5 >;> / ,/ N/, / P>// /> > 5;/ /7/ / G;70/ 0 ,/. O5 /7>/05 ,=, /, H;=;> ;7/>,J5 73/ 5, >,?75 7/ =7/ /5< ;5 /,/ ;75>J5< 0@75 G0/>5 00/5. C/7> />;@, /5 /5 , /7>/0 ;;> ;/ /7>/0 5> /,/ >;-0/. O5 /7>/05 /, 5> G;70/5< 73/ G;70/5 00/5. A ;05>3/ 5@;7 ,/5> /5 >5 ;/5 /7>/0.
S G/ /,>> , />,0K>;/ 7/ ,// 5>> 7/ ,// /0 /5< />K G> /7H3/ 7> /5 /7>/05 / />,0K>;/ /5 ,/5 =0 />;@, / />,0K>;/.
De*inindo propriedades de controle N/ MS-A55< 5 >/>;5 53/ 55 > >,;7> 5 >>5;5 5 =05< /7505< ,/5< />,0K>;/5 >0>;/5. C /7>/0 , />,0K>;/ , ,=, >/>;5. A5 >/>;5 /7>/0 >,;7, 5>> >7; , /7>/0 =, /,/ 5 >>5;5 / H/ / /5 /5 0 /7,. P/> H,0/< G/ / ;7;> >/>;5 />,, /5 G0/>5 , /7>/0 /,/ ,/ /5 H;= , 7@>;/. P/-5 G> 5 >/>;5 , /7>/0 H;=;7/ 5 /0 >/>;.
*/* ++/ * 3$(* , 5/$5/+,*, , ' #$%)/$( C0; 5 G?5 7/ /7>/0 55 ,// 7;/7 /, //5 /5 ;/5 /7>/0 H/ 5=-/>,0K>;/5< 5=->0>;/5 /=/5 OLE 73/ G;70/5. -OS0;/7 / /7>/0 5/0 /$5/+,*,& 7/ ,7 E++/ / 0; 7/ =/3/ \P>/>;5] 7 =>> >>,75. S / /7>/0 , , ; 7H< 50;/7 / /7>/0 73/ 5 ; > H;=;> /0 >/>;5 , ;< 50;/7 ;.
A; >,/5 0@,5 >/>;5< /,75 > GK>;/5 O=/5< 555 >/>;5 /, 5> ;7;5 7/5 /7>/05 7/ > />,0K>;/ 7/ > >0>;/< G;5/ /7>/0 , , ,; 2! *! >/>;5 >,/5 ; 5/,7 0@,5 53/ /,75 GK>;/5 /7>/05< /,/ /> H,0/.
P>/>; O>;@, / C/7>/0
D5>;3/ N/, C,/ / EH>553/ > 5> /,/ /7 /5 > C/7>/0 T=0> A/,;,7 P/ @>> / 73/ , =03/ 7/ / Y0;,/ >> >,;;/ , , ,K5> 7> , ;H H/ ;75>;/. C/,/>,7/ T0 E7> P>3/ >/ ,/ N/G L;7 7/ ,/< >; , 0;7 , =>7/ 7/ ,5,/ ,/ > ;75>3/. V;5G0 T/>7 / /=/ G;5G0 A;G/ =;0;> /7>/0 7/ ,// />,0K>;/ P> T=03/ P>,; =0J5 7/ /7>/0 ^7; T=03/ D;7;> />, =03/ P/ A,0;> C/7>/0 / 53/ H7 /,;,7 > => 7/ H/.< P/ R?;> D>,;7 5 / ,7/ , 5553/ / /7>/0 5>K R?;/ G>;0,7 > /,/> 7; /5. A/ E7>> M>/ / 73/ H 7/ / /7>/0 >= / >;,;>/ // A/ S;> M>/ / 73/ H 7/ / /7>/0 > / // 7/ ,5,/ />,0K>;/. P> /=> ,;5 ;7/>,J5 /750 D3+%+%,$ /$5/+,*,& 7/ 0 / MS-A55.
$ersonaliando *orul!rios V/ / 5> ,;5 >/;G/ /, />,0K>;/5 >5/70;?/5 5 , 5 55 755;5 >;0>5. P/> H,0/< G/ / >5/70;?> >57 0;55 /J5 > 5 5/0< ;;/7> , =/3/ />7 K;0 =>> , />,0K>;/ >0;/7/ 5> ;,@75 , G? H/ , =/J5.
Alterando orde de tabulação Q7/ ;;/7 /7>/05 , />,0K>;/< / MS-A55 >;=; /,;,7 , />, =03/ /5 /7>/05. Q7/ 0 T= >55;/7 7/ ,// />,0K>;/ / // 5 ,/G /7>/0 > /7>/0 />/ /, />, =03/. O MS-A55 /0/ /,;,7 7/ ;70 />, =03/ 7/ ;70 7/G/ /7>/0 ;;/7/. E, 0@75 5/5 55 / 73/ 5> />, =03/ 5. P/> H,0/< G/ / >/>@7;?> 0@75 /7>/05 , , />,0K>;/ /;5 /0/K-0/5. N55 5/< G/ >/GG0,7 5>K 0>> />, =03/ > K-0 7/G ;5/5;3/. P> ?> ;55/< 5 / /,7/ O/, , T*'(*67$ 7/ ,// E5>>.
O /,7/ O/, , T*'(*67$ H;= 75 /5 7/,5 /5 /7>/05 G/ / 50;/7> / > /5 ;5 /-5 =0> 7/ ,// />,0K>;/. O5 7/,5 /5 /7>/05 73/ /, 5> 50;/7/5< /,/ ;5 / 0;75< 73/ 53/ ;70/5. O5 7/,5 53/ H;=;/5 7 />, =0 >G5 /5 /7>/05. V/ / ?> /, / MS-A55 >; /,;,7 , />, =03/ >/>> /5 /7>/05 5> > ;>; ;, > =;H/ / ,5,/ >;> , />, =03/ >5/70;?.
*/* #/+*/ '* $/, , )*'(*67$ ,* E&'/,* 5*/* * D+/+)* , C+* 5*/* B*+$ 1. C/, / />,0K>;/ =>/ 7/ ,// 5>>< 5/0 O/, , T*'(*67$ 7/ ,7 E,+)*/. 2. E5/0 / =/3/ O/, A')$)+#*.
Criando outros controles utiliando a cai%a de *erraentas S G/ 5 >;> /7>/05 73/ G;70/5 / 00/5< 5 =>> >>,75. T,=, / 5> ;H >>,75 > >;> /7>/05 G;70/5 73/ 5, ;H5 H/5. A ;H >>,75 , =>> >>,75 5;0;?: G/ / 5/0> B*//*& , F//*%)*& 7/ ,7 E++/< > ;G> / 5;G> ;H >>,75. O MS-A55 H;= /,;,7 ;H >>,75 7/ G/ => , />,0K>;/ 7/ ,// 5>>< 5 5 =>>5 >>,75 5;G>, ;G5.
A ;H >>,75 , >>,75 > //5 /5 ;/5 /7>/05 G/ / >;> 7 5>> , />,0K>;/. M/G-5 ;H >>,75 50;/77/ >>57/ ,5,< / K-0 0;7/ 7 ;H /7>/0 7/ 7/ 5>;/> 5>/.
P> H;=;> / > ;H >>,75 N/ ,7 H;=;>< 5/0 ;H >>,75 / 0; 7/ =/3/ \;H >>,75] 7 =>> >>,75. P> >,;7> ;70; , >>,7 P/5;;/7 / /7;>/ / ,/5 5/=> >>,7 O MS-A55 H;= / 7/, >>,7.
Fornecendo ua lista de opç0es co ua cai%a de lista#e ou ua cai%a de cobinação U, ;H 0;5@, , 0;5 5;,05 G0/>5 > G/ 50;/7>. U, ;H /,=;73/ /,/ , ;H H/ , ;H 0;5@, /,=;75 , , /7>/0< G/ 7/ / ;@;> , G0/> 7 ;H H/ /,/ 50;/7> , G0/> 7 0;5. *%)*;%& ,* #*+* , (+&)*; A 0;5 > /5 5 G?5 / G0/> / /7>/0 ; 0;,;/ / /77/ 0>7;G5 0;5. P> ,/G> >;,7 > / >;,;>/ ;7;;/ /, , >,;7 0> G/ / ;@;> 55 0>. Q7/ 5 5K 57/ , />,0K>;/ > ;75>;> / ;>< 73/ 5 / ;;/7> , G0/> 73/ 5 7 0;5.
*%)*;%& , '* #*+* , #$+%*67$
U, G? 0;5 73/ H;=; 5 =>< / /7>/0 / ,7/5 5/ 7/ />,0K>;/. V/ / ;@;> /5 >;,;>/5 >>5 , G0/> 7 ;H /,=;73/ > >;,7 7/7>> 55 G0/>. A0, ;55/< /-5 /> /> >,;;> 7> G0/>5 7/G/5 7 ;H /,=;73/ / ;,;> 7> G0/>5 7/G/5.
Criando u Forul!rio1sub-*orul!rio se a a2uda do Assistente Q7/ 5K >;7/ , />,0K>;/ , 5=-/>,0K>;/ 5, / 55;57 F/>,0K>;/$S=-/>,0K>;/< ;7;;0,7 G/ >; / />,0K>;/ / 5=/>,0K>;/ 5>,7. E, 5@;< ;75> / 5=-/>,0K>;/ 7/ />,0K>;/. E5 ,// Y;0 5 G/ K >;/ , />,0K>;/ 5 ;75>;-0/ , ;G>5/5 />/5 />,0K>;/5. P/< ,=,< >>;> >;> / 5 >>;/ 5=-/>,0K>;/ 7/ ;5> >;> , 5=-/>,0K>;/ 5 ;>7 / />,0K>;/ / A55;57 >//.
C/+*%,$ ' 3$/'(/+$ ' &'-3$/'(/+$ U, 5=-/>,0K>;/ , />,0K>;/ 5>/< G/ >; 50G ,5, />, 0> />/ />,0K>;/. E73/< ;;/7-/ / />,0K>;/ ,// 5 55@>> / 5 G70/ / />,0K>;/. N ,;/>; /5 5/5< / MS-A55 G;70 / />,0K>;/ /,;,7 7/ G/ / ;;/7. EH;5< />,< 5;J5 /7 G/ , ;7;> 5 >/>;5 > G;70> / />,0K>;/ / 5=-/>,0K>;/. /5*/*%,$ $ 3$/'(/+$ 1. C>; / />,0K>;/. D;H 5/ 7/ />,0K>;/ > / 5=-/>,0K>;/. 2. S0G / />,0K>;/.
/5*/*%,$ $ &'-3$/'(/+$ 1. C>; , />,0K>;/ ;7 5 >/>;5 />,0K>;/ .isuali,aç!oAutori,ada
%odoPadr!o
A5%*& 3$(* , ,*,$&: C/0/ /5 ,/5 7/ />,0K>;/ 7 />, G/ 5 05 >, 7 /0 /5. V/ 73/ >;5 />@7;?> /5 ,/5< K 05 5,> >, /,/ , /0 /5. /5.
D;7 5 >/>;5 .isuali,aç!oAutori,ada %odoPadr!o /,/ /0
A5%*& 3$/'(/+$: C/0/ /5 /7>/05 /,/ G/ 5 >, 7/ ,// />,0K>;/. D;7 >/>; V;50;?3/A/>;? /,/ F/>,0K>;/. D;7 >/>; M//P>3/ /,/ />,0K>;/ 5;,05 / />,0K>;/5 /77/5.
F$/'(/+$& 3$(* , ,*,$&: C/0/ /5 /7>/05 /,/ G/ 5 05 >, 7/ ,// />,0K>;/. D;7 >/>; V;50;?3/A/>;? > ,=/5. D;7 >/>; M// P>3/ > />,0K>;/5 S;,05< />,0K>;/5 /77/5 / /0 /5. D77/ /,/ G/ 5 / 5=-/>,0K>;/ 5 G;50;?/ 7/ G/ => / />,0K>;/. 2. S0G / 5=-/>,0K>;/.
*/* *,+#+$%*/ ' &'-3$/'(/+$ * ' 3$/'(/+$ 1. A=> / />,0K>;/ 7/ ,// 5>>. 2. A0>7 > 70 B7/ D/5 P>55;/7 F11. *. A>>5 / 5=-/>,0K>;/ ;5> 70 B7/ D/5 /0/-/ /7 G/ / 5 7/ />,0K>;/. O MS-A55 ;;/7 / /7>/0 / 5=-/>,0K>;/ 55 ;5 7H5 / />,0K>;/. O /7>/0 / 5=-/>,0K>;/ 5K G;70/ / 5=-/>,0K>;/ >/H;,,7 / ,5,/ ,7/ / 5=-/>,0K>;/ / /7>/0 / 5=/>,0K>;/ ;70; 5/ > /5 50/>5 >@;5>/5< />, 5 />7 ,;/>. 4. M/G / /7>/0 / 5=-/>,0K>;/ < 5 755K>;/< 5 / 5 ,7/. . A0>7 > / ,// />,0K>;/ > G> / />,0K>;/ /, 5 5=-/>,0K>;/. 6. P> ?> 0>J5 7/ />,0K>;/< 0>7 > / ,// E5>>.
*/* 3*</ *()/*6=& %$ &'-3$/'(/+$> #$%&'() $ &;'+%) 5/$#,+%)$. 1. N/ ,// 5>>< 0; , 0> 0@> / />,0K>;/ /> / /7>/0 / 5=-/>,0K>;/ > > >? / /7>/0 / 5=-/>,0K>;/ 73/ 5K 50;/7/. 2. C0; 5 G?5 , 0> 7>/ / 5=-/>,0K>;/. O MS-A55 H;= / 5=-/>,0K>;/ 7/ ,// 5>>. *. F 5 0>J5 7 5>> / 5=-/>,0K>;/. 4. S0G / 5=-/>,0K>;/ 7/ ,// 5>> / 7/ ,// /0 /5. . C0; 7/ =/3/ \M// / F/>,0K>;/] 7 =>> >>,75.
.inculando u *orul!rio e u sub-*orul!rio
1. N/ />,0K>;/ 7/ ,// E5>>< => /0 >/>;5 > / /7>/0 / 5=-/>,0K>;/. 2. D;7 >/>; .incularAPartirDe /,/ / 7/, / ,/ G;70/ 7/ 5=-/>,0K>;/. P> 7>> ;G>5/5 ,/5 G;70/5< 5> /5 7/,5 /5 ,/5 /, /7/ G>@0. *. D;7 >/>; .incularA /,/ / 7/, / /7>/0 / ,/ G;70/ 7/ />,0K>;/. P> 7>> ;G>5/5 /7>/05 / ,/5 G;70/5< 5> /5 7/,5 ,/ / /7>/0 /> /7/ G>@0. 4. S0G / 5=-/>,0K>;/. . C0; 7/ =/3/ \M// / F/>,0K>;/] 7 =>> >>,75.
E%erc&cio . · · ·
C>; , F/>,0K>;/ > ,/5>> /5 ;/5 ;/5 /> , 0;7. C>; , F/>,0K>;/ > ,/5>> 5 ;7/>,J5 / 0;7 C>; , F/>,0K>;/ P>;7;0$S=F/>,0K>;/ /0/7/ 7/ P>;7;0 5 ;7/>,J5 / 0;7 7/ 5=F/>,0K>;/ /5 ;/5 ;/5 /> 0;7
Calculando u total para u #rupo de re#istros U5 73/ S$* > 00> / /0 , @>/ >@;5>/5. A5 5;7H > 73/ S$* :
S$*?e*pr O >@,7/ e*pr / 7/, , ,/ / , H>553/. É /55G0 5> 7/,5 ,/ 7/ >@,7/ e*pr 73/ S$*< ,5 73/ 7/,5 /7>/05. O5 7/,5 ,/ /, G;> , =0 / , /750. P/-5 5> / 7/, , ,/ 00/ >;> , /750. E7>7/< > 5=> / /0 /5 G0/>5 , , /7>/0 00/< 755K>;/ >;> H>553/ 5 7/ /7>/0 00/ 7 73/ S$*.
E%erc&cio .I C>; , />,0K>;/ =0> > ,/5>> /5 /5 ;75 , ;/ 55 >5;G/5 >/5 . N/ >/ / />,0K>;/ >; , ,/ 5/,7/ /5 /5 >/5 /5 >//5.
Estruturando relat"rios Adicionando seç0es V/ / ,7> ;;7; , >0>;/ ;;/77/ seções < 53/ 0,7/5 >>;/5 5>> / >0>;/. O MS-A55 /55; 5 ;/5 seções < / 5> 5/ , 0> /,=;7J5. P/> H,0/< 5 G/ 5 ;,>;,;> ;7/>,J5 ;7>/>;5 , >0>;/< G/ ;;/7> , =0/ ;,>;, 75 7 >;,;> K@;7 / >0>;/. N/ ,// 5>>< G/ G 5>> / >0>;/ /,/ seções /7>/05. O ,// 5>> >57 / ,/0/ > / >0>;/< se'"o / >0>;/ >>57 , G?< ;7 < 7/ >0>;/ ;,>55/< 0@,5 seções /, >;> 0@,5 G?5. P/> H,0/< 7/ G/ ;,>;, , >0>;/< / =0/ / @>/ / >/ / @>/ 5 >, > @>/< 77/ seç!o 0 5 > > >@;5>/.
Cabeçal3o do Relat"rio A> , Y7; G? 7/ ;7;/ / >0>;/. V/ / 5K-0/ > ;75 ;5 /,/ 0/@/;/. O =0/ / >0>;/ ;,>55/ 75 / =0/ K@;7 5/,7 7 >;,;> K@;7 / >0>;/.
Cabeçal3o da $!#ina A> 7 > 5>;/> /5 5 K@;75 / >0>;/. É 5/ > H;=;> ;75 ;5 /,/ 0@75 /075 , >0>;/ =0>.
$ara adicionar cabeçal3o e rodap, a u relat"rio ou p!#ina N/ ,7 />,>< 5/0 =0/$>/ / >0>;/
Cabeçal3o do 4rupo A> 7/ ;7;/ , 7/G/ @>/ >@;5>/5. É 5/ > H;=;> ;75< ;5 /,/ / 7/, / @>/.
$ara adicionar cabeçal3o e rodap, a u #rupo A />, 055;;3/ , >0>;/ ;7; 7 ;H ;K0/@/ C(*&&+3+#*/ R*;/'5*/. P> H;=;> ;H ;K0/@/ C055;;> R@>> 1. A=> , >0>;/ 7/ ,// 5>> 2. N/ ,7 H;=;> 5/0 055;;> >@>> / 0; 7/ =/3/ C055;;> R@>> 7 =>> >>,75. *. N /07 ,/$H>553/ 50;/7 / ,/ G/ 5 / ;@; , H>553/. T7 >? ;7;;> , H>553/ /, 5;70 ;@0.
Seção detal3e C/7, / />/ >;7;0 /5 /5 , >0>;/. O5 /7>/05 5 53/ >,-5 > >@;5>/ >;>/ / =7/ /5.
Rodap, do #rupo A> 7/ ;70 , @>/ >@;5>/. É 5/ > H;=;> ;75< ;5 /,/ /5 /;5 @>/.
Rodap, da p!#ina A> 7 > ;7>;/> /5 5 K@;75 / >0>;/. É 5/ > H;=;> ;75 ;5 /,/ 7,>3/ K@;75.
Rodap, do relat"rio A> , G? 7/ ;70 / >0>;/. É 5/ > H;=;> ;75 ;5 /,/ /;5 >0>;/. É Y0;, 53/ 7 >;3/ / >0>;/< ,5 > 75 / >/ K@;7 7 Y0;, K@;7 / >/ ;,>55/.
E%erc&cio .II C>; , >0>;/ > ,/5>> , 5 /,/ / >3/ =;H/:
'sando e%press0es e relat"rios V/ 5 H>55J5 > /=> ;7/>,J5 73/ /75@ /=> ;>,7 5 =05 , =7/ /5. P/> H,0/< , H>553/ / 5> ;0;? > 5=> 75 7;5 , >// G/ G7 , , ,5 / / 7Y,>/ ,;/ 7;5 G7 // ,5. U, /7>/0 7 H>553/ ;@0 5 />;@, /7>/0 , /7>/0 00/. S / /7>/0 , ;H H/< G/ / ;75>;> H>553/ ;>,7 7 ;H H/. D 0> ,//< / 5,> ;@;> H>553/ ;>,7 7 /0 >/>;5 / / ;7;> >/>; />;@, / /7>/0 /, / /75>/> H>55J5.
.
Macros U57/ ,>/5< G/ ?> 55 />,0K>;/5< >0>;/5 />/5 /=/5 =7/ /5 >=0>, 7/5 ,;5 ;;7,7. A5 ,>/5 /, /,;?> >5 >/;7;>5 / >;;G5 ;5 /,/ ;,>;,;> >0>;/5 5,7;5. A5 ,>/5 ,=, />, ; >5/70;?3/< ;5 /,/ G0;3/ /5 /,0H5 > />,0K>;/5. V/ / 5> ,>/5 > >;> 55 >>;5 =>>5 ,7 >5/70;?5 > 55 />,0K>;/5.
5 6ue , ua acro7 U, ,>/ H /,;,7 , > / , 5>; >5. C > 5 / MS-A55 H , , 3/. O MS-A55 >//>;/7 , 0;5 J5 7> 5 ;5 50;/7-5 > >;> , ,>/. Q7/ G/ H ,>/< / MS-A55 H 5 J5 7 5_7; , 05 53/ 0;55< 57/ /5 /=/5 / /5 ;G> 5;;/. P/> H,0/< G/ / >;> , ,>/ > =>;> /,;,7 , =0 , />,0K>;/ 5/5 7/5 >_7,7. E5 ,>/ 5 5 J5 > ;?> / MS-A55 > =>;> =0 < 73/< =>;> / />,0K>;/. Q7/ 5 ;;/7 / 0> /5 7/ />,0K>;/< /-5 5> , /> ,>/ > G>;;> /5 /5 H;=;> , ,75@, / > =>;> , />/ />,0K>;/.
$or6ue usar acros7 Q0> > >;;G / >/;7;> 7/ MS-A55 , =/ 7; , ,>/. A /,;?3/ >5 >/;7;>5 >? ;;7; >;53/ > 5 =7/ /5< /> , ,>/ H > 5,> / ,5,/ ,//. U57/ ,>/5< /55G0:
Faer seus *orul!rios e relat"rios trabal3e 2untos M;5 G?5< 5>K ;7>557 5> /;5 />,0K>;/ / ,5,/ ,/ > >/>> /5 >0;/7/5. Por e$emplo< G/ />K 5> , />,0K>;/ > G;50;?> ;7/>,J5 5/=> 55 F/>7/>5 , />/ > G;50;?> ;7/>,J5 5/=> 55 >//5. U57/ ,>/5< G/ />K ;;/7> , =/3/ /,7/ / />,0K>;/ F/>7/>5 ,// =>;> /,;,7 / />,0K>;/ P>// < 55;,< >57> 75 /5 >//5 0 />7/>. P/>K< ,=,< ;;/7> , =/3/ , />,0K>;/ > ;,>;,;> , >0>;/ /,/< /> H,0/< > ;,>;,;> , > , ; 7>,7/ , />,0K>;/ 5/ > >@;5>> 7/G/5 ;/5.
Encontrar e *iltrar re#istros autoaticaente A5 ,>/5 /, 0>> / >/55/ > 7/7>> /5 >@;5>/5 5 G>. Por e$emplo < G/ / 7H> ,>/5 =/J5 , , />,0K>;/ ,>@/5 > /> /,;,7 ;0>> >@;5>/5 , 5=/77/5 /> H,0/< //5 /5 ,>@/5 0/0;?/5 , T/>/7/ / //5 /5 >>5775 G75 >=0, > G/.
De*inir +alor e controles U57/ ,>/5< G/ / ;7;> / G0/> , /7>/0 , , />,0K>;/ /,/ / >50/ , K00/ / /,/ , G0/> , /> =0. Por e$emplo < 7/ G/ ;;/7 , >// , />,0K>;/ ;/5< G/ / 5> , ,>/ > >/>> /,;,7 / >/ 7;K>;/ 0 / >// ;75>;> / G0/> , , /7>/0 / />,0K>;/.
4arantir a precisão dos dados A5 ,>/5 53/ ;;5 > G0;3/ >,7/ /5 , />,0K>;/. Por e$emplo < G/ / 5> , ,>/ > >5/7> ;>75 ;/5 /5 , , ,/ /, ;>75 ,75@75. S/7 G/ 7 0;75 0/0;?/5 , ;G>5/5 55. V/ / 5> , ,>/ > >;;>-5 / ;@/ /50 ;75>;/ 7/ >@;5>/ , 7/G/ 0;7 5 >/>;/ > / 5 /7 G;G / 0;7.
De*inir propriedade de *orul!rios/ relat"rios e controles8 V/ / 5> ,>/5 > ;7;> ,;/>; 5 >/>;5 />,0K>;/5< >0>;/5 /7>/05. Por e$emplo< G/ / 5> , ,>/ > /0> , />,0K>;/ 7/ G/ 73/ >;5/ G-0/ 7 0< ,5 ;7 >;5 5> /5 /5 / />,0K>;/.
Autoatiar trans*er9ncias de dados V/ / 5> , ,>/ > ;,/>> H/>> /5 /,;,7 7> ;>75 />,/5 >;G/. S G/ H/> /5 G75 7/ ;70 5,7 > , 07;0 MS-EH0. Por e$emplo< G/ / /,;?> > , , ,>/ ?> ;55/ /, / 0; , =/3/.
Criar o seu pr"prio abiente de trabal3o personaliado V/ / 5> , ,>/ > =>;> /,;,7 , @>/ /7505< />,0K>;/5 >0>;/5 7/ G/ => , =7/ /5. U57/ ,>/5< G/ / /,=;7> >5 ;7;G;;5 , =7/ /5 , , 0;;G/ =7/ /5 ;7>;G/ , >/@>, H , > / , /77/ >5 5;5 ;5 /,/ 7/7>> ;7/>,J5 G75 / >5.
Criando ua Macro $ara criar ua acro 1. N 70 =7/ /5< 0; 7/ =/3/ \,>/] / 5/0 ,>/5 7/ ,7 H;=;> 2. E5/0 / =/3/ 7/G/ 7 70 =7/ /5 / 5/0 7/G/ 7/ ,7 >;G/ 73/ 5/0 M>/5
A anela Macro V/ 5 > 5>;/> 70 ,>/ > ;;/7> J5. V/ / ;70;> , /,7K>;/ > H0;> 5 >?J5 /> >K5 3/ O MS-A55 ;@7/> /,7K>;/5 7/ H , ,>/. V/ 5 > ;7>;/> 70 ,>/ > 5;;> argumentos > , 3/. O5 >@,7/5 3/ / MS-A55 ;7/>,J5 ;;/7;5 5/=> /,/ H> , 3/< 0 /,/ 0 /=/ / /5 ;0;?>.
Adicionando aç0es a ua Macro EH;5, 5 ,7;>5 ;;/7> J5 , ,>/. V/ / 50;/7> J5 >;> 0;5 J5 70 M>/ /< > J5 /,75 55/;5 /=/5 5 =7/ /5< G/ / >>5> / /=/ 70 B7/ D/5 > 00 3/ 7 70 M>/. E55 ,// >>5>--5/0> ;;/7 3/ >@,7/5 >/>;/5.
*/* *,+#+$%*/ '* *67$ * '* *#/$ 1. N 70 M>/< 0; 7 >;,;> 00 G?; /07 A3/. 2. S0;/7 3/ 5 >;> 0;5 J5 0; 7 5 > G> 5 0;5 / ;@; 3/ ;>,7 7 00. P/> H,0/: > / /,/> H , G;5/ 5/7/>/< 7/ G/ H> , ,>/< ;;/7 3/ AG;5/S/7/>/ ,>/.
*. I75;> , /,7K>;/ /;/705/=> 3/. 4. E5;; /5 >@,7/5 3/< 5 05 />, 755K>;/5.
*/* *,+#+$%*/ '* *67$ *//*&)*%,$ ' $@)$ ,* @*%(* *%#$ , ,*,$& 1. P/5;;/7 70 ,>/ 70 =7/ /5 ,// ,=5 ;, G;5G;5 , 5 0 > >;,7;/7> /5;;/7> >;,7 5 705< 5/0 0/ 0/ 7/ ,7 70. 2. N 70 =7/ /5< 0; 7/ =/3/ > / >;/ /=/ 5 >>5>. P/> H,0/< 0; 7/ =/3/ \/>,0K>;/] > >>5> , />,0K>;/. *. A>>5 / /=/ >;> 70 =7/ /5 > , 0;7 3/ 7 70 ,>/. ·
·
S G/ >>5> , =0< /750< />,0K>;/< >0>;/ / ,0/ > 70 M>/< / MS-A55 ;;/7 , 3/ => =0< /750< />,0K>;/ / >0>;/. S G/ >>5> , ,>/ > 70 M>/< / MS-A55 ;;/7 , 3/ H ,>/.
De*inindo ar#uentos A ,;/>; 5 J5 , >@,7/5 3/ / MS-A55 ;7/>,J5 ;;/7;5 5/=> /,/ H> 3/< ;5 /,/ 0 /=/ / /5 ;0;?>. P/> H,0/< 3/ A=>;>U,T=0 , , >@,7/ N/, T=0 ;7/>, / MS-A55 0 =0 / =7/ /5 =>;>. D/;5 ;;/7> , 3/< G/ ;7 /5 >@,7/5 > 3/ 7 > =;H/ 70 M>/. P> ;7;> , >@,7/< G/ / ;@;> , G0/> 7 ;H >@,7/5 / , ,;/5 5/5 G/ / 50;/7> / >@,7/ >/>;/ , 0;5. M;5 J5 , , >@,7/5 / 7/, , /=/ =7/ /5. V/ / 5> , 7; 5;,;0> \>>5> 0>@>] > ;7;> 55 />/5 >@,7/5: G/ >>5 / /=/ > > ;7>;/> 70 M>/ / 0>@ 7/ >@,7/ 5 ;7;>. P/> H,0/< 5/7 G/ ;;/7 3/ A=>;>U,T=0 , ,>/ ;75>;7/ 3/ 7 0;7 3/. P> ;7;> / >@,7/ N/, T=0 3/< G/ 7/ / 50;/7> =0 5 0;5 / >@,7/ N/, T=0< /,/ G/ K / >>5> =0 70 B7/ D/5 > / >@,7/ N/, T=0.
Sal+ando ua Macro G/ G 50G> , ,>/ 75 HK-0. Q7/ G/ 50G , ,>/< 0 5 />7 , /=/ =7/ /5 G/ / =>;> / H> >;> 70 B7/ D/5.
Criando u #rupo de acro V/ 5 G?5 / > /7G7;7 @>> 0@,5 ,>/5 >0;/75 , , 70 M>/. P> @>> ,>/5< G/ >; , @>/ ,>/5. U, @>/ ,>/ , /77/ , / ,;5 ,>/5 >, 7 ,5, 70 M>/. A5 >>;5 ,>/5 ;7;G;;5 53/ H5 ;7775 ,5 5 />5. P/> H,0/< 5/7 G/ 7 5;5 =/J5 /,7/ , , />,0K>;/< , =>;7/ , />,0K>;/ ;>7. E, G? > 5;5 ,>/5 5>5 , 5 =7/ /5< , > =/3/< G/ / >;> , @>/ ,>/ /77 , ,>/ > =/3/. D5 />,< G/ , /5 5 ,>/5 >0;/75 / />,0K>;/ 75 , , /7G7;7 /,7/. E, G? =>>/> 0;5 ,>/5 70 =7/ /5 /, ,;5 5;5 ,>/5< G/ ;;/7 5/,7 ,.
*/* #/+*/ ' ;/'5$ , *#/$ 1. C>; , ,>/ 7 70 B7/ D/5< 0; 7/ =/3/ \M>/] < 73/< 5/0 / =/3/ \N/G/]. 2. N 70 M>/< 5/0 N$ ,* M*#/$ 7/ ,7 E++/ / 0; 7/ =/3/ \N/, M>/] 7 =>> >>,75. O MS-A55 H;= /07 N/, M>/ 7 > 5>;/> 70 M>/. *. D;@; , 7/, ,>/ > /77/ J5 /,J, , ,>/.
'sando condiç0es e acros E, 0@75 5/5< G/ / >> H> , 3/ / , 5>; J5 , , ,>/ 5/,7 5 , >,;7 /7;3/ /> G>;>. P/> H,0/< 5 G/ 5K 57/ , ,>/ > G0;> /5 , , />,0K>;/< G/ / >> H;=;> , ,75@, , >5/5 , /77/ G0/>5 ;75>;/5 , , >@;5>/ , /> ,75@, , >5/5 , /77/ ;>7 G0/>5. E, 5/5 /,/ 555< G/ / 5> /7;J5 > /7>/0> / 0H/ ,>/. U, /7;3/ , H>553/ 0@;. A ,>/ 5@ ,;7/5 ;>75 5 /7;3/ /> G>;> / 05. A =0 5@;7 ,/5> H,0/5 /7;J5 ,>/5.
C$%,+67$ F/>,0K>;/5`E575`Ia21
R&'()*,$ S / G0/> 7/ /7>/0 I / F/>,0K>;/ E575 /> ,;/> 21< 73/... C;W\P>;5] S / G0/> 7/ /7>/0 C; / />,0K>;/ / 0 ,>/ /; H /> P>;5< 73/... F/>,0K>;/5`C0;75`P5 W \USA] E S / G0/> 7/ /7>/0 P5 / />,0K>;/ F/>,0K>;/5`C0;75`C;@/ / C0;7 C0;75 /> USA / G0/> / /7>/0 b*1 C;@/ / C0;7 / />,0K>;/ C0;75 /> ,7/> *1< 73/... V/ ;75> /7;J5 7 /07 C/7;3/ 7 70 M>/. S , /7;3/ /> G>;>< / MS-A55 H 3/ 70 0;7. V/ / ?> /, / MSA55 H , 5>; J5 5 /7;3/ /> G>;> ;@;7/ 0;55 ... 7 /07 C/7;J5 5 J5 5@, ;,;,7 /7;3/.
*/* *,+#+$%*/ '* #$%,+67$ * '* *#/$ 1. N 70 M>/< 5/0 C$%,+67$ 7/ ,7 E++/ / 0; 7/ =/3/ \C/7;3/] 7 =>> >>,75. O MS-A55 H;= /07 C/7;3/ 7 70 ,>/. 2. N /07 C/7;3/< ;75;> , H>553/ /7;;/70 7 0;7 /7 G/ 5 ;7;> /7;3/. *. N /07 A3/< ;75;> 3/ G/ 5 / MS-A55 H 7/ /7;3/ /> G>;>.
S G/ ;5> / MS-A55 H ,;5 , 3/< ;;/7 5 J5 ;@; 0;55 ... 7 /07 C/7;3/ / 0/ 3/ G/ ;> H> 5 /7;3/ /> G>;>< /,/ ,/5>/ 7 5@;7 ;05>3/.
Q7/ G/ H ,>/< / MS-A55 G0; H>553/ 7 /07 C/7;3/. S H>553/ /> 05< / MS-A55 ;@7/> 3/ ,/G > >H;, 0;7 3/ 73/ 7 0;55. S H>553/ /> G>;>< / MS-A55 H 3/ / 0/ H>553/ /5 5 J5 5@;75 7, 0;55 7 /07 C/7;3/. S / MS-A55 ;7@;> , 00 G?; 7 /07 C/7;3/< 0 H>K 3/ 0 /07 5, 5 >/> /, H>553/ /7;;/70. S / MS-A55 ;7@;> , /> H>553/ /7;;/70< 0 G0;>K 7/G H>553/ > >,;7> 5 H / 73/ 3/ 0/.
)ista de aç0es de Macro C*);$/+* D/+67$ D/5 , />,0K>;/5 R5>;7@;> /5 >0>;/5 M/G> >G5 /5 /5
EH3/
EH> , /,7/
A67$ A0;>F;0>/ E7/7>>P>H;,< E7/7>>R@;5>/< I>P>C/7>/0< I>P>PK@;7< I>P>R@;5>/ EH>I,D/M7
EH> , M>/< A=>;>C/750< >/;,7/ / /750 EH>C;@/< EH>M>/< EH>SQL EH> , />/ 0;;G/ EH>A0;;G/ P>> H3/ C70>EG7/< S;>< P>> M>/< P>>T/5M>/5 I,/>>$EH/>>
T>75>;> /5 7> / MS- T>75>;>B7/DD/5< A55 />/5 />,/5 T>75>;>P07;0< /5 T>75>;>TH/ E7G;> /=/5 / MS- S;>P>< E7G;>O=/ A55 > />/ 0;;G/5
C*);$/+* M7;03/ /=/5
D/+67$ A67$ D;7;> / G0/> , D;7;>V0/> ,/< /7>/0 / >/>; R57>O=/< A0;?> /5 / 0 R;>A/750< EH;=;>T//5R@;5>/5 S0;/7>O=/ S0;/7> , =7/ /5 C/;>O=/< R7/,> C/;> / R7/,> , /=/ EH0;>O=/ EH0;> , /=/
F>< A=>;>F/>,0K>;/< A=>;> / > , /=/ A=>;>M0/< A=>;>C/750< =7/ /5 A=>;>R0>;/< A=>;>U,T=0 A=>;>F/>,0K>;/< I,>;,;> , /=/ =7/ A=>;>C/750< /5 A=>;>R0>;/< I,>;,;>
M;50c7
MH;,;?>< M;7;,;?>< M/G> / >;,75;/7> M/G>D;,75;/7>< , 70 R5>> EH;=;> ;7/>,J5 7 0 E/< A,0< C;HDM75@,< D;7;>AG;5/5 EH;=;> / /0> =>> EH;=;>B>>DF>>,75 >>,75 '>> 05
>55;/7,7/
E7G;S7;DC>> 5
S/> , G;5/ AG;5/S/7/>/ C>;> , =>> ,7 >5/70;?/ > , A;;/7>M7 />,0K>;/ / >0>;/
Respondendo a e+entos e *orul!rios Q7/ G/ 5 , />,0K>;/< / MS-A55 >/7 >/5 /7;,7/5 7/ />,0K>;/ /,/ e/entos" P/> H,0/< ,/G> , >@;5>/ > />/ , />,0K>;/5 , G7/ =, /,/ 0;> 5 G?5 , , /7>/0. V/ / 5> , ,>/ > >5/7> , G7/.
Faendo Forul!rios trabal3are e con2unto S G/ , , />,0K>;/ /, , 5=-/>,0K>;/ , 5 =7/ /5< 73/ G/ K G; , ,7;> / MS-A55 />7> /55G0 ;>75 />,0K>;/5 >=0>, 7/5. U, 5=-/>,0K>;/ 7 >0; , />,0K>;/ 5>/ ;75>;/ , , />,0K>;/ >;7;0. N ,;/>; /5 5/5< G/ 5 5=-/>,0K>;/5 > ,/5>> >@;5>/5 >0;/7/5 , >@;5>/ / />,0K>;/ >;7;0. P/> H,0/< , 5=-/>,0K>;/ />; /7> , 0;5 /5 5 >5 ;7@>75 , >// ,7>/ / />,0K>;/ >;7;0 />; /7> ;7/>,J5 5/=> / >>;/ >//. Q7/ G/ ,/G55 > , 7/G/ >@;5>/ 7/ />,0K>;/ >;7;0< / 5=/>,0K>;/ 55>; ,/5>> /5 >@;5>/5 >0;/7/5 / / />,0K>;/ >;7;0. U57/ ,>/5< G/ / ,/5>> >@;5>/5 >0;/7/5 /> />,. V/ / ,/5>> >@;5>/5 >0;/7/5 , /;5 />,0K>;/5 / ,5,/ ,/< , , 5 >>; 70. I55/ K G/ /7G7;7; ;;/70 /> >;,75;/7>< ,/G> > 0> /5 />,0K>;/5 ;7775 , / />/. EH;=;> /5 >0;/7/5 73/ Y7; ,7;> 5> ,>/5 > ?> 55 />,0K>;/ >=0>, 7/5. V/ / >5/7> , G7/ //>>;/ , , />,0K>;/ ?7/ /, 0@/ //>> , />/ />,0K>;/. P/> H,0/< /-5 =>;> , />,0K>;/< >;,75;/7K-0/ / ,/G-0/< H;=;> / /0> /7>/05 0;?> /5< 7> />5 /;55. É /55G0 ,=, =>;> , ;H ;K0/@/ >5/70;? > /0> 5 ;7/>,J5 755K>;5 > /,0> , >. P/> H,0/< G/ />; 5> , ;H ;K0/@/ > >@7> 0 /5 GK>;/5 >0>;/5 ;K>;/5 ;,>;,;>.
O&/*67$: V/ / 5> 5> 3/ R;>AC/750 , , ,>/ > >;> /750 />;@, , />,0K>;/< 5=-/>,0K>;/ / /7>/0. I55/ @>7 /5 >@;5>/5 ,;5 >75 5, H;=;/5.
Atribuindo acros de +alidação a e+entos de *orul!rio e de controle P> 5> , ,>/ > G0;3/ /5< G/ >;=; ,>/ >/>; G7/ >/>; / />,0K>;/ / /7>/0. A5 >/>;5 ,;5 /,,7 55 , G0;3/ /5 53/ A75DA0;?> A/EH0;>.
A%)&DA)'*(+<*/: S V/ 5;; , ,>/ /,/ ;7;3/ >/>; %ormulário A75DA0;?>< ,>/ H 7/ / /7>/0 , , >@;5>/ 7 5;/ 0>/ G; > , /7>/0 , , >@;5>/ ;>7< ,5 75 / MS-A55 50G> 5 0>J5 7 0. I55/ /5, 5> 5/ 7/ G0;3/ 7G/0G G0/>5 , ,;5 , ,/ / />,0K>;/. S G/ 5;; , ,>/ /,/ ;7;3/ >/>; /7>/0 A75DA0;?>< ,>/ H 7/ / // ;H , /7>/0 / G0/> 7 5;/ 0>/< ,5 75 / MS-A55 ;> 0>3/. U, H,0/ 7/ G0;3/ , , /7>/0 >> ,;5 , /7;3/. O5 G7/5 A75DA0;?> 7/ /7>/05 /,/ />,0K>;/5 ,=, //>>, 5 G/ 5/0> / /,7/ S*(*/ R;+&)/$ / ,7 A/'+$ 7/ / // 5;G> , , >@;5>/ 7 5;/ 0>/.
A$E#('+/ : S G/ 5;; , ,>/ /,/ ;7;3/ >/>; />,0K>;/ A/EH0;>< ,>/ H 75 / MS-A55 H0;> , >@;5>/ , =0. I55/ /5, 5> 5/ 7/ , G>;;3/ ;7@>; >>7;0< /,/ > 5 >;;> , 0;7 73/ 7 ;/5 =>/5< 75 H0;> / >@;5>/ / 0;7. E,=/> / MS-A55 7 , /3/ R/>> I7@>; R>7;0 ;7/>/>< G/ / 73/ >> ;/7> 55 /3/ , //5 5 /5;J5. E, ;5 5/5< G/ / 5> , ,>/ 5;; /,/ ;7;3/ >/>; A/EH0;> /=> >50/5 5;,;0>5 É /55G0 ;7;> >@>5 G0;3/ 57/ ,>/5 / ;7;> >/>; R@>DV0;3/ > /7>/05 5 >/>;5 R@>DV0;3/ > ,/5 >@;5>/5. E55 53/ G0;5 7 5@;7 />, 7/ G/ 0> /5 /5 , , /7>/0 , />,0K>;/ < 73/< ,/G > />/ >@;5>/5
A *#/$ A%)&DA)'*(+<*/ ,$ #$%)/$( A *#/$ A%)&DA)'*(+<*/ ,$ 3$/'(/+$ A 5/&&7$ %* 5/$5/+,*, R;/*D*(+,*67$ ,$ #$%)/$( A 5/&&7$ %* 5/$5/+,*, R;/*D*(+,*67$ ,$ #*5$ , $/+; ,$ #$%)/$( +%#'(*,$ A 5/&&7$ %* 5/$5/+,*, R;/*D*(+,*67$ ,* )*(* , $/+; U, G? G/ / 5> 3/ C70>EG7/ 7 ,>/ G0;3/< /5 5> ,>/ > , G0;3/ >0;,;7> 5 G0;3/ /> =, 5;< G/ /< 73/< 55> > G0;3/ / /7>/0< >@;5>/5 / ,/.
E%ibindo ensa#ens de +alidação di*erentes para condiç0es di*erentes V,/5 ;0;?> /,/ H,0/ , ,>5 ;,/> >//5 />7/>5 0/0;?/5 , ,;/5 55 / >/> / ,7/. C/,/ 55 ;>75 , >@>5 ;>75 > 55 ;@/5 /5;5< G/ 73/ / 5;,05,7 5> , >@> G0;3/ > @>7;> , G0/> ;75>;/ 7/ /7>/0 C;@/ P/50 7 5 >>5;5 />>5. V/ /< />,< 5>G> , ,>/ G>;; 0 5 5K ;75>;/ 7/ /7>/0 P5 < 73/< G>;; 5 / G0/> ;75>;/ 7/ /7>/0 C;@/ P/50 , 5 >>5; >5 > 0 5. A ,>/ , 5 /7;J5. P> ;75>;> 5 /7;J5 7 70 M>/< 0; 7/ =/3/ \C/7;3/] 7 =>> >>,75. I55/ H;= /07 C/7;3/ 7 70 M>/. A >;,;> /7;3/ 7 ,>/ G>;; / ;@/ /50 /5 />7/>5 0/0;?/5 7 F>7< IK0; / E57. E555 55 , ;@/5 /5;5 @;/5. I75;> 5@;7 H>553/ /7;;/70: P5 E, \F>7]]IK0;]]S;7] E C/,>C;@/ P/5ba O />/> E /,> / G0/> 7/ /7>/0 P5 / />,0K>;/ 0 /, 0;5 55 7>/ /5 >755. A 73/ C$5/ /7 / 7Y,>/ >>5 7/ /7>/0 C;@/ P/50. S , 5 5;G> 7 0;5 / 7Y,>/ >>5 / ;@/ /50 73/ /> ;@0 < / MS-A55 H>K 3/ 7 ,5, 0;7 /7;3/ ;5> J5 ;,;,7 5@;> 7, >;7;5... 7 /07 C/7;3/.
A 5@;>< ;;/7 5 J5 > H> 7/ /7;3/ /> 7;: 3/ C;HDM75@, 3/ C70>EG7/. A =0 5@;7 ,/5> /5 >@,7/5 G > 3/ C;HDM5@,.
A/;'%)$ M75@, T;/ T0/
D3+%+67$ D/+67$ O ;@/ P/50 >;5 5> A ,75@, H;=;> 7 >>5. ;H ,75@, I7/>,3/ O ;/ /7 H;=;> /, ,75@, E>>/ C;@/ P/50 O 0/ > 7/ // ;H ,75@,
A 5@7 /7;3/ 7 ,>/ 5 / ,5,/ ;/ H>553/ >;,;>< H/ G>;; / ;@/ /50 / />7/>5 0/0;?/5 7 A5>K0; S;7@>. E555 55 , ;@/5 /5;5 4 @;/5. I75;> 5@;7 H>553/ /7;;/70: P5E,\A5>0;]S;7@>]E C/,>C;@/ P/50ba4 A;;/7 5 ,5,5 5 J5 5>, H5 7/ /7;3/ /> 5;5; ,5< 0> / >@,7/ M75@, 3/ C;HDM75@, > 5 0;: \O C;@/ P/50 >;5 5> 4 >>5]. F;70,7< ;;/7 , 3/ I>P>C/7>/0 ,/G / // > /7>/0 C;@/ P/50< ;0;7/ />>3/ / >>/. S0G ,>/ / 7/, V>;;> C;@/5 P/5;5.
F;70,7< ;7 >/>; A75DA0;?> / />,0K>;/ > V>;;> C;@/5 P/5;5< / 7/, 5 ,>/. V/ 5 >/>; / />,0K>;/ , G? >/>; / /7>/0 /> 5 G0;3/ 7G/0G /;5 /7>/05 ;>75 7/ />,0K>;/. A@/> 7/ G/ 5> / />,0K>;/ > ;;/7> , 7/G/ />7/>< / MSA55 H>K 5 ,>/ G0;3/ /;5 G/ >,;7> ;75>;> / 7/G/ >@;5>/< ,5 75 50GK-0/ 7 =0 F/>7/>5. S 0@, /7;3/ 7 ,>/ /> 5;5;< / MS-A55 H;=;>K ,75@, >/>; 73/ 50G>K / >@;5>/ 7 =0 F/>7/>5. E, G? ;55/< / // /7;7>K 7/ >@;5>/ > G/ /55 />>;@;> /5 /5 ;7GK0;/5.
Criando nossos pr"prios enus P> >;> , ,7 >5/70;?/ ,/5 ;0;?> 0/ ,7/5 5 ,>/5< , > ;7;> / ,7 /> > ;;/7> / ,7.
De*inição do Menu · · ·
·
C>; , M>/ 7/G A;;/7 /07 7/,5 ,>/ N /07 7/, ;@; / 7/, / ,7< 5 5> , 0> ; 5=0;7 > 5> 0 55/< 75 0> /0/ / 5,=/0/ N /07 3/< /0/ / G/ 5 ,>/ .
V / H,0/: N/, dA=>;> dF> dS;>
A3/ A=>;>U,T=0 F> S;>
D5>;3/ A=> =0 C0;75 F / /=/ ;G/ A;;/7 , 5>/> / ,7 S; / A55
Q7/ >,;7>< 50G ,>/ /, / 7/, MENU e< /7 =>> ,7 5 ,7 >7< / 7/, / ,7. V,/5 / H,0/: %enu Principal0Ar*ui/o
De*inição da ;arra de Menu · · · ·
C>; , 7/G ,>/ A;;/7 /07 7/, ,>/ N /07 A3/< 5/0 3/ A;;/7>M7 N/5 >@,7/5 ,>/< /0/ / 7/, / M7 ;>K >> 7 0< G0 ,=, >@> / d< / 7/, ,>/ 5>K ;G 7/ 5 ,7 /> 50;/7/.
S0G ,>/ /, / 7/, B>> ,7 G/ 5 >;>.
Atribuindo ua ;arra de Menu a u *orul!rio E5/0 / />,0K>;/ G/ 5 /0/> =>> ,75< 7 P>/>; B>> M7< 5/0 / 7/, ,>/ >>57 5 =>> ,75. M > / ,// />,0K>;/ G /,/ ;/ / ,7.
M"dulos P> , ,;/> 0H;=;0; 7 ,7;03/ /5 55 /5< /; ;,0,7 7/ A55 , 0;7@@, >/@>,3/ , A55 B5;< , ;0/ / V;50 B5;< >,; , K> > >;3/ >/;75 G3/ /,0,7> / 5 =7/ /5.
Estrutura do M"dulo Sub - S=F73/< , 5_7; /,7/5 H 0>J5
, />,0K>;/5< =05 / 0> />/ /=/ / MS-A55. M5 73/ >/>7/ 77, G0/> > , ,/ 5 Sub. &unction - F? H,7 ,5, /;5 S=< ,5 ,
/=>;@/>;,7 >/>7> , G0/> > ,/.
Declarando .ari!+eis EH;5, /;5 ;/5 0>J5 G>;KG;5< , 7G0 M0/< G;5G0 , /5 5 S=5 F7;/75 / M0/ 5 53/ G;5G;5 75 , 7, 73/ / 7, 5=73/. D0>3/ '0/=0 - É U;0;? 7/ 7G0 ,0/ > 0>> G>;KG;5 @0/=;5 G>;KG;5 ;5/7G;5 , //5 /5 >/;,7/5 , //5 /5 ,0/5 0/> 5/ >,?7,7/. D0>3/ D;, - U;0;? 7/ 7G0 ,0/ 7/ 7G0 >/;,7/ > 0>> 5 G>;KG;5 0/> 5/ >,?7,7/. Q7/ ;0;? 7G0 ,0/< 5 G>;KG;5 0>5 53/ G;5G;5 //5 /5 >/;,7/5 /7;/5 7/ ,/0/. S 0>5 7>/ >/;,7/5< 55 5 5>3/ G;5G;5 7/ >/;,7/ /7 />, 0>5.
Tipos de Dados A 5@;7 =0 ,/5> /5 ;/5 /5 7,7;5 5/>/5 0/ A55 B5;< 5;H/ 0>3/ ;/< ,7/ /5 G0/>5 ;KG;5. T;/ D/5
S;H/
I7@> L/7@;7;>/ 0/7@/ S;7@0/7/ 07 >;53/ 5;,05 D/=0 /7/ 07 >;53/ 0
[ d `
C>>7;7;>/ ;,75;/7/ S>;7@
g
V>;7
N7 ,
f
h
T,7/ /5 /5 2 4 4
V0/>5 ;KG;5
-*2.&68 *2.&6&. -2.14&.48*.648 2.14&.48*.64&. -*<4!282*E*8 -1<4!1298E-4 > G0/>5 7@;G/5 1<4!1298E-4 *<4!282*E*8 > G0/>5 /5;;G/5 !. 8 -1<&9&69*1*4862*2 E*!8 -4<94!66484124& E-*24 > G0/>5 7@;G/5 4<94!66484124& E-*24 1<&9&69*1*4862*2 E*!8 > G0/>5 /5;;G/5 !. 8 -922.**&.2!*.68.4&&<8!8 922.**&.2!*.68.4&&<8!&. 1 = /> ! >/H;,,7 6.* =5. DG>> 5 ;H> , ,>@, > / >,?7,7/. C/7/>, Q0> G0/> 7,>;/ / ;7>G0/ >/>;/ , ;/ /5 D/=0 / 0> H/ >>.
V,/5 , H,0/ /,/ / ,/0/ 5>>/:
D5>;3/ /5 ;75 ;0;?/5 7 K@;7 7>;/>: D0> , 73/< , =0// /,7/5 / 5 >,;7/ >/>7 , G0/>< 75 H,0/< >/>7/ , 5_7; >>5 N/, 73/< 5 7/, / 5> ;7;/ 0/ 5K>;/ %ai1sculas 2c3e$to As String4 TH/ / 7/, , G>;KG0 55 > 5 73/ As String ;7;; / ;/ / 5 G>;KG0 /7,. I7/>, / ;/ / >/>7/ 0 73/ As String D0> , / ,;5 G>;KG;5 Dim V; T;/5 D/5 String F73/ >3/ / A55 B5;< />7 //5 /5 >>5 55/5 5case624 0 , >>5 M;Y50/5 &unction
P> >/>7>,/5 , G0/> 0> 73/ ;7; 0/ 5K>;/< G,/5 >;=;> / G0/> >/>7/ 73/< /,/ G,/5 7 7Y0;, 0;7 5 ,/0/.
'sando dados contidos nos Forul!rios A /03/ &orms /7, //5 /5 /=/5 F/>,0K>;/5 =>/5 , , =7/ /5 / M;>/5/ A55. U5 /03/ F/>,5 7/ A55 B5; / , H>553/ > 5 >>;> , />,0K>;/ , >;0>. P/> H,0/< G/ / 5> /03/ F/>,5 > G>;;> / ;7;> / G0/> , /7>/0 />,0K>;/. O /=/ F/>,0K>;/ /7, /5 5 >/>;5 /0 >/>;5 , />,0K>;/. V/ / 5 >>;> , />,0K>;/ 5 5@;75 ,7;>5:
F$/&`MF/>,0K>;/ F$/&XMF/>,0K>;/X NomeEmp=Forms![Empregados]![Sobrenome] & "," & Forms![Empregados]![Primeiro nome]
N/ H,0/ ;,< G>;KG0 N/,E, >= / /7Y/ / /7>/0 S$/%$ ,;5 / /7Y/ / /7>/0 /++/$ %$< ,=/5 /7;/5 7/ />,0K>;/ E5/;*,$&. P/,/5 ;0;?> /03/ />,5 > 5> /7;J5 , , ,>/< 75 5/< 7/ G/ >55;/7> 0 E7> >,;77/ /7;3/< 0G> F/>,5< 5>K 5=5; 0 0G> F/>,0K>;/< 73/ ;,0;7/ , 77, ;/ >>/. C/7;3/
A3/
D5>;3/
F/>,5`P>//5`D5/7;7/WSIM C;HDM75@ S 73/ ;G> ,;5 >//5 , H;= , ,75@, >>/
5b2etos de ;anco de Dados O A55 /55; GK>;/5 /=/5 /0J5 /=/5 > >,7/ =7/ /5< G,/5 ;5;-0/5 , ,. O=/ DBE7@;7
D5>;3/ O DBE7@;7 >>57 / 5;5, >>3/ >,?7,7/ /5 / A55< 0 , /7>/0 5/=> //5 /5 />/5 /=/5 $/S5*# U, /=/ />Z5 ;7 , 5553/ > , 5K>;/. C/7, =7/5 /5 =>/5 >/G, ,7;5,/5 > >75J5 5;,0c75 > , @>/ >=0/ 5@>/. D*)**& B7/ D/5 , 5;< , >;G/ MDB< /, 55 =05< /7505 ... T*(D3 C/7, //5 /5 ;75 , =0< ,/5 7;5. C/7, 5 ;7;J5 > , ,/ F+(, C/7, 5 ;7;J5 > , 7;< ,/< Y7;/ ... I%, '/D3 D;7;J5 , /750< 0> ;/ R#$/,S) C/77/ >@;5>/5 , =0 O /=/ R0;/7 >>57 , >0;/7,7/ 7> 5 =05 R(*)+$% T//5 /5 ;75 , %;/+)$ >>57, , /03/ /=/5< ;>7 /03/ 7/ 0>0 / /=/ , / 7/, 7/ 5;7@0>. P> 5=>,/5 / 7/, /5 ,/5 , =0< G,/5 ;0;?> /03/ 3+(,&. P>/55/ > >=0> /, / =7/ /5 0: 01
Function Exemplo
02 03
Di db As Database Di I As Inte#er
iD;7 , G>;KG0 / ;/ D=5 iD;7 , G>;KG0 / ;/ ;7;>/
05
Set db W D;En#ine!!
i A>;=; / B7/ /5 0 =
06 0
For I W ! to db.TableDe*s.Count -1 i /7 Y0;, =0 Debu#.$rint db.TableDe*sI.Nae iI,>;, / 7/,
0
Ne%t
0
db.Close
=0
10
End Function
N/ H,0/ K@;7 7>;/>< , G>;KG0 / ;/ D=5 0> !2< 7 0;7 ! >;= 0 / =7/ /5 0. N5 0;75 5@;75 ;/ , 0/ /77/ /5 5 =05 H;5, 7/ =7/ /5 0 !6< 7 0;7 !& ;0;?/ / /=/ D=@ > ;,>;,;> 7 %70 I,;< / 7/, =0 0 /7 0 /03/ T=0D5< T=0D5 , G/> /77/ /5 5 =05 / =7/ /5< 0;7 !8 / 0/ !9 / =7/ /5 =. EH>;,7 >;> , ,0/ 7/G/ ;@; 73/ ;,< 7/ >,;7>< 5/0 7/ ,7 H> /3/ C/,;0> ,0/5 >>@/5 > G>;;> 5 73/ H;5 77, >>/ ;@;3/. S 73/ /G> >>/< /5;;/7 / >5/> 7 >;,;> 0;7 ;@/ 5 0>3/ F7;/7 >55;/7 F9 > @>> , /7/ >. M;7;,;? 70. N 70 B7/ /5 50;/7 / /=/ M>/< >; , 7/G ,>/ > H> 7/55 73/. EH-. Q7/ / A55 ;7@;> / /7/ >< 70 ;@/ 5>K H;=; > /55,/5 H> 73/ 55/--55/ >55;/77/ 0 F8. N/ ,7 EH;=;> 5/0 /3/ %70 ;,; > />,/5 G> 5 7/55 73/.
.alidação de capos co "dulos P> ,/ 7, />,0K>;/< /,/5 ?> G0;J5< ;0;?/ / G7/ A75DA0;?>< /,/5 ?> G0;J5 > /5 ,/5. V / H,0/ / > / G7/ A75DA0;?> > / ,/ N/, / C/7/:
Sub N/,e/e/7/eB/>U Cancel A5 I7@> Const MBeSTOPeBUTTON W 16 I* I5N00[Nome do Contato] 5r I5E,?[Nome do Contato] T3en Ms#;o% XE5 ,/ 73/ / ;> G?;/X< MBeSTOPeBUTTON< XV0;3/ C,/X Cancel W True End I* End Sub N/ H,0/ ;, G>;;/ 5 / ,/ N/, / C/7/ 70/ / 5K , =>7/< 5 0 /> , /5 /;5< ;H ,75@, 5>K H;=; /, / 5,=/0/ > >;.