If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Problem designing tables: Too many fields
So, would you say its harder doing it in Access than in Excel? Because for me it sounds way harder in Access! PLease let me know what you think, because I am lost! |
#12
|
|||
|
|||
Problem designing tables: Too many fields
Just download the following template from the Microsoft site. It will
already have built-in forms and reports and be ready to use. http://office.microsoft.com/en-us/te...CT011366791033 |
#13
|
|||
|
|||
Problem designing tables: Too many fields
I don't know if you want them to see a weeks worth - and am confused because you actually show 8 days on your form example - very strange - could you please Explain that Ok, first thank you very much for your help....I think im getting somewhere. That "form" that I described in my first post, was a "copy-paste" of an excel file that the employees are using right now for Expenses Report. Your 'entry' form would probably NOT have multiple dates shown - but give the user the ablility to enter each days lodging and meals seperatly. You then could show all the information for a particular period on one form if that was needed. This sounds confusing to me...if I have one form then I dont need to retype the Name, Period Ending, Location, etc...on the other hand if I have one form for each record it will be more work, maybe i am wrong. I am just thinking on a way to leave the form as it is right now. It would me easier for employees to enter their information. Also my manager told me "I want this" (refering to the excel file). So I dont know if I am asking for too much help in here...but if you can give me some hits or something i will really apreciatted, thank you |
#14
|
|||
|
|||
Problem designing tables: Too many fields
WOW, this is great...let me check it out...this can save my life |
#15
|
|||
|
|||
Problem designing tables: Too many fields
Harder ... for whom?!
Again, if you have someone with experience in X, doing something in X is easier than someone who is just learning X. Do you have Excel experience? Do you have someone with Excel experience? Do you have Access experience? (The learning curve on Access, if you haven't been using it and don't have experience creating normalized data tables, can be fairly steep.) Regards Jeff Boyce Microsoft Office/Access MVP "erick-flores" wrote in message oups.com... So, would you say its harder doing it in Access than in Excel? Because for me it sounds way harder in Access! PLease let me know what you think, because I am lost! |
#16
|
|||
|
|||
Problem designing tables: Too many fields
Just a reminder ...
Even if you have a template in Access, you still need to figure out how to "parse" your Excel-oriented data into the structure that the Access template uses. Regards Jeff Boyce Microsoft Office/Access MVP "erick-flores" wrote in message oups.com... WOW, this is great...let me check it out...this can save my life |
#17
|
|||
|
|||
Problem designing tables: Too many fields
This particular template is fairly simple and self-explanatory. Could
possibly just sit and type the information over in an afternoon, depending on how many records there are. Probably makes more sense than the Excel file ever did. Well, at least I hope it makes more sense . . . after all, erick-flores still hasn't come back and told us the results of this experiment. "Jeff Boyce" wrote: Just a reminder ... Even if you have a template in Access, you still need to figure out how to "parse" your Excel-oriented data into the structure that the Access template uses. Regards Jeff Boyce Microsoft Office/Access MVP "erick-flores" wrote in message oups.com... WOW, this is great...let me check it out...this can save my life |
#18
|
|||
|
|||
Problem designing tables: Too many fields
Hey, that template its helping me A LOT!....that what I need
Right now I am customizing some of the tables, and adding others so it can fit the company's needs. But its PERFECT. The excel file that the company was using before will be now obsolete, from no on we will be using the Access template with some modifycation that im doing right now Thank you very much for ur helps |
#19
|
|||
|
|||
Problem designing tables: Too many fields
Glad that the template works for you. If you run into any problems with your
modifications, just start a new thread. There are lots of helpful people here that can guide you through. In case you want to create other databases, there are also templates that are located right on your computer, as well as the ones that are on Microsoft's site. Good luck with your modifications. |
#20
|
|||
|
|||
Problem designing tables: Too many fields
Oh, one other thing: Do regular backups on your database. Do a backup
before changing ANYTHING. Do a backup after changing ANYTHING. It is possible to destroy a form/report, and with a backup you can import the form/report back in. Also, once it is being used by people, back it up very regularly. Depending on how often data is put in, that could be daily, weekly, or monthly. Tools/Database Utilities/Back Up Database |
Thread Tools | |
Display Modes | |
|
|