Tricks of the Microsoft® Office Gurus

Chapter 4. Taming Access Data

IN THIS CHAPTER

• Creating a Totals Query

• Creating Queries That Make Decisions

• Running Action Queries

• Preventing Form Errors by Validating Data

• Using Form Controls to Limit Data-Entry Choices

• Creating a Multiple-Column Report

• Adding Calculations to a Report

• Creating a Shadow Effect for Report Text

• Controlling Report Output

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 ...