Friday, April 16, 2010

MS Access Project, trying to get access to perform matchmaking?

I'm working on a project where we have to use access to create a mini eharmony type database. We have the basic tables and stuff set up, but don't know how to make access query based on what each person who enters their profile into the database. We have about 6 different "dimensions", and we want to basically make it so that it brings back the best matches.





Of course this has to be automated, not us manualy creating a new query for each person. This a project for a beginning college access class, so most of us are learning access for the first time. Is there a webpage or technique we can look up to help us out.





It's a level one class and we are not expected to write code or anything like that. Any help would be GREATLY appreciated!


Thank you in advance for any help!!!!!

MS Access Project, trying to get access to perform matchmaking?
Does not look easy, may be you can contact an access expert live at website like http://askexpert.info/ .
Reply:Well it probably isn't going to be a pure matching query unless you really think that there is someone else in the database who is a 100% exact match to the other person's interests. (In other words you can't just do a "SELECT person FROM clients WHERE dimension1 = 'other person's choice' AND dimension2 = 'other person's choice' AND dimension3...") So you'd have to take the first person and then select people who match on dimension #1 and store them somewhere, then do it again for dimension 2,3,4... then see who shows up the most times when you combine all those difference result sets (i.e. who matches in the most dimensions - so "SELECT other_client_id, count(matches) from dimension_match WHERE client_id = 1 ORDER BY count(matches) DESC LIMIT 5" to get the top 5 potential matches). Can't really be more specific without knowing how your database tables are setup.





You'd automate it by creating queries that just get the appropriate variables (probably a client id) substituted in. So perhaps a form where you choose the person and then hit "Find Matches" and some background code that runs the appropriate queries, does the counting and spits out the best matches in a datagrid.

white teeth

No comments:

Post a Comment