IN THIS CHAPTER
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. |