Sure, it's possible to put together a database for your employer, but I wouldn't recommend MS PowerPoint. MS Access would be more appropriate and accessible. You may be a bit out of your depth if you've never designed a database before, but it can be done. I recommend that you do some homework, like "Database Design for Mere Mortals" (sorry, I don't remember the author and I'm not in the office) and the "Access Bible." In a pinch, you might be able to do it in Excel but I wouldn't rely on it.
As for fitting a database for 40 residents on a single diskette, that would be very difficult. Why doesn't your employer buy one of the ready-made databases for recording medical/personal data? That would probably be cheaper in the long run than having you reinvent the wheel. Avital ----- Original Message ----- From: "Joan Whitfield" <[EMAIL PROTECTED]> To: "Lace-chat" <[EMAIL PROTECTED]> Sent: Friday, August 15, 2003 9:26 AM Subject: [lace-chat] Database help needed Hello all you knowledge-ful weavers of dreams. I have a nightmare to unravel. I made the mistake of showing my employer a powerpoint presentation of the staff structure of the care home where I work, which I'd been playing with at home to practice (it's a while since I learnt powerpoint) and he now wants me to create a database of all the residents with various details, which is fine, but then he wants to add spreadsheets with lots of medical and required care information for each resident, to be accessed at the touch of a key. There are 40 residents each with several pages of spreadsheet. He wants to be able to pull out the general details of a resident (name, age, diagnosis, etc), keep pressing enter to get each page of spreadsheet information, but still have the filter facility of a database programme. He also thinks all this information can be stored on a floppy disc, but that's a different issue. I am totally out of my depth here. Can this be done? If so, how? All help will be gratefully received and rewarded in heaven. Joan from Yorkshire To unsubscribe send email to [EMAIL PROTECTED] containing the line: unsubscribe lace-chat [EMAIL PROTECTED] For help, write to [EMAIL PROTECTED]
