#1
|
|||
|
|||
Creating small data Base
Hi Guys,
I want to create a small data base, I want to add data to empty fields on a spread sheet, when i save the data it should save it in a list, and clear all the fields so that I can add another task/event to keep track of what happens during the days. Any suggestions? I haven't used access in a long time to create a data base. Purpose of the sheet is, we have technicians in the field, and after each site visit i want to add the details in a list and it must save in a list so that I can refer back to what work has been done or not. Basic things like, Date, time, site, description, etc. I can add more stuff later what would be needed, but just need an example of how to do it. Regards |
#2
|
||||
|
||||
This sounds like fairly basic spreadsheet design - simply create a new workbook, add headings to each column for the attributes you want to record, then start recording the details in each row below those headings. This has nothing to do with Access.
As for "and clear all the fields so that I can add another task/event to keep track of what happens during the days", it's not at all clear what you mean. In Excel, you can simply keep adding data to new rows - up to 1048576, in fact. If you've finished with some data, you can simply delete those rows.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks, I started to use google drive, the calendar and just adding the data there.
Our technicians swap and install electrical meters, we have about 3000 meters in the field, in the empty fields i wanted to add all the meter details with vlookup, and dropdowns, times should automatically be saved when the empty fields were filled in. Im working in a high pace environment and wanted to make my tasks easier. Thanks for the advice, will play around and see what I can come up with. Regards |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating Invoices using data from a spreadsheet | tjcusick | Excel Programming | 3 | 12-05-2013 08:36 AM |
Changed data base name. Outlook doesn't recognize. | Skip | Outlook | 1 | 10-20-2011 10:55 AM |
creating macro for biffurcation in sheets according to data. | Nirik | Excel Programming | 8 | 05-07-2011 05:11 AM |
How do I set up the fields in mail merge word 07 from my data base | mbcrabber | Mail Merge | 4 | 06-06-2010 01:25 PM |
Need help creating a data base for mail merge. | acedking90 | Mail Merge | 0 | 07-27-2009 11:04 AM |