|
||||||
Groups By Richard Rost ![]() ![]() 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? MembersMembers 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 files from class plus get access to the Code Vault. If you're not a member, Join Today! Links
Keywordsmicrosoft 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
|
||||||||||||||||||||||||||||
| |||
Keywords: TechHelp Access 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 PermaLink Groups in Microsoft Access |