Need some advice on the database interface

[bulba]

hello,
I am currently working on the project where I need to create several tables that include the list of company's workers with corresponding training courses they had taken during different years and under different projects.
What I need is to create some kind of search funcionality that will allow users to enter the name of the worker that will display all the corresponding information about this worker i.e. the list of all the trainings with years and projects.
So I was thinking that I need to create 1) all these tables then make the SQL query that takes the surname and displays the corresponding information to the specific person. Do I need to use PHP or HTML to make the interface for the database with the search field?
Can anyone at least point me out the direction that I have to start with?
Sorry, if that is the easiest question but I am a complete beginner.

 

[Mr Smin]

Assuming you are using Access, your simplest option is to use it's form design tools which produce forms that run inside Access. You can get the job done without using any external tools.

 

[thingssocomplex]

I recommend the following create your tables an query(s) I would add a combo box with a list of trainer names which a user can select and click a button to see the information relevant to that trainer. All this can be done from inside access no requirement for PHP and HTML . If you the DB needs to be web based you could purchase a copy of Access 2010 which allows you to build web components and publish the database to the web using FTP.

 

[boblarson]

First things first. Let's get your table structure designed and THEN worry about the forms later. You need to get a good foundation first before you start talking about building the house.

What does your table structure currently look like? The easiest method would be to upload a copy of your database (with bogus data) so we can see. Based on your description, I would say that you probably do not have a properly designed and normalized database structure. This is important to have BEFORE going any further.