Datasheet

Book IV
Chapter 1
Publishing Access
Applications
621
✦ Access Reports = SQL Server Reporting Services Reports (.rdl):
Reports that you create in your Access database application are con-
verted to RDL files (Report Definition Language — you can find out more
about that in Book III, Chapter 1). Then they’re presented using SQL
Server Reporting Services; the Report Viewer Web Part renders the
reports in the browser.
✦ Access User Interface Macros = JavaScript: Macros attached to user
interface objects (such as buttons, text boxes, forms, and reports) are
known as UI macros. Data macros (see the next item in this list) are
associated with tables. Use UI macros to automate a series of actions,
such as opening a report when you click a navigation tab. UI macros in
SharePoint use JavaScript that is attached to your Web pages.
✦ Access Data Macros = SharePoint Workflows: Data macros use and
apply business-level Access macros at the level of individual tables. For
example, if you want to update the content of a field in a table when the
content of another field in another table changes, then you can easily
achieve this using Data Macros. When you publish your application to
SharePoint, the data macros you’ve defined in your application are con-
verted to SharePoint workflows on the list.
Figure 1-8 shows you how SharePoint turns the data macros associated
with the PurchaseOrders table in the Northwind Traders Web database
application into workflows.
Figure 1-8:
Data
macros are
converted
into
SharePoint
workflows.
✦ Access Queries = System table: If your Access database application
contains queries, SharePoint puts them in the System table (that is,
the MSysASO SharePoint list) in the SharePoint site, where the Access
Services query processor renders the queries.
Publishing to Access Services
31_587164-bk04ch01.indd 62131_587164-bk04ch01.indd 621 9/30/10 8:09 PM9/30/10 8:09 PM