Allow Users to Access Backend Data

[lauriphi]

Im totally new at all this stuff, so any help is appreciated.

i have a database with one table that has many different attributes and almost 3000 records. this is all i have done, i have simply been loading in all of the data to the table, now that that is done i need to allow users to extract the data.

so, what is the best way to build a front end that allows the user to easily extract data from the database? ideally, i would like to have some sort of front end that would have a text input window where they could search for records matching attributes in the table that match or are close to the text they type in, with some additional options for honing down the search terms with dropdown menus, radio buttons, etc.

the problem is i really havent a clue on how to do that stuff. can anyone just give some general, beginner type steps for things i should be doing to create that "front end" i am visualizing. THANKS!

 

[jrjr]

Wow, you have a ways to go!

Start with a new database and go to file/get external data. Link the tables in your existing database to your new database. Make a copy of your existing database first and work with that so nothing bad happens to your data. You can always make another copy and start over if it gets damaged but you will need the original intact.

Then you can search the forum here for information on constructing forms to allow your users to input or modify data as needed. There is a wealth of information here, it will just take some research on your end to find it and implement it.

Best of luck in your endeavor and dont be afraid to post back here with specific questions.