Chapter 13Parameter Queries

Introduction

In this chapter you will learn how to create queries that prompt the user for information. You will learn how to create a parameter query, customize a dialog box, create multiple prompts to the user, use the LIKE keyword to prompt the user, prompt the user for dates, and create a button on a form that will prompt a user.

Definitions

Parameter query — A query that enables the user to set the criteria for selecting records at run time by filling in a dialog box.

Parameter Queries

Up to this point you have learned how to create queries that display results based on the design of the query. You can also create queries that display results that are based on criteria set by a user. This type of query prompts the ...

Get SQL for Microsoft Access, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.