When designing a database you need to think about how you will maintain and make changes to it when it is being used. Just as decorators work around their clients, so database administrators need to be able to work on databases disrupting the users as little as possible.
The most common solution is to split the Access database into two separate files, a front end file that contains the forms, reports and queries and a linked back-end file that contains the actual tables and data. Splitting databases in this way makes them easier to modify, better in multi-user environments and more flexible.
Acuity’s courses can take delegates from being complete beginners through to learning advanced database techniques like creating and running macros and writing VBA . For more information please go to our Microsoft Access Training Courses.