Microsoft Access Student Booklet

download Microsoft Access Student Booklet

of 74

  • date post

    23-Feb-2016
  • Category

    Documents

  • view

    217
  • download

    0

Embed Size (px)

description

Microsoft Access Student Booklet

Transcript of Microsoft Access Student Booklet

  • MMIICCooOOSSOOFFTT AACCCCEESSSS

  • MICoOSOFT ACCESS

    :

    :

    -

  • Microsoft Access

    .

    ( )

    .

  • N N

    .....................................................................6

    N

    .....................................................................10

    O N

    Access--- -......13

    O

    Access .........................................................16

    P & 4 N

    Access...................................................................19

    P

    Access ...............................22

    4

    Access ...............................23

    5 N

    Access ............................................24

    5

    Access ............................................30

    6 N

    (Validation Rule) ......................................................32

    6

    (Validation Rule) ......................................................35

    T N

    Access (AutoForm)..................................................................38

    T

    Access .....................................................................................39

    8 N

    Access ( -Form Wizard) ..................................41

    8

    Access ( -Form Wizard) ..................................45

  • 9 N

    wizard .................47

    9

    wizard .................49

    NM N

    Access.......................51

    NM

    Access.......................54

    NN N

    Access............................56

    NN

    ......................................................................................57

    NO N

    Access-2........................................60

    NO

    ......................................................................................61

    NP N

    Access (Wizard)...................................................................63

    NP

    Report Wizard..............................66

    N4

    Access-2 ..............................................................................68

    N5

    ............................................70

    N6

    ..................................72

    NT & N8 N

    - - ............73

    NT & N9

    - - ............80

    200

  • 6

    N - N

    N

    ((DatabasesDatabases))

    NN

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    O

    ((Database)Database)

    K

    KK - - - CD E

    )

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    P

    KKKKKK - K EI ) K

    KK EK I I I I KKK) K

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

  • 7

    4

    K K

    E KK I I I KKK)K

    KK

    ..

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    5

    EKK )

    EKK )

    EKK

    )

    EKK ) EKK )

    EKK

    )

    ... .

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    6

    KK

    E

    )

    E K )

    E K

    )

    KK

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

  • 8

    T

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    8

    EI I /)

    I

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    9

    P5I6MNT

    O4TOPO45

    /

    K

    ....

    K N9IK NPO6MN5

    O456NP4P

    K

    P5I6MNT

    O4TOPO45

    /

    K

    N5I6MN8

    O445PNP5

    K

    N

    O

    KKK

    P

    N O

    P

    EKK )

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

  • 9

    NM

    KKKK

    Eoecordsoecords)K

    EFieldsFields)

    EETableTable))

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    NN

    ..

    ..

    ..

    .. -, ,

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

    ___________________________________

  • 10

    N : No -

    :N/N8 :..............

    : KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK :

    : .

    . . .. ..

    o (table) o (record) o (field)

    . .

    AK .

    N: .

    ............................................................................................................................................................

    ............................................................................................................................................................

    O: . (data base) .

    3 .

    ............................................................................................................................................................

    ............................................................................................................................................................

    ............................................................................................................................................................

    BK I .K

    P: . 5 (records) :

    3200 20/03/92 1 252,20

    0042 29/12/92 1 37,70

    4826 05/07/93 0 2274,20

    2847 18/09/91 2 279,60

    8927 04/11/93 1 152,30

  • 11

    (record) :

    ( 1000 6000 )

    To (0 , 1 )

    ( 1 1000 )

    (fields) (record); ...........................................................................................................................................................

    . ; ...........................................................................................................................................................

    ...........................................................................................................................................................

    4: (table) .

    (records) (table);

    ........................................................................................................................................................... (fields) ;

    ...........................................................................................................................................................

    ...................................................................................................................................................