Question need help with access project!!! please help :(

[accessnoobster]

I need help to Create a customer database to allow me to conduct mailings in the future. Customers will put their business cards into a jar in hopes of winning promotional items. Their business cards will give me their name, the company they work for, and all the other information I need to set up my database.



heres what i need help doing..

1. Creating a table with all the following fields and settings:
   1. Customer ID (autonumber)
   2. Company Name (text)
   3. First Name (text)
   4. Last Name (text)
   5. Billing Address (text) (this is the street address)
   6. City (text)
   7. State (text—limited to 2 characters)
   8. Zip Code (text—limited to 5 characters)
   9. Phone Number (text)
   10. YTD Orders (currency)
   11. Customer Since (date)
   12. Preferred Customer (Logical, based on Orders exceeding $10,000)
   Saving the table as "Customers."
2. Build a data-entry form (similar to the pic i have attached). Be sure that my entry form uses the "Customers" table for input. Include all the fields of my "Customers" table. Design the format of the data-entry form any way I choose, but do format it. Save the form.
3. Enter data for at least 10 (or more) customers, using the data-entry form. Use the form instead of using the table so I can make sure it works.
4. Sort your database table by the customer's last name.
5. Create and save a query that pulls all the company names from the company name field. (Include only the company names in the query). Sort them alphabetically in ascending order. ( Hint: be sure the sort criteria are included in the query.) Save the query.
6. Create a report that contains only my customer's name (first and last), company name, and phone number (a report of phone contacts). Format your report in some way (title, font colors). Save your report as "Customer Contact Report."
7. Create mailing labels using the Reports/New/Label Wizard. Save this report as "Mailing Labels."

Basically what i need to do, now i know for you access wizards this might seem like a piece of cake but i need help (step by step would be nice but i'm not pushing my luck). If any of you want to do this for me and then tell me how i can add the customer information and update thats fine also, but i'd rather learn how to do it.

I'm also using access 07

thanks in advance

 

[Luddite Lad]

Check the templates available on your computer or online, there is one specifically dedicated to contact management.

 

[accessnoobster]

i did check the templates...but i've never used access.

i need step by step help or one of you access guru's to do it for me!!!

 

[Steve R.]

Though you are using Access2007, you may want to look at some of these books.

 

[accessnoobster]

would love to but i dont have that kinda time

 

[John Big Booty]

Given that you don't have time to read a book or do any study, I would suggest that you re-visit Luddite Lads suggestion and look at the templates that are available and work with one of those. What you are asking for is not something that you will whip up in half an hour, more so give your stated time constraints. More available templates here

 

[ByteMyzer]

I think we may have missed something else here, John. accessnoobster's post looks rather like a school assignment; possibly the reason for not having "that kinda time" is putting it off until the last minute?

 

[John Big Booty]

I think we may have missed something else here, John. accessnoobster's post looks rather like a school assignment; possibly the reason for not having "that kinda time" is putting it off until the last minute?

Having had another look at the OP I suspect you may be correct in your assumption.

 

[ByteMyzer]

accessnoobster, you have two conflicting statements. You say you'd rather learn how to do it, but then you say you need step by step help or for one of us to do it for you.

You also stated, when referred to some books for reference, that you don't "have that kinda time". Do you mean that you don't have time to learn? Or perhaps that you don't have time because this is a school assignment (as I rather suspect, given the nature of your initial post) and you've been putting it off until the last minute?

If this is indeed a school assignment, you should be able to approach your instructor for any help you may need. The point of these forums is to provide guidance and assistance where there is a genuine need, not to do students' schoolwork for them. If there is some specific aspect about the assignment with which you are genuinely struggling ("I try to sort the query like so-and-so, but it's doing such-and-such instead. Could someone help me figure out what I'm doing wrong?") then I'm certain people here would be glad to help. However, if you are asking for step by step instruction, this is what you should have received from your instructor in your lessons. If you are asking one of us to do it for you, you are DEFINITELY not likely to receive a positive response.