assignment access mohammad nazrul hadi bin mohamad amran

Upload: md-nzrul-hadi

Post on 06-Jul-2018

220 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    1/10

    IKM LUMUT-SKN-1A-IT

    Assignment

    Access MOHAMMAD NAZRUL HADI BIN MOHAMAD AMRAN

    5/5/2016

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    2/10

    1.  How to create aTable.

    First click “Blank database” and then

    name of File name and clik “Create”. 

    1

     

    2.

    3.

    4.

    Click “Design View” 

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    3/10

     

    5.

    6.

    Name the Table name and then Click

    “OK” 

    7.

    8

     

    9

     

    Fill the blank, click save and clickview.

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    4/10

     

    2.  How to create aQuery.

    10.

    11.

    Fill the blank and then click save.

    1.Click “Query Design” 

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    5/10

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    6/10

     

    3.  How to create aForm.

    1.

    Click “Form” 

    5.

    It will show like above

    Done and click save.6.

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    7/10

     

    4. 

    How to create aReports 

    2.

    Click save, Fill File Name and Click

    OK3.

    Click “Report” 

    1.

    4.

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    8/10

     

    5.  How to create aRelationship 

    Click Save

    2.

    Click “Relationship” 

    1.

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    9/10

     

    Highlight both of table and Click Add

    2.

    It will show this

  • 8/17/2019 Assignment Access Mohammad Nazrul Hadi Bin Mohamad Amran

    10/10

     

    4.

    Click Save

    3.

    Click Create