Hi Guys,
I'm new here so I hope this kind of post is welcome. A little info about my project:
- I am modifying an existing database to use a series of forms for direct entry. We currently use excel then manually import which is tedious.
- I need to build in a number of data validation tools and query based QA/QC checks
- Several calculated fields will be used
- A master copy will be stored on a server and will only be accessed by one computer at a time which will use the existing tables and queries to view data
- Multiple satellite databases will be used for data entry on non-networked computers
- At the end of every day the data collected by the satellite databases needs to be appended to the master database. The last few days of collected data needs to remain on the satellite databases
I guess that's it summarized. I need the records to append nicely and not get over-written or accidentally deleted if something changes in the satellite databases - once data is imported the master database should take precedent I guess?
I have recently completed a number of courses and am getting fairly good with database design, linking forms etc, but we did not cover backup up to a master database. What is the easiest way to do this? Do I split the database? I will have to learn how to do that? Do I just have several copies of the exact same database and build a macro of append queries?
Should something like this be date based? Every single record will have a special name field to group them by project, in addition to the primary key. The primary key is currently a basic Autonumber but it might make more sense to use a more complicated GUID?
Any help is appreciated. I am gathering info/forming my strategy and will officially start on this project in a few weeks.
Thank you!