Groups

    Whats the difference between a form & a report on a database ?

    Banned
    Can't see any difference wondering what my form and report should include

    5 Comments

    Forms are normally for entering data, rather than going into the tables (which you should never really do).

    Use the reports for if you want to collate any information into different formats - you would use the reports to make reports that you would like to print off, for example.

    Original Poster Banned

    hodsey77;8140740

    Forms are normally for entering data, rather than going into the tables … Forms are normally for entering data, rather than going into the tables (which you should never really do).Use the reports for if you want to collate any information into different formats - you would use the reports to make reports that you would like to print off, for example.



    So a report is to look at data whereas a form is to edit data ?

    i remember doing this in GCSEs, guess they still do them now.

    A report will show the data collected in reading format.

    for example if you have data of customers, you will create a report showing there details

    ryman1000;8140746

    So a report is to look at data whereas a form is to edit data ?



    Well... you would have tables as the main part of your database, and then use forms to navigate through your DB and to view and enter information.

    Then, have reports for things that you would like to print off, or to do various reports on the data you've collated.

    i.e. you might want to have a form called "Add Supplier" or one called "View Suppliers", which would show all the info about them. You might then want a report called "All Suppliers A-Z" or "All Suppliers by Type" - using the data from your forms, but using the reports to see it how you want to see it...

    Am I making sense?!

    Original Poster Banned

    hodsey77;8140782

    Well... you would have tables as the main part of your database, and then … Well... you would have tables as the main part of your database, and then use forms to navigate through your DB and to view and enter information.Then, have reports for things that you would like to print off, or to do various reports on the data you've collated.i.e. you might want to have a form called "Add Supplier" or one called "View Suppliers", which would show all the info about them. You might then want a report called "All Suppliers A-Z" or "All Suppliers by Type" - using the data from your forms, but using the reports to see it how you want to see it...Am I making sense?!



    black gerbil1;8140780

    i remember doing this in GCSEs, guess they still do them now.A report … i remember doing this in GCSEs, guess they still do them now.A report will show the data collected in reading format.for example if you have data of customers, you will create a report showing there details



    :roll: ^


    Thanks for the help, much appreciated both repped
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. GTX 1070 went out and old card won't work either.11
      2. Good Sim only deals??57
      3. Digital ps4 games22
      4. BT FIBRE EXISTING CUSTOMER45

      See more discussions