Summary
In Chapter 14 we discussed the reasons why a multi-table database can be a better tool than a single table database and illustrated how a table can be subdivided. In this chapter you’ve learned how to join the new tables so that they can be used together by Access to provide the same level of functionality as the old single table. The joins are in place for inspection in the microbrewery database in the chap15end.mdb file.
Next we’ll construct a complete example to bring together these elements into a working database.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2005 Mark Whitehorn
About this chapter
Cite this chapter
(2005). Tables — making multiple tables work together. In: Accessible Access 2003. Springer, London. https://doi.org/10.1007/1-84628-189-X_15
Download citation
DOI: https://doi.org/10.1007/1-84628-189-X_15
Publisher Name: Springer, London
Print ISBN: 978-1-85233-949-4
Online ISBN: 978-1-84628-189-1
eBook Packages: Computer ScienceComputer Science (R0)