My office is in the process of switching from Open Office Base to Microsoft Access on the computers. I manage a team of about 12 agents who enter in information into a form(currently in Base but shortly in Access) throughout the day. Each computer has it's own database right now. I then export the data from their database(daily) into an Excel spreadsheet and import that into Microsoft Access on my computer, which is what I run all of our reports off of. I'm wondering about some of the possible options of streamlining this sort of process once we have Access on all the computers. Basically, i'm looking for better ways for my team to input data and for that data to get to my database so I can run reports. What are some of the possible options with this number of agents? Are there good ways to link their databases with mine or set up forms that automatically enter data into my database? Any ideas would be appreciated! Thanks.