+ Post New Thread
Results 1 to 4 of 4
General Chat Thread, Making a database - general query in General; MY other half has been asked to "make a database" at work, now seeing as she's had no training or ...
  1. #1

    Join Date
    Mar 2007
    Location
    Central Scotland
    Posts
    829
    Thank Post
    12
    Thanked 8 Times in 8 Posts
    Rep Power
    18

    Post Making a database - general query

    MY other half has been asked to "make a database" at work, now seeing as she's had no training or experience in doing so she's assuming that they want it done in MS access.

    However they've now said that they want to be able to edit, add, remove details as and when they see fit, use it in mail merges but have it easy to use (hinting at a front end).

    Surely this is beyond "make a database" and would really be needing a developer of some kind to do? They way my good wench described it to me they want it to flag up all sorts of information depending on who you click on - it's more of an application accessing a database than anything straight forward! eg if you click on joe bloggs name - it'll tell you what organisation he works for and list alternative contact people etc. and projects he's worked on in the past.

    I've told her to get them to list everything they want to do with this database as in all honesty I think it's the usual case of what the user wants being far removed to what their work can offer as they don't have the expertise or software available to do it.

    Thoughts anyone?

  2. #2
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    33
    As you say, get a full list of requirements.... then find something on Sourceforge that'll do it for nowt.

  3. #3

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,710
    Thank Post
    1,784
    Thanked 2,170 Times in 1,605 Posts
    Rep Power
    770
    Retired DBA of over 15 years experience here...

    Your other half is being asked to write an application which requires a database behind it.

    As in any application, you can't do anything without a full spec of what is required and an understanding of the tools you'll use to create it. If she has never used relational database tools like Access and isn't being given time to to learn, I'd stay away. It's beyond her expertise to design and build quickly and accurately as she'll be learning about the tools while she is doing it.

    If her employer is prepared for her to learn as she writes, and accept that it won't have everything they require immediately go ahead. She needs to make sure that they fully understand this first.

    Access is designed to do the kind of job she's being asked to do, but she is probably not the person to do it!

    Incidentally, mailmerge is the least of her worries - that can be hung off access as easily as it can from Excel.
    Last edited by elsiegee40; 21st January 2008 at 09:32 PM.

  4. #4

    Join Date
    Mar 2007
    Location
    Central Scotland
    Posts
    829
    Thank Post
    12
    Thanked 8 Times in 8 Posts
    Rep Power
    18
    Cheers peeps I had the impression this was something that was growing legs quickly and frankly she was being screwed over about.

SHARE:
+ Post New Thread

Similar Threads

  1. Query of existing query data in PHP
    By markwilliamson2001 in forum Web Development
    Replies: 5
    Last Post: 5th October 2007, 08:43 AM
  2. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  3. General advice for the new guy
    By Blind in forum Windows
    Replies: 29
    Last Post: 1st August 2006, 05:56 PM
  4. Recycling and general eco-friendliness
    By pete in forum How do you do....it?
    Replies: 16
    Last Post: 19th May 2006, 07:59 PM
  5. BSF in General - Kent in particular
    By pcprofessor in forum Windows
    Replies: 0
    Last Post: 26th March 2006, 06:16 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •