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.