Facility Look-up Database Creation

[GeorgeW]

Greetings!

I'm hoping someone here might be able to point me in the best direction in order to solve my current predicament. Here's an overview of what I'm trying to do:



I work for a consumer packaging company, and I've been tasked with gathering a list of every facility we own and/or contract with, and putting this list into a database that anyone in the company can search through. No pressure huh? I've gathered all of my data, but I'm brand new to building databases - I want to learn how to do so though. Here is what my database needs to include:

• The ability to search for an individual record or return a set or records based on up to three different search criteria. Each record has 21 different items associated with it (facility name, address, hours, etc.)
• The ability to print and email a specific record.
• The ability to allow anyone to view the database, but not edit anything within it. This is a project where I control all of the data that goes into the database
• The ability to allow anyone to propose changes to the data via a form, which upon submission will send the request to me via email
• (Optional) The ability to interface with a sharepoint site if possible.

I have the general design done, but as far as adding the functionality above I'm pretty lost. Any help, tips, ideas, etc. would be appreciated.

Thanks!

-George

[amrut]

Have a look here http://www.databaseanswers.org/data_models/