Page 18 of 20PREVNEXT

Queries III: Create parameter queries that prompt users for input

Access practice file and practice instructions

Download size: 144 KB (<1 min @ 56 Kbps)
Download location: My Documents

Practice in Access
Problems with the practice?
HelpTry our troubleshooting tips


In this practice, we'll create a parameter query to narrow down lists of donors, as we discussed in the lesson. This time, however, we'll use Design view to set up our fields, although the results will be the same as by using the wizard.

Then we'll test out our query by entering different contribution ranges.

About the practice session

When you click Practice in Access, you may see a security warning. When you click Open in the Security Warning dialog box, a practice database will download to your computer and open in Access, and a separate window with practice instructions will appear alongside (see picture).

Note     You need to have Access 2003 installed on your computer.

Tips

  • If the practice instructions aren't visible, or if they disappear when you click in Access, click the Access Help taskbar button and then click the Auto Tile button in the upper-left corner of the instructions.
  • If the practice instructions cover up Access, click the Auto Tile button in the upper-left corner of the instructions.

Before you begin

Make sure to close Access if it is already running.

Start the practice

Click the Practice in Access button now.

Page 18 of 20PREVNEXT