Home >

New Layout/Report (New Layout/Report assistant)

In this panel of the New Layout/Report assistant, you specify the database table this layout will access, a name for the layout, the type of layout that you want to create, and a default view for the layout.

Note  You may want to review the following Help topics before creating the layout: Creating and managing layouts and reports, Considerations when you create a Report layout, Printing labels, and Printing envelopes.

1.	For Show records from, choose the table that contains the records that you want this layout to display.

2.	For Layout Name, type a descriptive name for the layout.

The layout name automatically appears in the menus used for choosing layouts, such as the Layout pop-up menu. (To change this setting, see Managing layouts.)

3.	Choose the type of layout you want to create.

Depending on the type you choose, additional options may become available.

 

Choose	To
Computer	Create a layout to be used on a laptop or desktop computer screen.
Touch Device	Create a layout to be used on a touch-compatible input device. Then choose iPad/iPad mini, iPhone 3.5-inch, iPhone 4-inch, or Custom Device. To change the layout’s default orientation to portrait, click ; to change the orientation to landscape, click .
Printer	Arrange data for printing on labels or envelopes or in a report. Then choose Labels, Vertical Labels, Envelopes, or Report.

For more information about each layout type, see About layout types.

4.	If you chose Computer or Touch Device, you can then choose the view in which you want records displayed or choose to create a report.

Your layout will be displayed only in the view you selected. To display the layout in all views, do not choose a view in this panel. After you close the assistant, you can choose additional views for the layout using the Layout Setup dialog box (see Setting up form, list, and table views for a layout).

 

Choose	To
Form	Display records in Form View. Records are displayed as a standard form: fields are by default displayed each on a separate line, in the order you specify. In Browse mode and Find mode, you see one record, or form, at a time. Form View is good for data entry or onscreen browsing.
List	Display records in List View. In Browse mode, you see records in a list. Depending on the size of the layout, you may see several records at a time. List View is good for viewing or printing multiple records in rows (a list of records).
Table	Display records in Table View. The fields are displayed in a grid in the order you specify from left to right. Field names are the column headings.
Report	Display or print data in a report. You can create many variations of Report layouts; for example, create a simple report with rows and columns of data (formerly a predefined layout type known as the List view layout), or a complex report with data grouped by specified values with subtotals and grand totals.

5.	When you have finished making your choices:

•	For layouts that will display on computers or touch devices, click Finish. Layouts in Form View and List View are displayed in Layout mode. Layouts in Table View are displayed in Browse mode (and the Modify Table View dialog box appears if there are fields defined in the database).

You can then add or change fields, objects, and other embellishments to your layout. See About defining database fields, Working with data in Table View, and Drawing and inserting objects on a layout.

•	For labels, vertical labels, envelopes, or reports, click Continue. You see the next panel in the assistant.

Notes and tips

•

When you create a report, you have the option of creating a script that will sort a report later in the assistant. The script simplifies the process of viewing and printing the report. The report must be sorted properly to display summary information, and it’s easy to forget which fields need to be sorted.

•

Table View provides a view of your data in a spreadsheet-like format that allows you to quickly rearrange fields, add or delete records, or define fields in Browse mode. For example, you can quickly reorder or resize columns (fields) with just a mouse click (if those options are set). See Working with data in Table View.

•

You can also use Table View to view summary data, by grouping your data by one or more columns (fields) and check subtotals for each group or grand totals for the table. The summary results recalculate and update in real time when you change data values in Table View. See Creating dynamic reports in Table View.

Related topics 

Creating a layout