Essay4Business E-Commerce
Print Сite this

Microsoft Access Overview and Analysis

In this task, records of 25 customers were entered into the database. Seven of these customers were from Massachusetts, six from Pennsylvania, four from New Jersey, and eight from Maryland. These customers were served by four sales representatives. The management considered it appropriate to assign each representative to clients in specific states (Palmer 68). It was necessary to avoid cases where one sales representative handled clients from different states. The tables identify names, state, city, street, zip code, phone number, credit limit, and current balance (Westman 75).

In the tables provided, sales representatives’ identification numbers are clearly indicated to enhance their identity in the system without necessarily using their names (Meyer 52). The data provided in the database can be used to list the customers in either ascending or descending order based on their credit limit or current balance. It is important to note that the database created can be updated at any time (Davis and Phillips 88). When the information about a client changes the sales representative can update the information as may be appropriate (Kajan 45). The top managers will detect these changes as soon as they occur. The management can easily rely on the information in this database to make decisions if this may be appropriate (Siau and Erickson 115).

References

Davis, Michele, and Jon Phillips. Learning Php and Mysql. Sebastopol: O’Reilly, 2007. Print.

Kajan, Ejub. Handbook of Research on E-Business Standards and Protocols: Documents, Data, and Advanced Web Technologies. Hershey: Business Science Reference, 2012. Print.

Meyer, Jeanine. Creating Database Web Applications with Php and Asp. Hingham, Mass: Charles River Media, 2003. Print.

Palmer, Daniel. Ethical Issues in E-Business: Models and Frameworks. Hershey: Business Science Reference, 2010. Print.

Siau, Keng, and John Erickson. Principle Advancements in Database Management Technologies: New Applications and Frameworks. Hershey: Information Science Reference, 2010. Print.

Westman, Stephen. Creating Database-Backed Library Web Pages: Using Open Source Tools. Chicago: American Library Association, 2006. Print.

Cite this paper

Select style

Reference

Essay4Business. (2022, April 14). Microsoft Access Overview and Analysis. Retrieved from https://essay4business.com/microsoft-access-overview-and-analysis/

Reference

Essay4Business. (2022, April 14). Microsoft Access Overview and Analysis. https://essay4business.com/microsoft-access-overview-and-analysis/

Work Cited

"Microsoft Access Overview and Analysis." Essay4Business, 14 Apr. 2022, essay4business.com/microsoft-access-overview-and-analysis/.

1. Essay4Business. "Microsoft Access Overview and Analysis." April 14, 2022. https://essay4business.com/microsoft-access-overview-and-analysis/.


Bibliography


Essay4Business. "Microsoft Access Overview and Analysis." April 14, 2022. https://essay4business.com/microsoft-access-overview-and-analysis/.

References

Essay4Business. 2022. "Microsoft Access Overview and Analysis." April 14, 2022. https://essay4business.com/microsoft-access-overview-and-analysis/.

References

Essay4Business. (2022) 'Microsoft Access Overview and Analysis'. 14 April.

This paper was written and submitted to our database by a student to assist your with your own studies. You are free to use it to write your own assignment, however you must reference it properly.

If you are the original creator of this paper and no longer wish to have it published on Essay4Business, request the removal.