How to Create an Access Query to Prompt User to Input

Written by leigh thompson
  • Share
  • Tweet
  • Share
  • Email

Access queries pull information from the database table based on set criteria. One option for the criteria includes the ability to create user prompts. When the query is run, a box pops up giving you directions. These prompts include matching single field values such as a name or a range of fields such as dates. You enter a value into the box and the query pulls all the applicable information.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Open your Microsoft Access database.

  2. 2

    Select the "Create" tab on the top menu bar. Click the "Query Wizard" button. Select "Simple Query Wizard." Click "OK."

  3. 3

    Click the down arrow and choose a table or query to base your new query on.

  4. 4

    Choose the fields you want to add to your query. Click the ">" button to add the fields. Click "Next."

  5. 5

    Name your query. Click the radio button next to "Modify the query design." Click "Finish."

  6. 6

    Place your cursor in the "Criteria" box of the field you are searching. Type the words you want to appear on the prompt. Make sure to enclose the phrase in square brackets. For example:

    [What name are you searching for?]

  7. 7

    Click the "Run" button on the top ribbon. A box should appear that shows the phrase you typed. Enter a response. The query pulls all records that contain that word or number.

Tips and warnings

  • To do a range of dates use:
  • Between [The start date:] And [The end date:]

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.