When the primary key value is deleted in a primary table, Access will automatically delete all foreign key values in a related table. When the primary key value in the primary table can match many of the foreign key values in the related table. Enables you to ask questions about the data stored in a database and provides answers to the questions in a datasheet. A row in the query design grid that determines which records will be selected. Provides a step-by-step guide to help you through the query design process. Special character that can represent one or more characters in the criterion of a query. Uses greater than (>) , less than (<) , greater than or equal to (>=) , and less than or equal to (<=) , etc. to limit query results that meet these criteria. Returns only records that meet all criteria. Returns records meeting any of the specified criteria.