« Does anybody konw if there is a way to connect MIcrosoft Access to an online database?
I have a 2000 corvette. How do I access the the cable on the selector end of the automatic transmission? »

Access 2007 NEED HELP!!!?

I’ve got some work to do for school, and well I’m stuck. Case study is about a dating agency that wants a prototype done. We have to create an Access database that has forms, switchboard and reports. I’ve done most of the stuff, it’s just one task thats totally confused me. We were given guidelines how to set up the database, and relationships etc. I have five tables – Client, Client Meeting, Client Hobby, Hobby and Meeting. The database has to match people together automatically based on "Gender, Age, Hobbies, City/Town". I thought this would happen with a query but I’ve been trying for ages now and still stuck at this point! :(

PLEASE HELP >>> MANY THANKS IN ADVANCE :)

So your database purpose is to match compatabiliy of their client.
yes you can do this in query, forms or reports.
hope this link helps..
http://allenbrowne.com/ser-62.html

This entry was posted on Saturday, February 27th, 2010 at 6:20 am and is filed under access help. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Access 2007 NEED HELP!!!?”

  1. rk! Says:
    February 27th, 2010 at 11:55 am

    Basically you wanted to group the people. This is not a job of database. You have to write a query for that. One of the simplest ways to do is create a QUERY object combining all the needed columns from all the tables and ordering on the hobbies, DOB etc. Use this query wherever you want.
    References :

  2. kawils Says:
    February 27th, 2010 at 12:28 pm

    So your database purpose is to match compatabiliy of their client.
    yes you can do this in query, forms or reports.
    hope this link helps..
    http://allenbrowne.com/ser-62.html
    References :

Leave a Reply