PRIORITIZING SOFTWARE CAPABILITIES AND FOCAL POINTS OF MS ACCESS AND EXCEL IN PERSPECTIVE OF DATA MANAGEMENT

Ali Fattah DAKHIL

allee.fattah@gmail.com
University of Sumer, Faculty of Computer Science and Information Technology, Computer Science Dept., Thi-Qar (Iraq)

Weffa Muhammed ALI


* University of Thi-Qar, Educational Collage of Pure Science, Computer Science Dept., Thi-Qar (Iraq)

Ali Atshan Abdul REDA


University of Sumer, Faculty of Computer Science and Information Technology, Computer Science Dept., Thi-Qar, (Iraq)

Abstract

Microsoft Corporation products have overwhelmed almost all organizations around the world even beside other operating systems like UNIX, Ubuntu and others. MS Office software products in particular, have being used widely in big portion of our work and business. In specific, MS Access and Excel are very famous and so usable software in between other Microsoft office products. Many similarities are shared between Access and Excel, meanwhile, many key differences are worth to point them out, too. Mainly, this research spotlights on primarily motivated topic of how they can manage data as they have been designed for. The mission of this research is to show how to employee MS Access and Excel in the right way in business work after indicating strength and weaknesses of both of them. Thus, we need to fulfill the right and suitable enough choice between Access and Excel that meets our business work requirements. A detailed list of significant features and key points are discussed and compered of both software leads to conducted proper software use. 


Keywords:

MS Access, MS Excel, similarity, differences, data, managing, fit choice, compression

Alexander, M. (2007). Microsoft Access 2007 data analysis: Unleashing the analytical power of Access. Indianapolis, IN: Wiley Technology Pub.
  Google Scholar

Alexander, M. (2010). The Excel analysts guide to Access (p.345). Indianapolis, IN: Wiley Pub Technology Pub.
  Google Scholar

Alexander, M., & Kusleika, D. (2016). Access 2016 bible (pp. 33–131). Indianapolis, IN: Wiley Technology Pub.
  Google Scholar

Customer case study: Moving from Excel to Access. (n.d.). Retrieved January 7, 2018, from https://support.office.com/en-us/article/customer-case-study-moving-from-excel-to-access9bc87c0c-4d94-488b-9629-b74b712840b8
  Google Scholar

Humphrey, M. L. (2010). Microsoft Excel for beginners. Eastlake, Oh.: Web Wise Seniors, Inc.
  Google Scholar

MacDonald, M. (2010). Access 2010 the missing manual. Sebastopol, CA: OReilly.
  Google Scholar

Monk, E. F., Brady, J. A., & Mendelsohn, E. I. (2017). Problem-solving cases in Microsoft Access and Excel. Boston, MA: Cengage Learning.
  Google Scholar

MS Access Security. (n.d.). Retrieved May 7, 2018, from https://www.help4access.com/ms-accesssecurity Protection and security in Excel. (n.d.). Retrieved March 8, 2018, from https://support.office.com/en-us/article/protection-and-security-in-excel-be0b34db-8cb6-44dd-a673-0b3e3475ac2d
  Google Scholar

Schmalz, M. (2005). Integrating Excel and Access. Beijing, China: OReilly Media.
  Google Scholar

Walkenbach, J. (2015). Excel 2016 Bible (pp. 109 - 170). USA: John Wiley & Sons, Inc.
  Google Scholar

Yassir, A. H., & Dakhil, A. F. (2016). Information Technology Services in Thi-Qar Province Analysis Study. Journal of Univesity of Thi-Qar, 11(4), 1–10.
  Google Scholar

Download


Published
2018-09-30

Cited by

DAKHIL, A. F., ALI, W. M., & REDA, A. A. A. . (2018). PRIORITIZING SOFTWARE CAPABILITIES AND FOCAL POINTS OF MS ACCESS AND EXCEL IN PERSPECTIVE OF DATA MANAGEMENT. Applied Computer Science, 14(3), 15–30. https://doi.org/10.23743/acs-2018-18

Authors

Ali Fattah DAKHIL 
allee.fattah@gmail.com
University of Sumer, Faculty of Computer Science and Information Technology, Computer Science Dept., Thi-Qar Iraq

Authors

Weffa Muhammed ALI 

* University of Thi-Qar, Educational Collage of Pure Science, Computer Science Dept., Thi-Qar Iraq

Authors

Ali Atshan Abdul REDA 

University of Sumer, Faculty of Computer Science and Information Technology, Computer Science Dept., Thi-Qar, Iraq

Statistics

Abstract views: 489
PDF downloads: 25


License

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

All articles published in Applied Computer Science are open-access and distributed under the terms of the Creative Commons Attribution 4.0 International License.


Similar Articles

1 2 3 4 5 6 7 8 9 10 > >> 

You may also start an advanced similarity search for this article.