Problems on how to create a database

[Old_Trafford]

Hello everyone,

i want to create a MS Access database to log all the books/theses/brochures at a university laboratory. I am a beginner at access so i am going to post what i thought of doing:

--I want a main table that has everything: title,type, location, tags. When i make a report on that table i want to see everything that exists in the laboratory.

--I want a form that i can add a new entry to this table:



http :// imageshack.us/photo/my-images/577/form1t.png/

Except from the title,the rest(type,location and tags) should be chosen from a dropdown menu. I dont want someone to write a new tag arbitrarily, but only choose from the available. If he wants to add a new available tag, it should be added by pressing a button. The choices in these dropdown menus should be drawn from separate tables.

My questions are:

--1) How would a professional build this database?

--2) I have created a beginner database, with 1 main table that will be the database and 3 small tables that the content is added. When someone wants to add a new location that is not already stored in the small table, he should add something to the small table, so that it becomes available to the dropdown. Is that scenario feasible?

--3) How can i add a button that adds a new location to the small table and then adds it instantly to the dropdown menu?

I hope i am understood, because everything seems a little bit confusing.

Thank you for your time

[burrina]

Would you care to post a copy of the db for us to look at or some screenshots? Also a little more info about your db would be helpful. Have you setup the relationships yet?

[orange]

A general approach to building a database is provided in this free tutorial.

http://www.rogersaccesslibrary.com/T...lationship.zip

Good luck

[Old_Trafford]

http://dl.dropbox.com/u/4450410/Laboratory.accdb

This was my database. Its in Greek, i hope this isnt a problem.

I will take a look at that tutorial.

Thank you for your interest

[burrina]

Surely you must know people on here do not normally speak or can read Greek! Good Luck with your project.

[Old_Trafford]

I will translate and re upload soon, sorry for the fuzz