Re: [libreoffice-users] Re: Converting Microsoft Access to Libre Base

Hi :)
Thanks! :)  Ahh, so it's kinda a sub-set of what i understand as
"Queries"?

It's just when you view the Query in table view rather than viewing it as
Sql or the nice gui way of building up filters, formulae and such.


In Base i think Forms and Reports can be built in Writer, or Calc.

So, people using those Forms and Reports are presented with a familiar
environment and can do useful things such as simple re-arrangements and
tweaks or even fork them into different layouts (err, eg using "Save As .."
and give a new name) to do different things.

It protects the users from unfamiliar database design tools that they could
accidentally use to damage the database in all sorts of ways.

Annoyingly i think Writer or Calc Reports kinda don't allow people to enter
new data so proper Forms and Reports might need to be built within Base for
that.  Base has wizards for all sorts of things.  I'm never sure whether
it;s better to use wizards or avoid them.

Regards from
Tom :)



On 13 August 2014 13:21, Werner <wernerfbd@gmx.ch> wrote:

> On 8/13/2014 13:47, Tom Davies wrote:
>
> > Hi :)
> > Ahh, i take it that "View" is the new name for "Queries"?
> I don't think so, at least not in SQL terms.
>
>
> http://www.w3schools.com/sql/sql_view.asp
>
> http://en.wikipedia.org/wiki/SQL see Queries section
>
> Werner
>
>
>
> --
> 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