• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint