Computer Application Software Guide / Comp 2000: Forms & Queries in Access

Creating Forms & Queries in Access

Forms

Forms allow you to manipulate how the data from your database is presented to the user, in order to make it easier to work with. 

Simple Ways to create forms

Form Tool:

1. In the Navigation Pane, click the table or query that contains the data you want to see on your form.

2. On the Create tab, in the Forms group, click Form.

Access creates the form and displays it in Layout view.

Split Form: 

gives you two views of the data at the same time — a Form view and a Datasheet view.

1. In the Navigation Pane, click the table or query that contains the data that you want on your form. Or open the table or query in Datasheet view.

2. On the Create tab, in the Forms group, click More Forms, and then click Split Form.

Access creates the form and displays it in Layout view

Form Wizard:

1. On the Create tab, in the Forms group, click Form Wizard.

2. Follow the directions on the pages of the Form Wizard.

3. On the last page of the wizard, click Finish.

Blank Form tool:

1. On the Create tab, in the Forms group, click Blank Form. Access opens a blank form in Layout view, and displays the Field List pane.

2. In the Field List pane, click the plus sign (+) next to the table or tables that contain the fields that you want to see on the form.

3. To add a field to the form, double-click it or drag it onto the form.

   • After the first field has been added, you can add several fields at once by holding down the CTRL key, clicking several fields, and then dragging them onto the form at the same time.

   • The order of the tables in the Field List pane can change, depending on which part of the form is currently selected. If the field you want to add is not visible, try selecting a different part of the form and then try adding the field again.

4. Use the tools in the Header/Footer group on the Design tab to add a logo, title, or the date and time to the form.

5. Use the tools in the Controls group of the Design tab to add a wider variety of controls to the form.

Queries

Click on the create tab and scroll till you find the queries group. Click on Query design and choose the table you want to use and click add and then close. Choose the criteria for the query. From design view click run to display the results in datasheet view.