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.
Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
