[libreoffice-users] Re: database

Am 20.04.2012 22:07, Elizabeth Lawrence wrote:
> Hi Nick,
>
> I'm using Mac OS X 10.5.8. I am trying to start a new database and
> trying to click on use Wizard to create table. It doesn't click properly
> and the suggestion of creating a table using the Wizard vanishes. I have
> to confess I haven't used Libreoffice before, but my Boss suggested it
> for a database and showed me how to start off. I have used a database
> before but I really can't get on with this at the moment. I'm in a big
> sulk at the moment and have uninstalled Libreoffice, working all weekend
> so I'll have another go next week. If you can think of anything that
> might get me going, I would be really grateful.
>
> Liz
> On 20 Apr 2012, at 19:08, Rev. Nick Sharp wrote:

How to create a simple, editable address list without wizard nor Java 
components:

File>New>Spreadsheet.
Put the field names in row #1 (Name, Surname, ZIP, City etc.)
Fill out the table below the header row with your actual data.

File>Save As...
Create a new directory for the file you are going to save and go to that 
directory.
Enter some file name
File Type: dBase (*.dbf)

Close the spreadsheet.
File>New>Database
[X] Connect to an existing database
Type: dBase
Specify the _directory_ where you dropped your dBase file.
[X] Register the database (for later use in serial letters)
Save the database (*.odb file) somewhere.
The database (*.odb) has nothing more than one table so far. Open the 
table and check if your data are alright. The database table reflects 
the contents of your *.dbf file in its dedicated directory. More *.dbf 
files in the same directory would add more tables to the database.
Close the table and its database.
######### end of set up ########

Start a new letter in Writer, hit F4 for the data source window, in the 
left pane of the data source window, browse your database --> Tables --> 
your table
Drag the grey column headers into your letter. This will add place 
holders for the name and address fields. Notice that you can edit the 
data in the data source window (F4) without opening the database.
When you are going to print your letter you will be prompted to print a 
serial letter. The printing dialog for a serial letter lets you select 
all the table data or only selected row(s) of the table. You can also 
print all the letters into a new Writer document instead of a paper printer.


--
For unsubscribe instructions e-mail to: users+help@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