Database Management Systems Paper

Database Management Systems Paper
Jamison Adams
University of Phoenix

Database Management Systems Paper
Database management systems are a collection of software applications that are combined to make it possible for people or businesses to store, extract or change information from a database. DBMSs offer many features or services which allow businesses to easily manage and protect vital information within the company database.
I work for a distribution center for a large organization that has thousands of customers in our region alone. Our company currently uses Microsoft Access as its primary DBMS. Microsoft Access works perfectly to help manage all of our client information and related product information as well. Access allows the users to create tables which contain specific information, such as a list of all our clients. Most of our information is stored in the form of tables and linked together. We have a table that is a list of every customer in our region and their contact information. We have another list of every product that we carry within our facility. Access allows us to easily track and report the usage and specific products that each of these customers are using. With this feature, we can determine what packages and deals that our company can offer the client. The more a customer purchases, the better deal we can offer because it is based on volume. Microsoft Access gives us the option to provide detailed reports to management, and to our customers which show products, prices and any other necessary information. Our company sends out monthly reports to each customer to inform them of all their transactions. We also send a bill to all customers that have charge accounts. Microsoft Access provides all of the necessary features that our company needs to operate. It also provides us with the ability to make sure all information is secure, by adding restrictions and only allowing management to access certain information....