Microsoft Access 2013 RRS feed

  • Question

  • I'm new to Access and I have this project whereas I need to create a queries sheet so that when I make a report it will show the data that I queried. On the "Query" tab what do I write to ignore certain data properties?
    Saturday, February 18, 2017 2:35 AM

All replies

  • Hi,

    To create a query, you might follow these steps:

    1. On the Create tab, click on Query Design

    2. From the Table List window, select the table you want to query and then click Add, then click the Close button

    3. From the table shown above the query grid, select each field you want to show on the query and drag it onto the query grid below

    4. Close the query design and save it

    5. Open the saved query to see the result

    Hope it helps...

    Saturday, February 18, 2017 3:48 AM