Microsoft Office Tutorials and References
In Depth Information
Tutorial 5
Objectives
Creating Advanced
Queries and Enhancing
Table Design
Making the Panorama Database Easier to Use
Session 5.1
• Review table and
object naming
standards
• Use the Like, In, Not,
and & operators in
queries
• Filter data using an
AutoFilter
• Use the IIf function to
assign a conditional
value to a calculated
field in a query
• Create a
parameter query
Case | Belmont Landscapes
Session 5.2
• Use query wizards to
create a crosstab
query, a find duplicates
query, and a find
unmatched query
• Create a top
values query
After graduating with a university degree in Landscape Architecture and then
working for a firm that provides basic landscape services to residential custom-
ers, Oren Belmont started his own landscape architecture firm in Holland,
Michigan. Belmont Landscapes specializes in landscape designs for residential
and commercial customers and numerous public agencies. The firm provides a
wide range of services—from site analyses and feasibility studies, to drafting and
administering construction documents—for projects of various scales. Oren’s
company developed the Panorama database of customer, contract, and invoice
data; and the employees use Microsoft Office Access 2007 (or simply Access) to
manage it. The Panorama database contains tables, queries, forms, and reports
that Sarah Fisher, office manager, and Taylor Sico, marketing manager, use to
track customers and their landscape projects.
Session 5.3
• Modify table designs
using lookup fields,
input masks, and data
validation rules
• Identify object
dependencies
• Review a Memo field’s
properties
• Designate a trusted
folder
Oren, Sarah, and Taylor are interested in taking better advantage of the power of
Access to make the database easier to use and to create more sophisticated
queries. For example, Taylor wants to obtain lists of employers in certain cities,
and Sarah needs a summarized list of invoice amounts by city. Sarah wants to
change the design of the Customer and Contract tables. In this tutorial, you’ll
modify and customize the Panorama database to satisfy these requirements.
Starting Data Files
Case1
Case2
Panorama.accdb
Products.accdb
Contract.accdb
Training.accdb
Case3
Case4
Case5
Agency.accdb
Vacation.accdb
(none)
Search JabSto ::




Custom Search