Chapter 4. Taming Access Data


IN THIS CHAPTER

Creating a Totals Query

137

Creating Queries That Make Decisions

147

Running Action Queries

150

Preventing Form Errors by Validating Data

155

Using Form Controls to Limit Data-Entry Choices

160

Creating a Multiple-Column Report

171

Adding Calculations to a Report

174

Creating a Shadow Effect for Report Text

177

Controlling Report Output

177


Microsoft Access is the data powerhouse of the Office suite. It's a full-fledged relational database management system, but it offers easy-to-use features for storing, viewing, and manipulating data. However, Office gurus want to go far beyond these simple data tasks, and they know that Access has the tools that are powerful and flexible enough to handle just about any need. Running through all of these tools would require several books of this size. However, I have a few favorite tools, tricks, and techniques that I find are the most useful for bringing Access data down to size, and I tell you about these features in this chapter. You learn how to create a totals query, how to create queries that make decisions, how to run action queries, how to set up form validation features, how to use controls to improve form data entry, how to create multiple-column reports, how to use calculations in report fields, and how to control the output of your reports.



Tricks of the Microsoft Office Gurus
Tricks of the Microsoft Office Gurus
ISBN: 0789733692
EAN: 2147483647
Year: 2003
Pages: 129

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net