looking for an Access database for wine

Harvey Kliman 20 Reputation points
2025-11-30T02:42:05.1466667+00:00

Looking for template for tracking wines I buy, drink and evaluate for future use.

Microsoft 365 and Office | Access | For home | Windows
{count} votes

Answer accepted by question author
  1. George Hepworth 22,220 Reputation points Volunteer Moderator
    2025-11-30T11:36:07.85+00:00

    Have you tried searching on the internet for templates? You might find one that'll give you a start. The thing is, though, that templates, even templates for a particular topic like wine collecting, are "one size fits all". That means you'll probably have to make adjustments to suit your unique requirements.

    And that, in turn, means you need to invest time learning the fundamentals of good database design. Put another way, even if you do find such a template, you need to know how to properly modify it to work for you.

    There is, in fact, an Access template available which tracks product inventories, although its main focus is a company which sells products. The inventory component is one part of it. The one you want is Northwind dev edition. But I see right next to it, "Asset tracking", which could also be a good example to learn from.
    User's image

    You'll need to invest time in learning how to properly design your tables. Here are a couple of resources to help you get started.
    https://dori-uw-1.kuma-moon.com/en-us/troubleshoot/microsoft-365-apps/access/database-normalization-description
    https://youtu.be/GFQaEYEc8_8?si=q0AvsbDEoV6aQlKi

    In

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.