I am looking to create a database for my company so I don't have to keep all my files in excel spread sheets. I'm wondering if there is a way to upload all my files that share some of the same information (ex.- contact information).
Instead of entering changes into 10 different spread sheets, can I enter it into one form (spread sheet) and have Access disperse the information to the 9 other forms? If not, are there any software programs I can use to make this easier and less time consuming?