Modify a Form After you create a form, it opens in Layout view, where you can modify it. To change the s i ze of a field: 1.    Click a sid... [Read More]

Create a Mult i ple Items Form You can use the Multiple Items button on the Forms tab to create a form that displays multiple records, one ... [Read More]

Create a Split Form A split form is a form in which the same data is displayed in two views simultaneously. One part of the form displays i... [Read More]

Creating Fo r ms Access forms are much like paper forms: you can use them to enter, edit, or display dat a . They are based on tables. Whe... [Read More]

Create a Parameter Query If instead of entering predetermined criteria, you want to prompt users when a query runs, you can create a param... [Read More]

Save a Que r y After you create a query, you can save it. You can rerun a saved query at any time. If you change the data on which the saved... [Read More]

Create a Que r y That Uses T w o or More T a bles If you want to view data from two or more tables or queries, you can create a query that ... [Read More]

Sort Multiple Columns i n a Query As you learned in the previous section, you can sort the rows your query returns. You can also create so... [Read More]

Sort a Query When creating a query, you can sort the rows you retrieve in ascending or descending order by choosing the option you want on t... [Read More]

Retrieve Mult i ple Colu m ns You can use an Access query to retrieve multiple columns of data. On the Field line in Query Design view, choo... [Read More]

Retrieve a Si n gle Column You can use an Access query to retrieve a single column of data. Instead of choosing the tablename.* option on t... [Read More]

Change from Da t asheet View to Query De s ign View After you run a query, you can easily change back to Query Design view and make modific... [Read More]

Creating Micr o soft Access Queries A query can be based on tables or on other queries. To create a query, you open the ta b les or queries ... [Read More]