Sometimes, you may need to store and organize data in a more robust way.
Create tables, forms and reports in Access for large-scale data projects.
Access databases are helpful to use when working with more complex relational data. Forms can allow for a more controlled data entry process over Excel, queries can be built to only pull certain subsets of data and reports allow for easy data summaries when needed.
For example, you may need to work with customer information on a regular basis. Any customer could have multiple contacts or multiple shipping addresses, but to preserve customer data integrity you only want to enter the customer once. The Access framework allows you to store related data in separate tables, and by creating relationships between data tables this allows the customer to only be entered once while many contacts or addresses can be added to separate tables that relate back to the customer.
Access allows you to create and define relationships between table data.
The relationships in this instance mean for each customer there can be many contact or address records. You could not add a contact or address without first adding a new customer.
User forms can be created to make data entry easier and controlled.
Here a user can enter a customer and then select the “contacts” or “addresses” tabs below to enter related information.