OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

:?: "Micro$oft Access"-similar program?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
macfreak109
Newbie
Newbie


Joined: 31 Jan 2005
Posts: 4
Location: Luxembourg, Europe

PostPosted: Mon Jan 31, 2005 6:38 am    Post subject: :?: "Micro$oft Access"-similar program? Reply with quote

Hi there!

I'm a teacher in a public school in Luxembourg (Europe) and for the moment, we are inquiring whether we can replace MSOffice with an OpenSource product like OpenOffice. However, as our classes do need databases in their daily tasks, I was wondering if there was a program which could merely replace Access'es GUI to the database.
Now, I know of all the existing solutions like mySQL, postgreSQL, etcto add a DB on the system (that's not the problem) but what I'm missing here is the interface to the DB through Oo. The program needs to really replace Access (with all features like table layout, form design, query manager, relationships, etc) in order for us to be "what we're looking for". Can anyone point me out to sources where I could find a solution...I've been looking forward to this moment all my computer life Very Happy

TIA for all the support I can get.

Best regards.

mAcfreAk.
Back to top
View user's profile Send private message
RonIA
Super User
Super User


Joined: 28 Sep 2004
Posts: 925
Location: Iowa, USA

PostPosted: Mon Jan 31, 2005 5:21 pm    Post subject: Reply with quote

If you can be a little bit patient the OpenOffice.org version 2.0 is going to be available in March 2005. Version 2.0 will include a database with much of the functionality of Access. Tables, Forms, Queries, Reports, and so on.

I don't have all the details, but here is a link http://marketing.openoffice.org/2.0/featureguide.html that can tell you much more.

Hopefully this helps.

Ron from Iowa, USA
Back to top
View user's profile Send private message
macfreak109
Newbie
Newbie


Joined: 31 Jan 2005
Posts: 4
Location: Luxembourg, Europe

PostPosted: Mon Jan 31, 2005 10:58 pm    Post subject: Reply with quote

Hi Ron,

Thanks for your answer...that's what I've been waiting for. I'll feed these informations to the management in the meantime. As this migration will take place during this summer, March will be a great time to test!

Thanks again! Very Happy Very Happy

mAcfreAk.
Back to top
View user's profile Send private message
dagenop
Newbie
Newbie


Joined: 31 May 2004
Posts: 2
Location: Ørsta, Norway

PostPosted: Wed Feb 02, 2005 1:59 am    Post subject: Reply with quote

Hi there macfreak109

At the moment I'm finishing my last year in school before i go of to study further. (13th year). As one of my subjects I have chosen system development wich I now have for the second year.

In my school we are doing an "experiment" where most of the programs on the school have been switched out with open source alternatives. This means that every student on this school (aprox. 550 students) are now using openoffice.org instead of Microsoft Office, most of them also does this at home.

We as a computer class are working with MySQL and OpenOffice.org in the database section of the class for the second year in a row now. And i believe we are the first school in Norway to do this.

In the start we had a lot of small bugs and problems, but due to a good community and a eager teacher we have solved most of the problems we have encountered, and this solution is actually working very well now.

Personally I very much like the fact that we are working with MySQL instead of Access as I see this as much more relevant when it comes to webprogramming etc.

If you as a teacher is looking for an alternative to Access Openoffice will most certainly do the job very well. However, I am in the opinion that this is more stress and trouble than good old MS, however, when you get over the first hilltop, things starts to roll quite smoothly.

I say go for it, but be prepared to do a lot of work with the project.

(This might not have been very relevant to your question, but thought I could post my opinions as one of the "test subjects" in this project here in my school Smile
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
macfreak109
Newbie
Newbie


Joined: 31 Jan 2005
Posts: 4
Location: Luxembourg, Europe

PostPosted: Wed Feb 02, 2005 2:42 am    Post subject: Reply with quote

Dear dagenop,

Thanks for your reply. I really do appreciate that this solution has already found appliance in schools. As for the problems, we are fully aware that the migration won't be a 2 hour operation and we are prepared with knowhow and entusiasm Smile

We will wait for the new 2.0 version (cf above) and then start our testing in 2-4 classes hoping that the migration will be a success. If yes, our school will probably switch over in 2-3 years from MS to OpenSource (finally) Razz

Best regards.

mAcfreAk.
Back to top
View user's profile Send private message
Lazy-legs
Super User
Super User


Joined: 21 Jul 2004
Posts: 564
Location: Århus, Denmark

PostPosted: Wed Feb 02, 2005 3:31 am    Post subject: Reply with quote

Quote:
We will wait for the new 2.0 version (cf above) and then start our testing in 2-4 classes hoping that the migration will be a success. If yes, our school will probably switch over in 2-3 years from MS to OpenSource (finally)


And when you have migrated, don't forget to tell us about your experiences, problems, workarounds etc. Very Happy I'm sure other users who consider switching to OOo will find them useful.

Kind regards,
Dmitri
_________________
http://code.google.com/p/writertools/
Back to top
View user's profile Send private message Visit poster's website
macfreak109
Newbie
Newbie


Joined: 31 Jan 2005
Posts: 4
Location: Luxembourg, Europe

PostPosted: Wed Feb 02, 2005 4:55 am    Post subject: Reply with quote

Quote:
And when you have migrated, don't forget to tell us about your experiences, problems, workarounds etc. I'm sure other users who consider switching to OOo will find them useful.


Sure thing! Our report (which we'll have to write anyhow) will definetly be published here! So...stay tuned for more action Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group