For example, if your data is stored in an Access database, you might want to know the sales figures for a specific product by region.
You can retrieve a part of the data by selecting only the data for the product and region that you want to analyze.
For information about installing an ODBC driver or data source driver that is not listed here, check the documentation for the database, or contact your database vendor.
Selecting data from a database You retrieve data from a database by creating a query, which is a question that you ask about data stored in an external database.
Using the Query Wizard, you can select the tables and fields that you want to include.
An inner join (a query operation that specifies that rows from two tables are combined based on identical field values) is created automatically when the wizard recognizes a primary key field in one table and a field with the same name in a second table.
By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that you want to analyze in Excel.
To start the Query Wizard, perform the following steps.
Longtime tech industry pundit Tim O'Reilly sat down with Information Week to talk about the future of business, society, and the enterprise.
Here's what he says enterprises must do to compete in a changing business environment.
How are organizations striking the balance between new initiatives and cost control?
Download our report to learn about the biggest challenges and how savvy IT executives are overcoming them.