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.
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, iPhone, or Custom Device. To change the layout’s default orientation to portrait, click ; to change the orientation to landscape, click . If you choose Custom Device, you can change the value (from 1 to 32000 points) for Width, Height, or both. The custom values you enter will be used for all custom device layouts until you change the values. (The default custom values for portrait orientation are width: 800, height: 1145; and for landscape orientation are width: 1280, height: 665.) |
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
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