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
florida2001

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
UsernameIssues

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
Ranger4

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
florida2001

64bit windows 7
 
 

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

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
Thread Forum
WDS - Error Problem Can't Find Answer
I just upload a image to the server and it work fine, now I upload a different image and computer system to the sever and now it given me an error. After syspreping it and getting it ready I start the upload to the server but after a time I get and error saying, "There is not enough space on the...
Network & Sharing
let us see who know the answer of this question? Very EASY
Hello everyone Let us see who can give us the correct answer for this Q? What is the thing that is similar to half of orange? :):):)
Chillout Room
Can't seem to find the answer
I had a fatal system error BSOD yesterday, and cannot find any reference to it on the web, so I figured I would ask here. The BSOD read as follows: STOP: c000021a {Fatal System Error} The Windows Subsystem system process terminated unexpectedly with a status of 0xc0000006 (0x776d5bd4...
BSOD Help and Support
I got a good question, to which no one seems to know the answer too!!
I was hoping someone could help me, I am trying to do something so simple, but it's infuriating how complicated it appears to be. I simply want to Change Windows 7 Icon Login/ Welcome Screen and Change it to the traditional Login:_________________________ Password:_________________________...
Customization
Hey i need somone to answer my question
Ok am ready to update my computer to window 7!, i got Window Vista Home Premium, and i want to buy window 7 home premium, so am not sure if i buy the window 7 home premium update or the full window 7, the update is cheaper 120$
General Discussion
Canít find a definitive answer; clean install/upgrd ver
Has it been determined if you can use a valid Vista disk to validate a clean Win 7 install from an upgrade version? If that isn't clear; can I do a clean install on a formatted HD with the Win 7 upgrade version by inserting at some point, my original Vista disk? Thanks Roll
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 22:41.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App