+ Post New Thread
Results 1 to 4 of 4
How do you do....it? Thread, Using forms in excel in Technical; Hi all I have a feeling that the answer to this is going to be far more complicated that I ...
  1. #1

    Join Date
    Jan 2009
    Location
    Wiltshire
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Using forms in excel

    Hi all

    I have a feeling that the answer to this is going to be far more complicated that I realise but ...

    Datahandling is often a difficult topic to teach and not helped by software that makes a mountain out of a molehill (IMHO). I know that Access is very powerful but is often a sledgehammer to crack a nut.

    Most pupils can get on OK with excel but it's difficult to edit single records or to create queries and reports. It occurs to me that if you could have a nice 'form' tool that connects to an excel back end then this would overcome some problems. Something cool may even offer xml conversion, searching and queries. Something really cool may allow multiple users to access a single excel file (or maybe connect easily to a SQL server) fo that you can have multiple input.

    Has anyone ever seem anything like this?

    Bob

  2. #2

    Join Date
    May 2008
    Location
    Cheshire
    Posts
    299
    Thank Post
    49
    Thanked 27 Times in 24 Posts
    Rep Power
    19
    Hi Bobharding,

    Only one person can write to an excel sheet at one time. Multiple users can read the same excel sheet however. You could always convert the Excel sheet into a database (sighs, I know you don't want to), more so a server database e.g. mssql, mysql etc.

    Access can give a nice 'easy' front end if someone sets it up (i.e a form that pops up at the beginning to access premade queries, forms etc). Excel is also very good for queries.

    I think Access is as good as your going to get, as what you are asking is the actions of a database.

    Other than that, I don't think there's much else you can do.

  3. #3

    Join Date
    Jan 2009
    Location
    Wiltshire
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Using Forms in Excel

    Thanks for getting back Pashers.

    I suspect you're right. I guess that what I was looking for initially was a form designer for excel then maybe extending this to a piece of software that acted as a 'server' for and excel worksheet.

    Access does have forms of course but I'm worried that the 'database' as a single application doesn't seem very 'real life'. Basically the SQL route seems much better ultimately and I wondered if a simplified server would be possible ..... imagine pupils building a mock 'facebook' or media player application? Doing this in Access would be a real stretch but the concepts are not too outlandish.

    Ho hum - never mind - guess I'll keep looking

    Thanks anyway

    Bob

  4. #4
    p858snake's Avatar
    Join Date
    Dec 2008
    Location
    Queensland
    Posts
    1,490
    Thank Post
    37
    Thanked 175 Times in 151 Posts
    Blog Entries
    2
    Rep Power
    52
    Quote Originally Posted by bobharding View Post
    imagine pupils building a mock 'facebook' or media player application? Doing this in Access would be a real stretch but the concepts are not too outlandish.
    Not really, if you have the tables correct with the right relationships you can use the web section on the side (i believe its called pages or something) and build a very basic one. I did a very very basic one the other year in class that had a table for user details (eg: age ect ect) and then a table for friends (eg: Unique_ID, UserID1, UserID2) and had it show who is friends with who.

    Although having a local install of wamp/xampp ect on the local terminals and teach them mysql/sqlite/whatever and web design (php/html) at the same time would be alot nicer.



SHARE:
+ Post New Thread

Similar Threads

  1. design outlook forms
    By browolf in forum Windows
    Replies: 0
    Last Post: 9th May 2008, 04:26 PM
  2. Outlook 2003 Forms help
    By roo20487 in forum Web Development
    Replies: 1
    Last Post: 6th March 2008, 09:38 AM
  3. forms
    By beeswax in forum Web Development
    Replies: 5
    Last Post: 28th February 2007, 11:14 AM
  4. Forms not working in IE 6x
    By mark in forum Windows
    Replies: 1
    Last Post: 11th October 2006, 09:53 AM
  5. outlook/exchange forms
    By browolf in forum Windows
    Replies: 2
    Last Post: 12th June 2006, 12:42 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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