Examples of query criteria - Microsoft Support
A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access can compare to values in a text field in a query.
Using Lookup and multivalued fields in queries - Microsoft Support
In Access, you can create a multivalued field that holds multiple values (up to 100). You can also create a Lookup field that displays a user friendly value bound to a value in another data source. When you query a Lookup or multivalued field, there are unique considerations.
Create and run an update query - Microsoft Support
Like the Find and Replace dialog box, an update query lets you specify which value is being replaced, and what the new value is. Unlike the Find and Replace dialog box, an update query lets you: Use criteria that do not depend on the value that you want to replace. Update lots of records in one pass.
Use parameters to ask for input when running a query
To make a query in Access databases ask for criteria when you run it, create a parameter query. This allows you to use the same query over and over without having to constantly open it in Design view to edit the criteria. Understanding the terminology. Before getting into the step-by-step below, it’s helpful to understand these terms:
Create or delete a lookup field - Microsoft Support
You can create a lookup field that displays the customer information in a combo box or list box control. Then, when you select the customer in that control, an appropriate value — such as the customer's primary key value — is stored in the order record.
IIf Function - Microsoft Support
You use IIf to determine if another expression is true or false. If the expression is true, IIf returns one value; if it is false, IIf returns another. You specify the values IIf returns. See some examples. Syntax. IIf ( expr , truepart , falsepart ) The IIf function …
Restrict data input by using validation rules - Microsoft Support
This article explains how to use validation rules and validation text in table fields and form controls. A validation rule is one way to restrict input in a table field or a control (such as a text box) on a form. Validation text lets you provide a message to help users who input data that is …
Apply criteria to text values - Microsoft Support
This article has several examples of query criteria that you can use with the Text data type that can help you get more specific query results and find the information that you want more quickly. If you’re not sure about using criteria see, applying criteria to …
Guide to table relationships - Microsoft Support
You can create table relationships explicitly by using the Relationships window, or by dragging a field from the Field List pane. Access uses table relationships to decide how to join tables when you need to use them in a database object.
Add records to a table by using an append query
If you need to change data in an existing set of records, such as updating the value of a field, you can use an update query. If you need to make a new table from a selection of data, or to merge two tables into one new table, you can use a make-table query.
Join tables and queries - Microsoft Support
If you use other queries (instead of or in addition to tables) as sources of data for a query, you can create joins between the source queries, and also between those queries and any tables that you use as sources of data.