You can keep large databases in a single table and still use a pivot table to extract summary data from only a portion of the data. For instance, you can examine a single year from a table that includes multiple years of data.
Note: This is Club MacMost exclusive content. To view this video click the thumbnail below to go to the post as Patreon.com. Once there you will be able to view the video as long as you are logged into your Patreon account and a current supporter of MacMost at the "Club MacMost" or higher level.