Manual Access 2003 - Exercicios

! (

" #$

#

%&

%'

%(

)

)

%

%

!

%

%

* !

) )

!"# &"

%

'

'

* +

,

$ #

-

+

% "

,

+ )

"

)

"

#

, $/ $ & '0 2 3 4 $/

!"

(

)

'

' 1

' '

$/

'

4 5

)

3'

(

* 6

"

#

,

)

$/

!"

(

'

" !

" 2 3 7

8 '

,.

&

4 (

* 6

5 )

"

: "#.

" #

9

# /

&

0 )

" "

1

,

#

!"

" "

2

(

)

'

$ < $ < & '

=1

2 3 4 ; ; " # 1

) ,

!

%

"

#

!

!"

" "

(

)

' <

' 3 3

>

< 5 6

2

3

!"

!

)

#

"#

!

;; >> '' << "" 44

;

3

"4

" " ( 5 ' @ 0

* '

!

5

"#

)" A

!

%

6 " $

"

#

/

!"

" "

,

(

)

$ ; 1 B & 4 'B @ 0

' $ $ $ $ $ $

1 1 1 1 1

# 3 "

)

"

7 C

# #$ $.

"#.

C C C C C

#

C C C C C

7

C

#"

5

" ?

#

8"

"

!

,

"#.

8"

1 ; 1 1 ; 3

"/ &

#

!" '

%

#

9

%

*

4 %

3

% E + %

< ( 3

%

#

%

%

% %

,E

E

%

F

'

E

1

F

'

%

G

%

E ( %

%

: $

' ,%

"#.

4

+

#

: !"

4< 4' 4< : $ )

# * #

9

9

#

#4

#

3 & <

& " ; #

' / &#

/

/

"

. #4 /

/

!" H

#

" !" *

&

= "# , 5

#

H

5

H

,

# ,

#" 5

H ! ,

)

/

"#

8"

"/ #

5

&

D

9

"!

# #

#

* # > !" " . ) #" : " . * # >

(

* # >

: .&

!"

/

# : 8" %

, ! $ ( # 5 #*

? % 8"

&

9

* # > E

%

8"

#

"

%

%

0

% %

.

%

; 3 < ( 3

%

+

#

-

%

F

'

0

% E

,E

E

1

F

'

%

G

%

E ( %

%

' ,%

4

+ :

I

#

@ )

"

)

"

, $

"

#

!"

1(

2

(

) -

' ;

"

3

$

3

(

$

2

3

7

' ; ; 7 "

)

K # $

"

%

0

?6CL

CCCL

% +

,

" "

!

%

"

#

%

!"

" "

(

)

,

1(

#' 2 '

"

3

;

3 <

"

J

#

&

!" $

#' ;

(

>

1

'

'

< "

<

# +A

8" / # 1

"4

!

8"

#'

,

. 3

#' 8"

# 1 C

2/ &

!"

A

3

#

<

# >

D

??6L

;

;

<

4

"

$

.C

'

M

J

;

&

D

'

; 0

J

>

? CL

<

-

..

>

D 6L

"

;

9D

>

1

.I

>

N

?

)< )3 )?

DCCL

;

!"

) ' ;

N

CCCL

O

J6CL

) ; '

#

P P 3

ICC

?CCL O

JD6L

N

CCCL

"

"# #

'

& 2

"# )

A B

' 1

# 2 > C

P4 *

Q

R C

.C

)?

P4 *

) )

)

!

!" "# ) " )

<

#

P 4 *

"#

#'

*

' 1 '

/

8"

"

P 1

!

!"

D6CL CCCL

"#

) D" # )

R

2

" #4 P 1 ?CCL ) # P"

)

Q

<

#

#' F3

E H

QH

EH

SR%

QH

SR

QH

SR% )

)

E H

&

QH

"#.

"

"#

7

8"

SR%

"

&

"! #& )

) $.

9

"

$ !

& &

#

"#. "#.

/

'

/ &

B # >

!

' "#.

(

G.

& 8"

"

#" "

#! '

'

'

) & !" 8"

' B

)

C

" B* /

G

#

( "

#

8" '

H )

" "

,

#

!"

(

)

" " '

'0

3

$

>

3

3

3

3

>

$

'

T F$

#

!"






7 )> ! 7, 7( ! ' "% R Q3 ( 7 )> ! 5

!

!"

9 ! D ! %

0

# )

!"

$

;' C

U

;1CD

>

11CI

2

1'CJ

4

('?I

> $

;1CC

<

;'CI

X 7

(166

3

( V

W " & $

.

!

,

)> !

1

) !

;

$

'

.CC

$

1

.?C

1

96C

'

ICC

1

9IC

$

1

JDC

$

'

?9C

1

6C

7 )

'0

"

$

,

;

#

!"

(

)

$/

' $

$

3

&

3

<

$

<

<

F3

3

$

3

'0

>

3

!" ;' < & 7 ;

!

!"

#

9

1

,,

% .6

P 9C ,

< )

!"

$

! )> !

,

,I

?

CC

M/

CC

V

CC.

&

C C

-

C .

N

C6C

'

" '

4

>

9

4

,

2

6 69 ?I

;' C

69 ID ?

;1CD

9FC9FD

9 6 .6

11CI

CIFC F?.

C CC .C

1'CJ

CJFC6FD9

6 9I DJ

('?I

1

6FC FD9

9I DI 9

;1CC

4

.FC.FD.

9 .

>

6F

6 96 69

W

FC6F?6

4

5

F

1 '

1 @

2 ! &

5

8

( # &

A

.

F?I

FDC

;'CI (166

)

" !"

$ &

#

H

/

' )

! "

)

,"

CFCDFC

>

1'CJ

CDF CFC

-

('?I

C .

.FCJFC

;

$

;'CI

CC.

FC FC

2

$

11CI

C6C

.F CFC

2

(166

C C

9FC6FC

;

C.FC.FC

&

;1CC

CC

'

;1CD

CC

F

FC

$

;' C

;

-

!"

#

;' "

9

9

1

,-

!"

)

"#

H

*

1

!

%

) H ?

0

, +) ) ! ,

'

' 3 $/ $/

" CC +) ;"

'

% 55,

* A

, $

+)

)

%

+)

! ,

'

* > 9

)

+)

" #4 ,

)

&

"#.

" /&

)

"

&

; ; ; ; ; 4

)

"#.

#

+ $

'

"! &

/ "#.

1

P

#

/

8" / &"

9

" / "

/!

!" #'' #'& #'$ #'

'

P

4

'

4

' >

P

4

-

' "

, ) # > )

#

E

/ ) " ' ' ' 4 #

.

"

* # > # "# 8"

/

)

"# !

B) ) '

B) ) "

C

C/ &

"#

6

"

! $

/

J ' " " 4

K Y

"

4

<

Y

'

'

=1

<

$Y ' '

=1

4

=N

N )# ,I )#

K )

$ FK

&

$

'

& '

=1

3 =1

:

Z ,' '

'

Y

8

-' '

!

%

.' '

% :

'

/' "

8

0' "

1' <

* ;

2' " ?

;

3' "

0

4

#

7 Y ; 7 Y% 7 7 7 4' 1 )

F

%

#

"

!

'

1' 1

K # (N

1' [ '

( . 6

3 1

DR \-

^

V

9 &] 9CC

'

.6%CC L

^ ]1 @

&

DI%CC L

]1

&

.6I%CC L

&

.%CC L

7

I

-

1 F

'<:-V 25 6 &

0

FK 2C

F

F6

-

'C

2

)

F

#

L)

'

2

?CC 2

CZ

1

96CC 1

D%6Z

'

??D6 '

CZ

2

D6C 2

JZ

1 ;

?6%CC L DC%CC L

?

;

2C

25

I &>

M

1C

5C

-;&

,

6C%CC L ?C%CC L

^

C

25 2

D J

D6%CC L

2

N5; 5

?

)

"

&

9

6CC%CC L

5

I?CC 5

D

IZ

,

?

)

F

# ( # &

E

#

)

I

,I M1

2

1

96CC 1

2 .

M

9

;

(

6

?CC 2

5

& .

6?6?6CC J.J J

I?CC 5

J

6C66C.

.

C. C

C6

_

CCJJ

IC I6C?6

2

D6C 2

D66C6C6

'

??D6 '

6CC 6 6

'"

_

_ ._

6C 6 C .

6C??6996

#

"

)#

K

! 1' 1 3

M1

2

-

2

(N

\&

2 DR

^

V

^ ]1

@ 1

;

.

9

6

N5; 5 ^

.

M

(

;

-

7

(N

1' 1

(N

1' 1

(N

1' 1

(N

3

M

I

]1

1' 1

&

2

9 &] 9CC

DR \-

2

'<:-V 25 6

F

F6

'<:-V 25 6

F

F6

'<:-V 25 6

F

F6

&

0

-;&

I &>

&

0

-;&

I &>

&

0

-;&

I &>

,' " B -' '

0

.' "

/' "

0

0' '

0 :

1' '

G

2' '

G

3' &

8 0

,4' "

0 B

J

M ' "

%

%

# ; 7 ;

C

CC 9C CC

.C C $

"

%

!

! #

&

(

)

! '

* "

* +

" "

,' '

#

"

+

!

8

*

-' '

!

% '

.' '

8

/' '

C

0' <

* ;

;

1' 1

# )#" '

"

)#"

4' 1

IJ.

A( !

2>

9

!

JC9 '1

JC?

! #

5

9

#

>

# &

J 4'

JC.

'4 >

9

J J

,

;

1 ' & N < ' 1 & M 2 M 5

1 ' 2 ! 4 N M

)

" ; " 2 * ; ]]( < ; @

>

<

6CCCC

1

?6CCC

2

69CCC

2

66CC

> -

#

5

.CCCC

1

6CCC

2

& & % ,

)#"

',

- ,

(

7

8

7

8

'

& # #

<

= < & %

#

< ( ( #

<

?

3

# "

'

.. +.

*/0 */.

/1 /1

+3

*/+

40

+5

*43

4.

+/

*45

4+

-

&

"(

: #

# 9:

0+

9:

5

-

!

+/

*/1

40

-

!

.+

*/1

40

#

-

!

++

*/.

45

#

-

!

+.

*41

03

-

!

3/ +4 +3

*// */+

/1 40

+4

*/3

/.

:

*/

+* ++

*/. *//

/. /3

: 9:

/ +1

.+

*4+

00

:

*+2

*/1 */1

/1 43

: 9

+ 3

.. +/

'

6 &

3/

!

4/

-

5

-

*/3

)#"

?

1 2

31 +*

3/ " "

&

;

%( "(

" ' > :-

4* :

*4

9:

3*

%( "(

(: # - & "> ;: :#

* 9:

%( "(

:- & - ! < @ A# :#

(

" " - &

% ,

+/ 3/ +2

*/. */5

/+

&

.*

*/3

/*

- & -

.. +2 *2 54

*43 *44

/1 43

-

C

< ) &

'

#

B

2' '

)#" - & DD

: #

)

)

- & - !

" -

&

" -

&

"

-

!

" -

- & - !

-

!

-

!

-

(

: #

)+

-

!

"

DD 9

:

&

-

-

+0 *

-

&

) 9

9: 9:

"

DD

9 DD 9

*5

!

) ( : !: E & : !: E (

:

" -

DD

&

*

)#" + - ! "

9

:

;

!

)

& : !E

%( #

-

-

: !: E

#

)

( : !: E ( &

+0

%(

&

: %(

. *4A1/A+11. +3A1/A+11. +3A1/A+11. .*A1/A+11. .*A1/A+11. *3A12A+11. +*A12A+11. +*A12A+11. +/A12A+11. 15A*1A+11. *2A*1A+11. +0A*1A+11. *3A*+A+11. 13A1*A+113 **A1*A+113 */A1*A+113 +5A1*A+113 +5A1*A+113 1*A1+A+113 1*A1+A+113 1/A1+A+113 *5A1+A+113 *5A1+A+113 ++A1+A+113 +2A1+A+113 14A1.A+113 *3A1.A+113 */A13A+113 1+A15A+113 12A15A+113

/1

" -

&

-

!

&

&

"

0

3' ' '

0

4' '

' 0

''

2

,' ' $

# $ '

"

M

% (

% 1

0

!" # % ; % ' %

$ % 2

:-

'

-' '

.' '

G +" # 5

'

% <

,

0

/' '

C

0' ' '

G 0

1' '

0

'

%

2' '

B

6

3' ' ,4' &

8

#3 3 1

+ /

;!

0 , +" # 1

9,

.

0

N 1

:

!

%

!

' .

56 $

'

(; $

' <

3 3 7

9

(

'0 < 7

&0

8

%

# )

$ CC C C C. C9 C6 C? CD CI CJ C

6

#

(O

# ,




%

' " " 5 $ 7 7 7 1 -

'

( #

9

%

(O

# , $ $ ; & ( 3 < ' H 7





;

8

; 7 7 7 + ;




(

D

'

8

8 7: $

$

;

, 8 &' 8

(

C

$

A !

%

+

'

0

J

'

0

(

)% (;

I

C '

'0 H 7

9

%

?

$ 3 3 3 3 3 < F3 3 ' K &

B

,% #*

+* !

:

% !

,%

*7

* # + , +N %

'

6

8

"

,%

P #

# !"

9

. 1,'

#"

8"

#

#"

)

$

F("

)

$

@ =1

'

&

=

3

3

'

":

$ #

=3

+ 3

$Y

,I

8" 8"

'

=&

$

=&

$

=&

.

$

=&

9

#

;

& 3 $

= &

: @

@

$

.

8

?

=1 :

#"

$

'

F&

'

&

'

' 2

("

,I

'

&"

"

!"

8

0 3

8" 8" ' $Y ; $Y ; ' =4 ' =4

@ )

" #"

# & 4 ; 4 ' 8"

H 3

4 # $

J )

&

"#.

$

" '

3

&"

'

/

#

9

4 ' ; 4 8" 8" #

8"

" " " " " 8" # & #

" G

M 3

#! 9 ' Q #" R  $Y ; Q #" R Q #" R  $Y ; Q $ # ' R Q(" R ' =4 Q Q(" R  ' =4 Q("

!"

D

R R I

" " " " " &

#!

9

"#.

"

N 3

8" 8" #

G

$

8"

$ " #4

!"

&

P ;" &

8" 8" $ " 2

& 13

"

9

8"

"

#"

9

+,

+,

+,

" "

+, (

0

' '

0

"

0

'

5 D" # #"

!"

9

#

"

< ' ' ' '

I

#

$ &

"

# $

"

8"

&

!"

#

+

"#

" #4

4 & ;

0

" $

1) # 8"

"

2 ' ; " ; & "

@)

"

# >

# "#

J

S

H D"

9

J D"

$

' 8" 4 ( 4 7

M

8"

#

"

"

S

"

&

& & &

$

! $

S

M

$

"

1

#

>

2 : V ; V

N D"

9

8"

"

^

"#

"

< 3B ; P D"

' ; ; ; ;

+5 )

" 4 & > -

"

0

" "

.

"

% "

# % ( "

#

8

.C

%

% 0

`'

K

3

P4

'

( ;

-

3

#'

-.

/

.

<

%2