Access

[jurtje]

I've been offered a project at the Dutch Embassy here in Chile. Thing is, they have a database in Access, but apperently it doesn't cross reference very well. For example: my name is John and I'm Dutch and I work in I live in the South.
If they tell Access to print out invitations to a party, it prints out two invitations for John, since he's on the list of Dutch and on the lost of people who live in the South.

Now, I have never worked in Access, but do you guys think it's an easy thing to solve? And do any of you have experience with Access?

[siq]

From what I've heard Access is easy to manage. After you get the feel of it I'm sure you can easily fix the problem.

[undergroundtech]

Someone donated me a copy of Video Professor's Learn Access about a month ago. I made it through the 1st of 3 courses of it, then decided Access was like Algebra in that it should be filed under the "I'll probably never use that" category and have not touched it since.

At least I have the Learn Access for Dummies, should I ever need to learn it. :lol:

From what I have seen of it, I would agree with Siq. It looks like it would be easy to work with once you get use to it.

[techniq]

I never used Access till I just recently at work. I'm pretty good with mysql/php but I have to say Access seemed harder to get the result you were wanting. I am using 2k (not XP/2003). I was able to get it finally, but would have been much easier if I could have just typed in the sql statements (which it allows, but once again, didn't make alot of sense)

There does seem to be alot of descent web help though, so you should be able to find answers to most questions you may run into.

[KryoNexus]

you should be able to design a query from the main panel, then just play around with the criteria. make sure you right click on the query you have made, and choose "design view". this will give you a look at the code running in the background, from which you can make changes. you should be able to do it with "or" statements