Datasheet

618
Reports
Reports help you present the data in your database visually — in the format
your business users require. For example, you can create a report that
makes use of charts and graphs if those get your point across best. Figure
1-7 shows an example of a Web report created for the Products table in
the Northwind Traders sample Access Web database. (Impressive, isn’t
it?) Microsoft Access provides you with lots of tools to make sophisticated
reports easy to create.
Figure 1-7:
Access
creates
a sample
layout when
you create a
report.
You can create a report very quickly (if not quite “yesterday”) by following
these steps:
1. Open your Web database application in Access 2010.
2. Click the Home tab to display the left navigation pane.
3. From the navigation pane, select the table or query you want to use to
generate the report.
4. In the Reports group, on the Create tab, click Report to create a Web
report.
Access creates a report automatically, and gives it a standard look and
feel. You can customize the report as needed, changing the layout, color
scheme, and adding or removing fields.
Setting the default form
When you publish your Web database application to Access Services,
SharePoint accepts your application as a SharePoint site. When you navigate
Designing SharePoint-Compatible Access Databases
31_587164-bk04ch01.indd 61831_587164-bk04ch01.indd 618 9/30/10 8:09 PM9/30/10 8:09 PM