×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

MySQL database and "front end"

MySQL database and "front end"

MySQL database and "front end"

(OP)
Hello

I am doing some work for a small family history society. There are thousands of documents which they'd like users to be able to search for.

At the moment I have a large spreadsheet with the information :

ID Number
Year
Name
Surname
Document name (hyperlink)
Town/District
Reference

I know that a proper database is the best way to go but Access is all I've created before. Can anyone recommend anything, perhaps with a front end that will make it easy to add further details?

And then there's a search form to query the database and present the answers in a web page.

Sorry if this seems a bit basic, but this is something new to me and it's over my head. I need a program which hand holds.

thanks

thank you for helping

____________
Pendle

RE: MySQL database and "front end"

You could easily do this with a content management system such as WordPress and Drupal. You can install this to your own server or find many hosts that offer ready-made instances.

A CMS will allow you to create a custom content type or custom fields to record this data. There are options to import tabular data, like your spreadsheet, to quickly generate searchable records in the CMS.

The further benefit of using an established CMS is that it has user management built in. So you can assign certain individuals to edit/manage content.

RE: MySQL database and "front end"

(OP)
Excellent, thank you.

I hadn't thought of a CMS, I just assumed that a database was the way to go.

thank you for helping

____________
Pendle

RE: MySQL database and "front end"

Conveniently, a "MySQL database and 'front end'" is a WordPress or Drupal CMS.

Even Microsoft Access can act as a front end to MySQL tables. But it won't offer a web page as easily as WordPress/Drupal.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close