To switch to Design view, right-click the form name in the Navigation Pane and then click Design View. Access shows the form in Design view. You can use the property sheet to modify the properties for the form and its controls and sections.

To add criteria to an Access query, open the query in Design view and identify the fields (columns) you want to specify criteria for. If the field is not in the design grid, double-click the field to add it to the design grid and then enter the criterion in the Criteria row for that field.

Switch between Design View and Datasheet View for any saved table. Designate any field as the table’s primary key. Use Builder to create an expression or input mask.

Access provides two views that you can use to make changes to your report: Layout view and Design view. Your choice of which view to use depends on what specific task you are trying to accomplish. You might end up using both views to make your changes.

Open your query in Design view. To do so, in the Navigation pane, under Queries , right-click the query and click Design View . In the Criteria cell under the field you want to use, add an asterisk on either side of your criteria, or on both sides.

Opening a table in Design view gives you a detailed look at the table's structure. For example, you can find the data type setting for each field, find any input masks, or see if the table uses any lookup fields — fields that use queries to extract data from other tables.

You can set design options for table, form, report, and query designs from this centralized Access Options location, although most of the settings are ignored in the table Datasheet and Layout views. You can also customize the selected error checking settings from this category.

Access creates a form and displays it in Layout view. You can make design changes like adjusting the size of the text boxes to fit the data, if necessary. For more information, see the article on using the form tool. Create a blank form in Access. To create a form with no controls or preformatted elements: On the Create tab, click Blank Form.

To see information when either two or more alternate criteria are satisfied, use the or criteria rows in the Access query design grid. If you’d like a refresher, see applying criteria to a query. For example, if a business has customers in several different countries and they are running a promotion only for customers in France, UK and USA.

Layout view and Design view are the two views in which you can make design changes to forms and reports in Microsoft Access. Though you can use either view to perform many of the same design tasks, certain tasks are easier to perform in one view than they are in the other.