By Richard Rost 3 years ago
Put Customers Into Groups and Search for Them
In today's video, I'm going to show you how to put customers in your Microsoft Access database into groups (classifications, categories, tags, etc.) and then search for people by group.
Erica from Bay City, Michigan (a Platinum Member) asks: I'd like the ability to group my customers according to interests. I sell collectibles and memorabilia. I know you're very fond of science fiction and fantasy, so to use your example, let's say I want to tag customers who are interested in Star Trek, those who like Star Wars, Firefly, Doctor Who, Lord of the Rings, and so on. Then I'd like to be able to pull up a list of just the people who are in a specific group so I can market to them. What's the best way to do this?
Members will learn how to actually make a Group Table with specific group names. This is better than using a single text field because you can have a specific list of group names, and you will minimize things like spelling errors. We will then filter our customer list by group by selecting from the list.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Groups, Categories, Classifications, Tags, Search, Find, Search for Customer, Junction Table, Many to Many Relationship, Composite Keys, Parameter Query, Criteria, Wildcard, Add to List, Not in List, Product Groups
Subscribe to Groups
Get notifications when this page is updated