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

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.

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

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!

Links

• Wildcard Search: https://599cd.com/Like
• Query Criteria: https://599cd.com/Criteria
• Concatenation: https://599cd.com/Concat
• Filter Records: https://599cd.com/Filter
• Access Beginner 5: https://599cd.com/ACB5
• Parameter Query: https://599cd.com/Parameter
• Relational Combo: https://599cd.com/Relational
• Many to Many: https://599cd.com/ManyToMany
• Composite Keys: https://599cd.com/Composite
• Access Expert 7: https://599cd.com/ACX7
• ABCD Part 2 (Groups): https://599cd.com/ABCD2
• Search Seminar: https://599cd.com/SearchSeminar

Learn More FREE Access Beginner Level 1 Access Level 2 for $1.00 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

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