New in Access

Reports are among the most improved areas in Access 2007. Several new features have been added to make reports both easier to create and more powerful. For starters, Layout view allows you to design reports while you are viewing your actual data. Many of the tasks of creating a report, such as formatting, sorting and grouping, and adding totals handled in Layout view while your data is onscreen. As a result, you can accomplish many design tasks without having to switch between Design view and Print Preview.

A report opened in Print Preview is really just an image, so you cannot easily search for data or sort or filter content. Access 2007 introduces Report view, which provides a new view of the data in a report that rivals that of forms.

Sorting and grouping is another area that has been enhanced in Access 2007. The sorting and grouping dialog box used in previous versions of Access has been replaced with the new Group, Sort, and Total pane. It enables you to quickly create group levels and sort levels, as shown in Figure 11-1.

Creating reports has also been made easier using the Layout feature. Layouts are groups of aligned controls that resize and move in conjunction with one another. There are two types of layouts: stacked and tabular. Stacked layouts are useful for grouping controls in a stack, where controls are aligned vertically as shown in Figure 11-2. These are also particularly useful for forms.

Figure 11-1

|JJ Reportl

i

Company

| Microsoft

First Name

Rob

Last Name

;Cooper

ID

2

Company

Data Dynamics NW

First Name

Teresa

Last Name

Hennig

ID

3

Company

J Street Technologies

First Name

Armen

Last Name

Stein

ID

4

Company

Microsoft

First Name

Geoff

Last Name

A tabular layout is used to group controls that are aligned horizontally, such as a table (see Figure 11-3).

Ü Reportl

ID

Company

First Name

Last Name

Microsoft

Rob

Cooper

: 2

Data Dynamics NW

Teresa

Hen nig

: 3

J Street Technologies

Armen

Stein

4

Microsoft

Geoff

Layouts also enable you to add gridlines that grow or shrink with the data. These are much easier than creating lines in previous versions of Access. The Line and Rectangle controls are still available if you require more control over the placement of lines. Figure 11-4 shows a report with a tabular layout that has gridlines.

ij rptTabularLayout

ID

Company

First Name

Last Name

1

Microsoft

Rob

Cooper

2

Data Dynamics NW

Teresa

Hennig

3

J Street Technologies

Armen

Stein

4

Microsoft

Geoff

0 0

Post a comment