With the fear of garbage in - garbage out, Access databases provide many tools to maintain data quality. This allows accurate reports to be generated every year, quarter, month, week, day, etc. Differentįilters may be applied but the results are always consistent. All the queries, forms, and reports continue to work without any changes. If it's well designed, over time, new records are continually added without The biggest difference with spreadsheets is that in a database, records are free. The basics of storing numeric, date, and text fields are just the beginning. Quality than what normally exists in spreadsheets. Table designs also impose structure that lends itself to data types, validation and consistency for higher Information changes, the new information is automatically updated in all the referenced places. It is then referenced in other places such as queries, forms, and reports. ![]() For instance,Ĭustomer information may be kept in a customer table where the name, address, phone number, email, etc. Automation through Macros and VBA Modulesĭatabases make it easy to store information in one place and reference it in multiple places.Scalability: adding more records is free. ![]() Data structure and normalization through multiple tables.There are several advantages of databases: For spreadsheet experts, it's often difficult to understand what databases offer that spreadsheets don't already have.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |