Uses ..

Flat-file databases (File management systems) are common in integrated packages, and may be referred to as "personal file systems". Many uses are possible.		These include; Phone lists Car prices Real estate listings Time recording
Names & addresses: Fishing club
Requirements Phone list for ringing members to notify them of the clubs activities Subscription list to check who has paid their subscriptions List of names for making up rosters.		Sample record structure Last name, Text, 30 First name, Text, 20 Phone, Text, 20 Subs paid, numeric, 8,2, (max. 9,999.99 ) Date paid, numeric (date) Notes: Phone is generally left a text to allow for special characters to be used , eg. (06) 123-4567 or word numbers Date is (usually) a special numeric field maintained by the database. Advantages Updating data Addresses, phone numbers easily changed. Subs updated Selection data List of members who have yet to pay subs. Multiple reports phone list, members list Easy integration integration with a mail document for members mailout.
Personnel records: variety retailing company
		Notes: Weekly pay is a formula field. Generally it is placed on the form to enable the person inputting the data to verify the reasonableness of Hourly rate and Hours per week. In most databases where fields are "calculated" from other fields they are placed on the form but NOT in the database. Advantages Updating data Addresses, phone numbers easily changed. Subs updated Selection data selecting employees in a particular store or department Multiple reports Payroll calculation report, phone list, personnel detail, Store/department personnel Easy integration merge with document for staff newsletters.

[Rev 27/06/00] 12/8/1997 © 1997-2000 V/2-Com (Verhaart), P O Box 8415, Havelock North, New Zealand.