Advantages of Microsoft Access and Databases
 There are several advantages of creating & maintaining Access databases:
• Data structure and normalization through multiple tables
• Scalability: adding more records is free & easy
• Enforce Data and Referential Integrity
• Build Simple as well as Complex Queries and Reports
• Automation through Macros and VBA

Table Structures and Validation
Databases make it easy to store information in one place and reference it in multiple places. For instance, customer information may be kept in a customer table where the name, address, phone number, email, etc. are kept. It is then referenced in other places such as queries, forms, and reports. If the customer’s information changes, the new information is automatically updated in all the referenced places. The table designs also impose structure that lends itself to data types, validation and consistency for higher quality than what normally exists in spreadsheets. The basics of storing numeric, date, and text fields are just the beginning.

Records are Easy to Maintain in Databases
It is easy to add, update, modify records in a database, and immediately update for all users. The queries, forms, and reports continue to work without any changes. Different filters may be applied but the results are always consistent. This allows accurate reports to be generated every year, quarter, month & weekly.

Data and Referential integrity
With referential integrity, we can avoid orphan records in an Master-Detail Relationship. Lookup lists and validation rules for individual fields and records can be easily implement in Microsoft Access at the table level. Forms can add additional rules during data entry to respond to user selection and events.

Queries and Reports
Access queries and reports let you slice and dice the data and present it in detail or summary format regardless of how the data is stored or sorted in the database. It offers a great deal of power and flexibility to analyse and present results. Using groupings, it’s easy to show aggregations as the data changes and groups get added or removed