Datasheet

Book IV
Chapter 1
Publishing Access
Applications
617
✦ After Update: Allows you to create logic that runs after a record has
been edited in the table.
✦ After Delete: Allows you to create logic that runs after a record has
been deleted from the table.
✦ Named Macro: Allows you to create, edit, delete, or rename data macros
that can be called from a macro or from event code.
Queries
Queries are the heart and soul of most database applications allowing you
to extract and filter the information you need when you need it. You can use
queries to extract data from a single table, or multiple tables, to perform
calculations and to generate reports. Queries appear in the Access left navi-
gation pane under the heading Queries. When you’re working with Web data-
base applications, the queries you create are called (with admirable clarity)
Web queries.
Access provides a Query Designer that provides you with a visual representa-
tion of the tables in your query and their associated relationships. Using this
feature, you can specify which fields will appear in your query results — as
well as dictate the fields used to filter data and perform calculations on
that data. Figure 1-6 shows the SalesAnalysis query from the Northwind
Traders sample Web database application. The figure shows you all the rela-
tionships among the various tables that make up the query. When you add
tables to a query, Access creates the relationship for you automatically in
the Query Designer.
Figure 1-6:
The Query
Designer
makes
queries
easy to
create.
Designing SharePoint-Compatible Access Databases
31_587164-bk04ch01.indd 61731_587164-bk04ch01.indd 617 9/30/10 8:09 PM9/30/10 8:09 PM