• 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

     

    Read more about Access Development Projects

    A leading European Private Equity Practice came to Xlteq to design and build a bespoke CRM tool to manage and track their investment managers, their clients, and investment opportunities. 

    Find out more

    Bristol based specialist waste paper brokerage and waste management consultancy came to Xlteq to review and enhance an existing order tacking tool built in Microsoft Access.

    Find out more

    Kent based bespoke background screening company asked Xlteq to automate the collection and upload of data necessary for regulatory background checks via an external agency online portal.

    Find out more