Try the Complete Microsoft Access Course Free

Run a Query in Access – Instructions and Video Lesson

/ / Access 2013, Access 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
Run a Query in Access - Instructions: A picture of a query opened in “Design View” in Access.

Run a Query in Access: Overview

            You can run a query in Access when using query design view. To do this, click the “Design” tab of the “Query Tools” contextual tab within the Ribbon. Then click the “Run” button in the “Results” button group.

            If the results are not what you expected, you may need to re-design the query structure. You can easily return to the query design view from the displayed result set. To do this, click the “Home” tab in the Ribbon while viewing the displayed result set from the query. Then click the “View” button in the “Views” button group.

Run a Query in Access - Instructions: A picture of a query opened in “Design View” in Access.

Run a Query in Access – Instructions: A picture of a query opened in “Design View” in Access.

            You can also run a saved query in Access to view its result set. To do this, select its name from the list of queries shown in the Navigation Pane. Then press the “Enter” key on your keyboard. Alternately, double-click the name of the query to run from the listing shown in the Navigation Pane.

            More advanced Access users should also note that you can run a query programmatically. To do this, use the “OpenQuery” action within a macro.

Run a Query in Access: Instructions

  1. To run a query in Access from the query’s “Design View,” open a query in query design view.
  2. Then click the “Design” tab in the “Query Tools” contextual tab within the Ribbon.
  3. Then click the “Run” button in the “Results” button group.
  4. To run a query in Access that has been saved, display the “Queries” within the database’s Navigation Pane.
  5. Then select the name of the query to run within the Navigation Pane.
  6. Then press the “Enter” key on your keyboard.
  7. Alternatively, double-click the name of the query shown in the Navigation Pane.

Run a Query in Access: Video Lesson

            The following video lesson, titled “Running a Query,” shows you how to run a query in Access. This video is from our complete Access training, titled “Mastering Access Made Easy v.2016-2013.”

TOP
Sale! $49 All-Access 1 Days 9 Hours 6 Minutes 16 Seconds      $199 $49 Entire Library!
See Deal