Re: optimizing DB w/ access front end & MySQL backend
Consolidating database FE's into one isn't necessarily a good idea. If the same user group uses the individual FE's, it might be more convenient for them to open only a single application but it could also complicate security and maintenance.
Consolidating the BE's is probably a bad idea unless there are relationships between tables where RI would be beneficial.
Bridge Players Still Know All the Tricks