Looking Ahead

   

This chapter has concerned itself mostly with structures and activities more appropriate for use with a database manager, such as Access or SQL Server, than for a data analysis application such as Excel. The reason is that if you are to manage data in a database from the Excel platform, it's useful to understand what effect your actions have in the database.

The next chapter returns to Excel, and the methods you use there to do what this chapter discussed in the context of Access: defining tables and fields, managing table joins, and creating and executing queries, all without ever using the database management system.



Managing Data with Microsoft Excel
Managing Data with Microsoft Excel
ISBN: 789731002
EAN: N/A
Year: 2003
Pages: 134

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net