Cry How To...
Access 2007: How to view multiple tables or queries side by side
Access 2007 defaults to showing a tab-view of tables and queries, allowing you to view only one table or query at a time. Earlier versions of Access allowed you to have multiple overlapping windows open so you could view several tables or queries at the same time - this was especially handy when using a large widescreen monitor when working on a database.
Whilst its hidden away, the good news is that you can change the behaviour of Access 2007 to either show tables and queries using its default tab view or to show the traditional multi-window view of tables and queries.
Assuming you selected "Overlapping Windows" in the above sequence you should now be able to open multiple tables and/or queries and arrange them to be able to view them side by side.
These notes have been tested with Microsoft Access 2007, but may apply to later versions as well.
About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.