Please help me find answer for question 2

florida2001 · 03 Apr 2014

Hi,
I'm desperately trying find the information for my school discussion, I don't want anyone to do homework for me, but I'm seriously do not know how to answer this questions. Access is not my best friend.I found answer for nb 1.which I believe is -(determine the purpose of database, find and organize information, divide into table, turn into items into columns, specify primary key and set up relationship. But I have no clue what number 2 is asking?? Please help!!!

Scenario: Think of an opportunity in your personal, academic, or professional life in which you could use a database (ordering supplies, tracking inventory, maintaining a customer mailing list, organizing a library, etc.). Answer the following questions:

1.What guidelines would you use for designing your database and tables?
2.Who would your end users be and how would you accommodate their needs through your design?

3.Explain how you would use filters or queries. What's the difference between a filter and a query?
4.What kinds of reports would you run? Why?

UsernameIssues · 03 Apr 2014

In the context of the exercise, I think that the answer to question number two is simply whoever you want it to be. There is no wrong answer, but the answer has an impact on the other questions.

In other words, if you answered number 2 as...
All of those residing in a nursing home wishing to track their meds
...then the that target audience might require different reports (question 4) than if your answer had been
All members of a kindergarten class tracking rainy days

See what I mean? Just pick a group of people for this hypothetical project.
Maybe one of these would work for you too:
Those ordering supplies for a small office.
Those tracking giving to a non-profit organization.

Ranger4 · 04 Apr 2014

Database are used by anyone who needs to have a lot of data on things like people, addresses, phone numbers etc. Companies use them to track customer orders, what each customer ordered, how many etc.. Information on stock control & reordering can be programmed if required.

I use Access to keep a daily record of weather information, from a private weather station, which I enter manually in the format I want. I use a Form to enter 59 different daily readings. I then use a query that runs on the month dates & it will give me the information, such as max temp, min temp, rainfall etc. for the month in question.

When setting up an Access Database you start by designing your Tables & this is probably one of the most important parts. Your database may only need one table or it may need many tables. You can create a Relationship between the Tables, so one Table will check on another Table during data entry if required to see if some entered information is correct & it wont allow an incorrect entry if it's not.
Forms are used to enter information & usually have an entry for each field in the Table that the data is being entered into.

Queries are very powerful tools & in a well constructed database & can be used to extract information from the Tables, such as how many items were sold in a particular product etc.

Filter can be used to limit the amount of data or to only provide what you may require when extracting information in a query.

Reports are used mainly for printing any particular details that may be required & can be tailored to suit the requirements.

I hope this helps you. Of course I have only been fairly brief & tried to give you a summary. To cover database construction & operation in detail would run into page & pages. When I first started using Access in the early 1990's Microsoft supplied a manual that was over a inch thick.

florida2001 · 04 Apr 2014

thanks a lot it helped :))

caperjack · 06 Apr 2014

excellent posts,

lI ike this signature
It is said that "Necessity is the Mother of Invention".
But sometimes an Invention becomes a Necessity

are you Bill Gates ,lol