Microsoft Office Tutorials and References
In Depth Information
Tables, Queries, Forms, and Other Objects
mail solicitation, study the letter and ask yourself, “How did I get in this
database, and which database query produced my name?” The junk mailer is
probably targeting extraordinarily beautiful, intelligent people.
After you create a query, you can save it and run it again. You can use it as
the basis for constructing new queries. The information in database tables
usually changes over time. Customers change addresses. New products
come online, and others are discontinued. But no matter how much the data
changes, you can find out exactly what you want to know from a database by
running a well-crafted query.
Reports for presenting and examining data
Figure 1-4 shows a report. Reports can be made from database tables or from
the results of queries. Reports are usually read by managers and others who
don’t get their hands dirty in databases. They’re meant to be printed and
distributed so that the information can be scrutinized and analyzed. Access
offers many attractive reports. Don’t worry — the program does most of the
layout work for you, and exporting reports to a Word file is easy.