Hello all, I need some help. I'm new to creating databases. I have only recently developed interest in them when I discovered how I can structure my information into database format and use it to computerize and simplify my paperwork flow. A little background, I'm a nursing student. If you're familiar at all with the field, you're aware that a fair amount of it has to do with paperwork. At the least, creating a table like document with select points of interest for medicine, lab values, diagnostic results pathophysiology etc. for each patient under my care. I have figured out how to take the data I gather, and convert it in to tables with the proper formatting to display the data the way that I need to for submission.
With that said I have a few questions about methods of manipulating data: 1. When I create a report, I may spend an hour or more getting the report so that it formats my data the way I want it to display. I choose to have my report set to display the results of a query. If I wish to create another report looking at different aspects of the data I would do this through another query (ie scenario 1: query me all apples in report format A. scenario 2: query me all oranges in report format A) My problem is once I create the report that took an hour to do. I don't want to recreate the entire report pointing it to the second query for displaying in report format "A". I want to be able to At any rate copy it and paste (duplicate the report template) and then change the data source from what it is displaying to data B but use the duplicated report template. from query 1(apples) to query 2 oranges. Is this possible to do, or must I create each report manually through the wizard and point it to the data source I want? 2. Is it possible to undelete a table you have already deleted? :-) 3. Is it possible to import a table into base. For example if a fellow student is keeping track of another body of data, and I wish to import her work, how would I import her table data to my database? 4. When I am in the Forms section, I have found that the default fields the wizard creates aren't that useful for the type of form I am creating now. I need the flexibility of a text box. The problem is the text box seems not to support a human readable label. So if one field is for patient history, and another is for comments, I wouldn't know it unless I remembered. How do I put visible labels on my text box fields so that when I am working with the form I can see the title of the fields? 5. Also, how do I create the fields that the default wizard creates. I can insert text boxes and other objects in the form but I can't find anywhere that handles the fields the form wizard creates. Any insights you could provide would be much appreciated.... Thanks in advance... John, -- Patience yields far greater results than brute force or rage ever could so relax......it's just life !!! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
