My access is required to remove existing or make up completelynew lines but mostly it involves altering the content of 1 to 4 Fields only, and to get different outputs.The outputs used are in 9 types 6 in different mini-spreadsheet layouts from 3 to 15 different columns and all the 50+ lines 1 form that includes all the individual's details, i.e. phone numbers e-mail addresses, delete members add new members change addresses change subscription details which occupy 4 columns and to get outputs. I need to access records quite frequently, weekly and monthly at least to change anything and everything:, e.g. I am using it for a membership database with around 36 columns and over 50 lines.Įach member's details is in a line.

Looks and works like a spreadsheet and does a lot more beside which is important. Why? The genesis of this particular tutorial database came from an email at am looking for an alternative to Lotus Approach which is a database in their own language.

You can distribute it and/or modify it under the terms of either the GNU General Public License, version 2 or later ( ), or the Creative Commons Attribution License, version 2.5 ( ) or later.Īll trademarks within this guide belong to their legitimate owners. This document is Copyright © 2007 by its contributors as listed in the section titled Authors.

4.4 Using the query designer to generate these queries.

4.3 All together there will be seven queries.

4 Now we want to create some more forms and reports.

1.3 Publication date and software version.

Openoffice base templates