Simpe Access help!!

[samirkhan1]

Am new to this forum so not sure is this is the right place to post my question. basically been given a task to complete but not sure how to do it. i'm sure its simple for Advanced users but not for me!! Havent been given the data yet but below is the question...

Background: You will be presented with a subset of Subscribers from a Database. The fields you will be give are:

Creation Date,Unique Key,DIY Key,Title, Initials, Surname, Suffix, Addr1-5, Postcode, Start date, End Date, Despatch, Phone No1, Phone No3, Amount Paid, Date Paid, Payment Method, No Mail, Loyal, Email-Home, Email work
Mobile

Not all fields will be fully populated. For the sake of this exercise you may interpret the data as you wish provided you detail your assumptions in a report at the end.

You will be provided with two files. Live_Subs1 and Live_Subs2

Task

1) take both Files into Access
2) De-duplicate files so that there is one unique record for each person. How many duplicates were there?
3) How many people pay by Direct Debit and have a valid email address?
4) Of the non DD people (how many are there), what is the average tenure (End Date – Start Date)?
5) Create a cross tab of payment method by revenue.

Would anyone be able to assist me in answering this. I've be very grateful is so.
Thanks!

 

[RuralGuy]

If I'm wrong then I apologize, but this sounds for all the world like a class/course/school project. If so, then *you* need to benefit by trying to accomplish the task. If you get stuck somewhere then asking for some direction to a solution with information on what you've done so far would be appropriate. As it is, your post is way too general and would be difficult to respond to with any specific suggestions.

 

[samirkhan1]

I know it does sound like a school project but it isnt. Its for some analysis work but just cant figure out how to tackle this part of it. I use Access databases but dont really develop in it. Thanks for yor reply though.

 

[RuralGuy]

I take it you are stuck at:

1) take both Files into Access

 

[samirkhan1]

You must think i'm really stupid!! (but your right!)
Am reading some stuff on elimitaing duplicates from an access manual i've got so should be ok with part 2 (I hope!). Parts 3 and 4 are just settign my queries i take it.? I use queries on my work databases now and modify them from time to time depending on the results i need so again should be ok there. Cross Tab!!???