Creating a relationship report in access 2007

Create a one-to-many relationship in Access

creating a relationship report in access 2007

Actually, it's the same feature that allows you to create a relationship. Here's how to create Access can automatically generate a report based on your diagram. If the Access database wizards don't work for you, you'll have to create a custom database. This chapter shows you what you'll need to do. If you have questions on creating table relationships, call the Arkware for various reasons such as informing query, form and report designs.

The field that your lookup will use as the source for values must already exist before you create your lookup field. Open the table where you want to create a new lookup field by double-clicking it in the navigation.

In the above example, click the Employees table. Click in the Field Name column just below the last field in the table and type a name for your new lookup field. In the example, type Region as the field name. In the Data Type column, click the arrow and select Lookup. The Lookup Wizard starts. On the first page of the Lookup Wizard, select I want the lookup field to get values from another table or query. More options appear in the dialog box. Select the name of the table or query that should provide the values for your lookup.

In the example, select Table: After you select the table, use the Which value do you want to display in your lookup list to select the field that you want to use as a display value for your lookup field. By default, Access selects the first text field it can find in the selected table. In the example, you would leave the selected field, Title, as the display value.

The Summary Options window closes. Layout and orientation You can choose the layout and orientation of your report.

creating a relationship report in access 2007

The layout determines where each field appears on the page. Access provides three options to choose from: Stepped, Block, and Outline. When you choose an option, the left side of the window displays a graphic of the layout. Orientation determines whether Access creates the report in portrait or landscape.

creating a relationship report in access 2007

If you print in Portrait, the shortest edge of the paper becomes the top of the page. Portrait is the default option. If you print Landscape, the longest edge of the paper becomes the top of the page. Click to select a layout. Click to select a page orientation. Style A style is a set of formats consisting of such things as background colors, fonts, font colors, and font sizes.

Create a relationship - Access

Access supplies predesigned styles that format titles, labels, and more. When you choose a style, the left side of the window displays a preview.

creating a relationship report in access 2007

Click to select a style. On the final page of the Report Wizard, you can title your report. The title appears at the top of the report and on the Navigation pane. Type the title you want to give the report. Access creates, saves, and opens your report in Layout view. Reports created with the Report Wizard may have the following two sections in addition to the sections found in reports created by using the Report button.

Sections of a Report Appears before a group and displays information about the group. Group Footer Appears after a group and summarizes the group data. Modify a Report After you create a report, you can modify it.

Create a relationship

I assume you know how to create tables, if not, have a look at the article how to create a table in Access Creating the one-to-many relationship I created two tables for this tutorial, a Customer table which stores customer an and Order table which stores orders.

The Customer table already contains some data. The Customer table Empty order table. Take the following steps to create the one-to-many relationship. Follow these steps to create the one-to-many relationship Create two tables. The many-table Order in this example must have a field that will become the foreign key. This field must have the same data type as the primary key it will refer to the primary key of Customer in this example. You can choose any name for the field.

The name of a foreign key field doesn't have to be the same as the primary key field it refers to, but it is allowed.

creating a relationship report in access 2007