Microsoft Access 2010 Bible

Appendix B: What’s New in Access 2010

1263

Reports

Reports offer all the new features of forms but also include additional group, sort, and total fea-

tures. Sorting and grouping can be applied and automatically viewed in Report view. Simple group

totals and sums can be added to a section by selecting the section and selecting a Sum Field

option. No need to create a calculated control. Figure B.12 shows the new Group & Sort area, and

how you set up a report group in Access 2010.

FIGURE B.12

Access 2010 reports come with a number of built-in summary and other totals controls.

Macros

Microsoft is placing a large emphasis on macros in Access 2010. Much of this has to do with the

new security model. Certain macro actions, such as opening forms and reports, are considered

“safe” and are permitted to run without any adjustments to the default Access security settings.

These macros may be embedded in forms, reports, and controls to automate many common data-

base operations.

Macros now include error handling, better debugging, and the ability to assign values to the vari-

ables. This is a big change over previous versions of Access and may be difficult for many advanced

50_475348-bapp02.indd 126350_475348-bapp02.indd 1263 4/1/10 2:01 PM4/1/10 2:01 PM