The first thing to do when looking at an Access database design is to break down your information into separate facts. It is important that this step is done correctly as it can seriously affect your database if something goes wrong. Imagine you can only assign one order to a customer, whereas that customer can have multiple orders. This issue needs to be addressed during the Access database design phase.
You can click here to learn more about Access database design.
Image Source : Google
Do you want the system to delete records automatically, or do you want to manage them manually. It is possible to configure an MS Access database in such a way that the so-called cascading delete is performed.
In Access, you can create a simple form that displays a single entry. You can also create an MS Access subform that shows multiple records. You'll need the tables for these two forms and how to combine them. Good examples of bases and subforms are customers and orders. Customers are shown as entries in the main form and multiple orders are displayed in the appropriate MS Access subforms.
One of the most important things to consider when designing an Access database is that you shouldn't have duplicate information. The reason for this is that it eats up memory unnecessarily and affects requests. Make sure you store each fact only once in the database table.
When you get your Access database design right from the start, you get a seamless database system.