Need guidance on proper database software for a specific use

USSiTeam
USSiTeam used Ask the Experts™
on
I have been requested to assist with the setup of a database for a new program at our client called  the "Job Training Center".

The function of the program is to collect information from employers as to what job openings they have. They will also collect information from individuals as prospective employees for these job openings. Then they will match up employers with the best fitting prospective employees.

So my question is what database software would be recommended for this purpose? I cannot even think of how to word their needs in a manner conducive to using a search engine. Those results usually just return database programs for managing employees as an employer, which isn't really what they need. I am leaning to Microsoft Access 2010 right now but that is mostly because they already own that software. If there is some software that is better designed for this use then I would like to look it over for a possible recommendation. Their budget severely limits them in the short term but I can always make a long term recommendation and just use Access for now if need be.


Any advice would be much appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Isn't there an issue of what development skills are available?
MIS Liason
Most Valuable Expert 2012
Commented:
Well if they have MS Access then go with that.
At the low price level, you really don't have that many options, because MS Access clearly dominates.

It is not really clear if you are using the term "search engine" in the correct context here, as this term typically refers to *Web* Search Engines like FireFox, IE, Chrome, Safari, ....et al.

But yes, you can set up an Access database to "Search" for specific information.

Author

Commented:
@peter57r

Yes that is indeed an issue. If there were better solutions than Access then I would also look into what support is offered with those solutions as I have a limited skillset with databases.

@boag2000

Yea I figured Access would have to be the way to go. I assume I would set up 2 seperate tables, one for employers and one for employee prospects, and then they could use query searches to scan for specific information present in those tables (i.e. all prospects with college degrees etc.).
 
When I was referring to search engines, I was indeed referring to web searches. I was googling and the like to see if there was any database software out there that was designed for this purpose already but I couldn't find any. This is partly due to the fact I couldnt think of any good phrasing for searching. Also I am unsure if there is a proper category for this sort of need. There are databases designed for Accountants or some form of Business Management but I saw no category that fits this scenario. Sorry if I didnt make that clear the first time. I thought I was more descriptive but I was rushing to get out the door to keep an appointment at 11:30 so I was distracted.
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
It seems that it needs to be made clearer what the overall purpose of this Database is supposed to be.

If you want a search engine, then why not just use your web browser?
It is not clear to me why a "Database" would also need to also be a "Search Engine" for the web, (Or even what would be done with the search results)
True Search Engine functionality will be extremely complex to blind especially "Into" a database, and even more difficult to do if you are new to Access/Coding...

Can you explain a bit more about this requirement with a bit more detail?

You can set up an Access database to search the web (via your web browser), or you can insert a web browser (control) into your Database application.
But again, anything beyond this will require some fairly complex coding.

...In any event, I still see Access as the best option...

Author

Commented:
The part about the search engine is completely seperate from the requirements of the database. I was just commenting on the fact that I tried to use search engines to better inform myself on what database program to go with. I was planning to go with Access but I didnt want to just simply assume Access was the best option without actually searching for other alternatives. I didnt find anything with my general searches and that is when I remembered I could ask the question here and get you experts to weigh in on the decision.

You confirmed my feeling that Access was the best choice and that is what I was looking for. I just wanted someone with more knowledge on the subject to give me their opinions.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<I was just commenting on the fact that I tried to use search engines to better inform myself on what database program to go with.>
Oh, ...OK, sorry I misunderstood...
;-)

On the design end, I suggest you do a bit more research.
The way I see it, you will need at least 4 tables:
tblEmployers
eID (PK)
eName
eAddress
...etc.

tblJobs
jID (PK)
eID (FK)
jTitle
jDescription
jSalary
...etc

tblJobProspect
j_pID (PK)
jID (FK)
pID (FK)
j_p_Date
...etc

tblProspects
pID (PK)
pFName
pLName
pAddress
pDOB
pEmail
pPhone
...etc


JeffCoachman

Author

Commented:
Might I ask what the difference is between the JobProspect table and the Prospects table?

The other tables make sense, I am just confused on what differentiates a Prospect from a Job Prospect.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
My termination may have been off because I did not know if you meant a "Job prospect" was the Person, or the actual Job itself...

In any event
Because one "Person" may be searching for many "Jobs", ... and also, One Job may have many people interested in it, you need a Many-To-Many table to sit between them.

For example:
One Student can be enrolled in many Classes, and also one Class can have many students.
So a Student/Classes table is needed.

Make sense...?

Jeff

Author

Commented:
I understand. Thanks for the help!
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
;-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial