• Access Database Tips - Quick Reports From Tables Using Queries

  • Access Database Developers Tips - Quick Reports From Table Using Queries

     

    Sometimes you want to check the data in a table to see what data has been stored.

    Simply Click on “Query Design” on the “Create” tab.

     

    Access – quick reports from tables using queries

     

    This will bring up a query window and a list of tables and queries you have in your database

    Select the table you want to investigate, and press “Add”.

     

    Access – quick reports from tables using queries 2

     

    Drag the fields you want to investigate into the area below.

     

    Access – quick reports from tables using queries 3

     

    Pressing the “run” icon will give you a simple report (you must be on the “Design” tab to see this option).

     

    Access – quick reports from tables using queries 4

     

    Access – quick reports from tables using queries 5

     

    Pressing “View” takes you back to the design screen (you must be on the “home” tab to see this).

     

    Access – quick reports from tables using queries 6

     

    If you want to use a further range of functionality, the select the “Totals” button.

     

    Access – quick reports from tables using queries 7

     

    This creates a new option for you to use.

     

    Access – quick reports from tables using queries 8

     

    Simply select what you want to do from this and press the run button again to see the result.

     

    Access – quick reports from tables using queries 9

     

    Access – quick reports from tables using queries 10