In this final source of getting data, we'll review folders. Sometimes, you'll get information from sources in individual files, but you need to report on all the data as one file. Maybe it's sales information being polled monthly from a point of sale system. You could create a separate Query for each month, but at the end of one year, you would have 12 separate Queries. What if you have 10 stores? At the end of the year, you would have 120 separate Queries. Not only is that more Queries for a single source than you would want to have, you wouldn't want to have to create a new Query each month. If the data is in the same format and in the same file type, you can just get the data from the folder, rather than individual files.
We will not be walking through getting data from a folder in this chapter. We'll cover it when we review editing/modeling data. It is the Query Editor tool that makes data usable as one complete data source. Use the Get Data window to connect...