Re: [libreoffice-users] Any Manuals available for Spreadsheet and/or base, ?

Hi :)
Sorry i meant to follow-up with soemthing for Calc but got distracted.
 It's better to follow decent guides rather than my confusing
ramblings anyway.  The official guides are here
https://wiki.documentfoundation.org/Documentation/Publications
The wiki does have other resources such as the FAQ
https://wiki.documentfoundation.org/Faq
although the Calc section is still being worked on, i think.  The Base
section was the first one completely finished! :)

Also video tutorials might be more helpful.  There is a good series of
"Spoken Tutorials" being produced through funding from the Indian
Government at the moment.  The English in them is top-notch and they
are very careful to ensure a very high level of quality
http://www.spoken-tutorial.org/list_videos?view=1&foss=LibreOffice-Suite-Calc&language=English

Regards from
Tom :)


On 20 November 2013 10:35, Tom Davies <TomDavies04@yahoo.co.uk> wrote:
> Hi :)
> There is a Handbook for Base.  The guide itself 'only' has the first
> couple of chapters but each of those chapters is larger than manuals
> so they might well be exactly right for what you need.  Database
> programs are much more complex than something like Writer.
>
> A database program has 4 components in much the same way that
> LibreOffice has about 6 modules/apps/components.  In LibreOffice you
> might use Impress for doing presentations but it's probably not the
> best tool for writing letters or drawing objects.  The 4 components of
> a database program are
> *  Tables = these contain data in something that looks a lot like a
> spreadsheet.  Generally it is best to have your data in an "external
> back-end".  That means a separate program that you seldom open or do
> anything with.  Like a sock-draw you just keep things in it.  Unlike a
> sock-draw you don't have to open it to get things out or put them
> back.  A Calc spreadsheet could be a back-end but there are usually
> programs that are designed for the purpose.  Calc is for something
> else.
> *  Queries = These do calculations, sort the data, apply filters,
> bring data together from different tables.  They do NOT create a
> duplicate of the data.  They just look-up what's in the table and act
> on that.  it's like looking in through a window.  if a light is
> switched on you see that happen through the window but it's not the
> window itself that switched the light on and the window doesn't
> contain a duplicate of the light-source.  This is the main function of
> the database program.
> *  Forms
> *  Reports
> These last two are the way a normal user sees or uses the data.  it's
> only the designer who would look at the Queries.  Base allows you to
> use Writer to make the Forms and Reports so that normal users can stay
> in familiar territory.  A Form might show one of the addresses in your
> address book and show their photo alongside (actually i have never
> quite managed to do this but i think others have).  Forms and Reports
> can access the back-end data directly but to make your database more
> robust and flexible it is better to make them take the data from a
> query.
>
> Regards from
> Tom :)
>
>
>
> On 20 November 2013 08:39, Ady <ady-sf@hotmail.com> wrote:
> > > To Users: I have not used either the Spreadsheet nor the Base parts of
> > > Libre office, as I do not know how to.
> >
> > I am not sure if a user with no prior knowledge at all can actually
> > use the current LibreOffice guides by himself without at least some
> > additional guidance.
> >
> > In any case, take a look at
> >
> > https://wiki.documentfoundation.org/Documentation/Publications
> >
> > which includes guides for Calc and Base.
> >
> > Regards,
> > Ady.
> >
> > --
> > 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