Hi :) Yes, sadly SQL is not as standardised as was originally envisaged. Each different application add their own range of extra features or short-cuts or find some "better way" of doing particular instructions.
It's quite different from "ODF 1.2 Extended" where each different program tends to have exactly identical versions of the "Extended" and only a few try out a few different ways of doing things. Also programs that use ODF tend to have an option to choose to use the more standard ODF 1.2 or even go back to the ISO standard ODF 1.1/1.0. Plus when using ODF 1.2 Extended for a specific document and then open that document in a program that only has ODF 1.0 the document is still handled fairly properly. By contrast Sql is a completely messy nightmare. Access does do a particularly impressive job of being pretty much the least compatible with anything else - even being fairly incompatible with other MS database programs. Access has other problems such as not having any separation between the way database-designers or builders see it and the way normal office workers see it. So normal office workers are often slightly petrified of using databases because they often find themselves suddenly dropped into design views and stuffing the whole thing up by accident. It does allow Forms and Reports to try to protect normal users from being exposed to tooo much complexity but those are only viewable in the entirely unfamiliar Access User-Interface and all the buttons and such could easily be completely non-standard compared to the way the rest of the OS operates and may even be broken or become broken over time. Access is not like Base where look-up Forms Reports can be created in Writer or Calc allowing the office workers to stay in familiar User Interfaces and safely away from anything to do with design elements. To me it's always been quite shocking that Base is marketed as being the equivalent of or a suitable replacement for Access. Base, even as it is at the moment, is sooo much more advanced than Access could ever hope to be. Regards from Tom :) On 29 January 2015 at 16:48, jomali <[email protected]> wrote: > It depends on what you mean by "coding" and what the requirements of the > course are. If she is to be coding in VBA, only Access will do. If she will > be required to use Access on tests, only Access wil do. Even the SQL that > Access uses has some differences from the SQL used in Base, since Base does > not use the Jet engine that Access uses. The reporting system in Access is > quite unique, and learning the Libreoffice equivalents would be confusing > to a beginner. > > So, sadly, it looks like you'll have to use Access. > > On Thu, Jan 29, 2015 at 8:45 AM, lalitadatta <[email protected]> > 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: [email protected] >> 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: [email protected] > 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: [email protected] 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
