bob4apples wrote:I am NEW to using AppleWorks on an old iMac. (Belongs to my parents) I am proficient on a PC using Excel, but have a question (or a few) about Apple.
Hi Bob,
Although I'm still using AppleWorks for it's database capabilities, I wouldn't recommend anyone start using the application at this time. AppleWorks development effectively ended in 2004 (some would say much earlier), and the product was declared to be at End of Life about a year later. While it will probably work fine on your parent's old iMac, AppleWorks is becoming increasingly incompatible with each update to the Mac O, and there seems to be a pretty strong consensus that it (and other vintage applications that depend on Rosetta) will not run at all under OS X v10.7, expected to be released sometime this year. Should your parent's old iMac be replaced by a new computer next year, that would be the likely OS version supplied with it.
I have created a template spreadsheet; saved it; copied & saved as a new name. Can I create another "page" or "tab" as in Excel to house an item list (or database) of "parts"?
No, but you can create a second "View" that takes you to the part of the spreadsheet where your "parts" table is located.
The application of which (if you understand how I want to use this info) is to do a "Takeoff" of items from a set of blueprint drawings using the spreadsheet. I would like to establish a LIST of all possible items available to be used as a Master Inventory List. The idea is to be able to cut/paste items from the Master List into the Spreadsheet.
If you are transferring via cut/paste, it would be just as easy to place the "parts" table into a separate document. Open both, then toggle between them using the Window menu, or by pressing command-~ (hold down command, tap the key with the tilde (~), located above the tab key on the left of the keyboard). This will toggle between two open windows in the same application, or rotate among more than two windows open in the same application.
Regards,
Barry