Re: [libreoffice-users] compatibility with Microsoft Access

Hi :)
Sorry to say that Access is not compatible with almost any other
database program.  Even down to the sql language under the surface of
the Queries it is different from all the rest.

Access is also very restricted in what it can do and how it can be
used - for example it only supports single user input at a time rather
than being able to handle multiple users.  Some of it's restrictions
can be by-passed if you dig deep enough but it's probably better to
use something that is designed to be "the right tool for the job"
rather than to twist Access outside of it's comfort-zone.  If she
learns how to use Access that way then she will be amazed how easy it
is to use any of the others later in life.

However it is still good to learn.  There are key concepts and
generalities that are the same or very similar.  Those concepts are
often difficult for people to grasp.  It's possibly easier to
understand some of it if you have watched "The Matrix".


The main problem would be with trying to use any example files she is
given or that she builds on Access.

It might be possible for her to use Base to do some of her exercises
but most of it will take some initiative to adapt what they ask for in
order to fit.

For example Base is best when used with an external back-end but for
the exercises she will probably be better off using the internal
back-end.  Anything teaching about Access probably wont mention
back-end vs front-end at all - which is one reason why it might be
handy to have watched "The Matrix" (but only to get the rough idea of
what it's about rather than needing to watch toooo closely - mostly
the bit about the cat and the spoon).

Regards from
Tom :)


On 29 January 2015 at 13:45, lalitadatta <lalitadatta1993@gmail.com> wrote:
> Hi,
> My daughter's in need of Microsoft access for her homework - she's studying
> computer
> technology at high school, and she needs Access for coding.  Anyone knows if
> liber office should do the job?
> Thanks in advance.
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/compatibility-with-Microsoft-Access-tp4138053.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted