Tutorial 6

Get Started. It's Free
or sign up with your email address
Rocket clouds
Tutorial 6 by Mind Map: Tutorial 6

1. Create a Split Form: http://officeimg.vo.msecnd.net/en-us/files/397/251/ZA010373196.jpg

1.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.

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

2. Overview of Subforms: http://officeimg.vo.msecnd.net/en-us/files/477/822/ZA010278560.jpg

2.1. # 1 The main form shows data from the "one" side of the relationship.

2.2. # 2 The subform shows data from the "many" side of the relationship.

3. Split cells

3.1. When you split a cell vertically, you create a new row in the structure of the layout. If there are other cells on the same row as the one that you split, they remain the same size

3.2. When you split a cell horizontally, you create a new column in the structure of the layout. If there are other cells in the same column as the one that you split, they remain the same size

4. Print the Relationships Window

4.1. 1.Open the Access database that has relationships you want to print.

4.2. 2.On the Database Tools tab, in the Relationships group, click Relationships

4.3. 3.On the Design tab, in the Tools group, click Relationship Report. A report that depicts the Relationships window opens in Print Preview Mode

4.4. 4.To make any adjustments to the way your report will print, use commands on the Print Preview tab.

4.5. 5.On the Print Preview tab, in the Print group, click Print.

5. Show or Hide a table in the Relationships Window

5.1. #1 On the Database Tools tab, in the Relationships group, click Relationships.

5.2. #2 Do one of the following: To show a table, on the Design tab, in the Relationships group, click Show Table, and then in the Show Table dialog box, add the table that you want. To hide a table, in the Relationship window, click the table that you want to hide, and then press DELETE.

5.3. #3 Press CTRL+S to save your changes.

6. Create or add a Subform

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

6.2. 2.On the first page of the wizard, in the Tables/Queries drop-down list, select a table or query.

6.3. 3.Double-click the fields that you want to include from this table or query.

6.4. 4.On the same page of the wizard, in the Tables/Queries drop-down list, select another table or query from the list.

6.5. 5.Double-click the fields that you want to include from this table or query.

6.6. 6.When you click Next, assuming that you set up the relationships correctly before you started the wizard, the wizard asks How do you want to view your data? - that is, by which table or query. Select the table on the "one" side of the one-to-many relationship. http://officeimg.vo.msecnd.net/en-us/files/500/177/ZA010278987.jpg

6.7. 7.At the bottom of the wizard page, select Form with subform(s), and then click Next.

6.8. 8.On the What layout would you like for your subform? page, click the layout option that you want, and then click Next. Both layout styles arrange the subform data in rows and columns, but a tabular layout is more customizable. You can add color, graphics, and other formatting elements to a tabular subform, whereas a datasheet is more compact, like the datasheet view of a table.

6.9. 9.On the last page of the wizard, type the titles that you want for the forms. Access names the forms based on the titles that you type, and labels the subform based on the title that you type for the subform.

6.10. 10.Specify whether you want to open the form in Form view, so that you can view or enter information, or in Design view, so that you can modify its design, and then click Finish.