Acting on Outside Requests

Up until now databases have been designed with business goals in mind. But what happens if a request comes in from an external source with someone else’s goal as its focus? How can you extract the appropriate data from the database?

The last chapter looked at making permanent changes to your database in response to results of reports and changes in business strategy. This chapter considers answering queries without making permanent changes. Responding to outside requests involves using tools that are familiar to you in as creative a way as possible, including:

  • Searching
  • Filtering
  • Querying

You also need to be able to identify when you are unable to answer a query with your existing data. For example, suppose ...

Get Databases for Small Business: Essentials of Database Management, Data Analysis,and Staff Training for Entrepreneurs and Professionals now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.