* Divides your information into subject-based tables to reduce redundant data.
In the Lab exercise, the database has divided into two tables, one is product table, the other is the supplier table. After the linking of two tables, user no need repeat in typing the common data - supplier name, to reduce the typo.
By dividing the data into subject-based tables, the user can read the information easier and the tables will not be too long.
* Accommodates your data processing and reporting needs
The advantage of using Access database system is that the user can use such large amount of data and convert into different type of report to fulfill different needs. In the lab exercise, the user can analysis the information by using product Category or supplier name. And it can do some calculation, such as how much we spended on each suppliers.
By using the query function of Access, we can search for the selling price range between $100 - $200; or which products quantity on hand are below 5 ... etc.
Table of product quantity on hand below 5.
That's right, we used table, query and report objects in our MS ACCESS lab exercise. Together these three objects help in storing and processing data for users.
ReplyDelete