RAMCO Software Training

RAMCO Software Training
Our Mission: To Make People More Productive Through Training

Computer Training Help! Key Software Tips & Hints

Last issue’s Mystery Software Character question was:

In Access, if you wish to avoid re-designing queries to change criteria, use me.  Who am I?

The answer to this question is a parameter. With a parameter query, Access prompts the user for the needed criteria.  Although the dialog box prompts for the specified information, there is no check done for invalid look-ups.  If the criterion is not found, a blank datasheet is displayed.

Parameters are descriptive text messages.  They must be enclosed in brackets [ ].  The descriptive text cannot be the name of an object or field in the current database; therefore, it must be unique.  It cannot contain a period, exclamation point, bracket, or accent.  Parameters can be substituted for values in logical and text criteria.

EXAMPLES

[Enter First Name]
>=[Enter Dept No]
Not Like [Enter City]

Single Parameter Query

Access computer training in Seattle, Tacoma, Renton

Schedule your Access class today!


Training
Courseware
Locations
Custom Services
Registration Form
Site Map

RAMCO Software Training • Serving the Greater Puget Sound Area
Seattle (206) 292-4914 • Tacoma (253) 922-0299 • FAX (253) 922-6041

3600 Port of Tacoma Road, Suite 507
Tacoma, WA 98424

Copyright © 2010 RAMCO Consulting Services, Inc. All rights reserved.

Back to Top