• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Save a Query in Access

How to Save a Query in Access

By: Emmanuelle Douglas
  • Share
  • Share on Facebook

Access is the database component of the Microsoft Office suite. Databases let you configure large quantities of data into concise queries and reports. The queries used in Access let you ask a question of your database. Based on the criteria entered, you can find data from millions of records. Access queries can be performed manually using select queries or automatically by using the query wizard. Either method lets you choose which fields are used during the query.

...
Save Access queries by using the "Save" icon on the Quick Access Toolbar.

Step

Open Access 2007 and select a database you created earlier. Select the "Office" button and select "Open." Browse your computer and locate the database. Click on the database and click "Open." The database opens.

Step

Create a query by using the "Create" tab on the ribbon. Select "Query Design." The Show Table dialog box appears. Click on the table that the query will be applied to. Click "Add." Click "Close."

Video of the Day

Step

Double-click on the fields you want included in your query. Add criteria you want to include in your query. Type the criteria in the "Criteria" field. Run the query by clicking on the "Run" button. View your query results.

Step

Save your query by clicking on the "Save" icon on the Quick Access Toolbar. Give your query a name that identities it. Your query can begin with "Qry_" to indicate that it is a query. Click "OK" once you have named your query. Your named query appears in your query list.

Show Comments

Related Articles

How to Use a Microsoft Access Program

How to Use a Microsoft Access Program

Around The Home
Productivity
By: Tricia Goss
How to Combine Two Access Reports in One

How to Combine Two Access Reports in One

Around The Home
Productivity
By: Mercedes T. Green
How to Query Blank Fields in Access

How to Query Blank Fields in Access

Around The Home
Productivity
By: Ryan Cockerham
How to Convert an Access Query to a Table

How to Convert an Access Query to a Table

Around The Home
Productivity
By: Mercedes T. Green
How to Make Your Own CRM Using Microsoft Access

How to Make Your Own CRM Using Microsoft Access

Around The Home
Productivity
By: Emmanuelle Douglas
How to Multiply Two Fields in Microsoft Access

How to Multiply Two Fields in Microsoft Access

Around The Home
Productivity
By: Emily Ediger
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.