Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Please help me find answer for question 2


03 Apr 2014   #1

64bit windows 7
 
 
Please help me find answer for question 2

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?

My System SpecsSystem Spec
.

03 Apr 2014   #2

W7 Pro SP1 64bit
 
 

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.
My System SpecsSystem Spec
04 Apr 2014   #3

Windows 7 Home Premium 64 bit sp1
 
 

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.
My System SpecsSystem Spec
.


04 Apr 2014   #4

64bit windows 7
 
 

thanks a lot it helped )
My System SpecsSystem Spec
06 Apr 2014   #5

win8pro 32 bit win 7Ulitmate 32 bit
 
 

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
My System SpecsSystem Spec
Reply

 Please help me find answer for question 2




Thread Tools



Similar help and support threads for2: Please help me find answer for question 2
Thread Forum
Solved let us see who know the answer of this question? Very EASY Chillout Room
An answer to a question in another Thread. Hardware & Devices
Can't seem to find the answer BSOD Help and Support
Hey i need somone to answer my question General Discussion
Canít find a definitive answer; clean install/upgrd ver Installation & Setup

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 03:12 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33