Page 8 of 19PREVNEXT

Queries IV: Working with complex criteria

Access practice file and practice instructions

Download size: 840 KB (<3 min @ 56 Kbps)

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


In this practice session, you'll get a chance to specify complex criteria in the query design grid and to observe the difference between And and Or.

Then, you'll use the In operator to enter several criteria in the same cell.

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 8 of 19PREVNEXT