Layout view and Design view are the two views in which you can make design changes to forms. You can use either view to perform many of the same design and layout tasks, but certain …

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 change the …

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 …

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.

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 …

Query criteria help you zero in on specific items in an Access database. If an item matches all the criteria you enter, it appears in the query results. To add criteria to an Access query, open the …

In Access desktop databases you can set design options for table, form, report, and query designs from this centralized Access Options location.

Access provides several tools that you can use to familiarize yourself with the structure of a particular database. This article also explains how, when, and why you use each tool. In this …

What’s a web datasheet view? A web datasheet view in an Access app displays online data arranged in rows and columns in a web browser. It can allow data edits or not, as you prefer. …

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 …