UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Database Interface Question    
 
   
bulba
post Dec 20 2010, 06:34 AM
Post #1

New Member
Posts: 1



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.
Go to the top of the page
 
+
 
Start new topic
Replies (1 - 1)
cwfitz
post Dec 20 2010, 08:55 AM
Post #2

UtterAccess Addict
Posts: 136
From: Georgia Coast (USA) Basically, I live in a swamp



Think about putting your data tables on the backend (or server) of the project and use an appropriate frontend (or client) to access the data. PHP (or Microsoft SQL, or even Microsoft Access) are all very appropriate for your data backend. Your frontend should be something easy for the untrained user to work on without any kind of formal database training. You can make a web-based frontend with (for example) Microsoft Visual Studio and the users will interact through their web browser (rather heavy for a beginner). Microsoft Access also makes an excellent frontend. Your 'search' functions will be on the frontend (with whatever tool you choose) and the user will 'search' for a record in a variety of ways (programmed in by the designer); typically through combo boxes or list boxes. If your relationships are well defined on the backend, the search should be fairly simple.

Every database dude has their favorite approach to this very standard project. For me, I would select Microsoft SQL on the backend and Access on the frontend (with ODBC connectivity), then expect howls of dissent from other DB gurus who have other preferences.

Happy developing.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 01:37 AM