Advanced search

Database software OR Excel?

(3 Posts)
CaoNiMartacus Mon 24-Apr-17 20:41:49

Database experts! I need your wise counsel.

I've got a part time job at the "language lounge" of a university. One of the services they offer is a language meet-up/exchange program, in which learners get matched up with other learners for conversational practise.

For example, Diego who is a native Spanish speaker wants to practise intermediate English, while Ronnie, who is English, needs to improve his intermediate Spanish. These two would get matched up.

At the moment, the system operates with various bits of paper/forms that we have to manually go through to make matches. I'd like to take it digital, so we could store all the people's details online, and be able to match them without wading through piles of forms. So I would key in Diego's details, and a list of possible matches would pop up. The criteria are: name, age, nationality, native language, desired language, interests.

Is there a relatively simple (and preferably free) database program I could use for this? Or is there a way of crafting some sort of Excel spreadsheet to do it?

Thanks in advance for any tips!

codewaist Thu 27-Apr-17 18:07:02

If the university has access to Excel it probably has Microsoft Access which is a simple database program that could be used as you describe.

Alternatively as it's a university they will have access to Oracle, SQL Server and MySQL, why not sleek to the Computer Science Dept. They may have some students to help or could use its as a project.

You will need to run this by your Universities Data Controller as it will be covered by the Data Protection act.

Akandra Fri 28-Apr-17 10:41:26

Don't speak to your Computer Science dept, speak to your central computing services. Depending on the size of your Uni they may suggest Excel/Access (if they are small) or something even more suitable if they are large.

If you can avoid creating a bespoke database/spreadsheet and put it into a larger system, its always best to do this. This will give you ongoing support and ensure that when you as an individual move on, the system does not fall apart as no one else can manage to support it.

You need to think not just about the current DP but also about the new European laws coming in next year. This is another good reason for going to IT who will already be looking at compliance with these.

Join the discussion

Registering is free, easy, and means you can join in the discussion, watch threads, get discounts, win prizes and lots more.

Register now »

Already registered? Log in with: