Microsoft Access: everything you need to know to manage to manage your database effectively
DOI:
https://doi.org/10.33448/rsd-v12i5.41324Keywords:
Microsoft Access; DBMS; Database.Abstract
This article provides a comprehensive and detailed overview of Microsoft Access, a versatile database manager used in both business and personal contexts. Through bibliographic research, including articles and specialized books, as well as personal experiences, we seek to present a complete analysis of the software. The text covers from fundamental concepts to advanced features of Access, exploring different perspectives of use and ensuring the security of the stored data. By discussing essential aspects and effective management techniques, the article aims to optimize the user experience with the program. Throughout the study, information is projected on the basic functionalities of the software, such as creating and manipulating tables, forms, reports and queries, as well as advanced features such as VBA programming and integration with other Microsoft applications. In addition, the article explores varied perspectives of use, highlighting the potential of Access in a variety of scenarios and meeting different data management needs. Finally, emphasis is placed on data security in Access, addressing practices and settings that ensure the protection of stored information. With a complete and didactic approach, the article aims to make the use of Microsoft Access as efficient as possible for users.
References
Abreu, A., de Carvalho, V., & Azevedo, A. (2011). Microsoft Access 2010.
BarCharts, Inc. (2013). Microsoft Access 2013 Advanced Quick Reference Guide. QuickStudy.
Barrows, S. (2016). Microsoft Access 2016 Step by Step. Microsoft Press.
Boyce, J. (2007). Microsoft Access 2007 Bible. John Wiley & Sons.
Caldeira, F. (2004). Introdução aos Sistemas de Gestão de Bases de Dados Microsoft ACCESS.
Carey, J. (2013). Microsoft Access 2013: Comprehensive. Cengage Learning.
Coelho, J. (2011). Introdução à base de dados utilizando Microsoft Access.
Cohen, D. (2010). Access 2010 Solutions, Tips, Tricks, and Secrets from Microsoft Access MVPs. Apress.
Colligan, M. (2013). Microsoft Access 2013 Plain & Simple. Microsoft Press.
Couch, D. (2012). Microsoft Access 2010 VBA Macro Programming. McGraw-Hill Osborne Media.
Ferenhof, H. A., & Fernandes, R. F. (2016). Desmistificando a revisão de literatura como base para redação científica: método SSF. Revista ACB, 21(3), 550-563.
Ferguson, S. (2016). Access 2016 For Dummies. John Wiley & Sons.
Frye, C. (2010). Microsoft Access 2010: Basic. Prentice Hall.
Griffith, R. (2007). Beginning Access 2007 VBA. John Wiley & Sons.
Lambert, S. (2016). Access 2016 For Seniors: The complete guide. First Rank Publishing.
MacDonald, M. (2010). Access 2010: The Missing Manual. O'Reilly Media, Inc.
Martin, M. (2009). Mastering VBA for Microsoft Office 2007. John Wiley & Sons.
Perry, G. (2013). Sams Teach Yourself Microsoft Access 2013 in 24 Hours. Sams Publishing.
Ralston, J. (2013). Access 2013 All-in-One For Dummies. John Wiley & Sons.
Rose, M. (2014). Access 2013: The Missing Manual. O'Reilly Media, Inc.
Sales, M. (2016). Microsoft Access 2016 Programming By Example: with VBA, XML, and ASP. CreateSpace Independent Publishing Platform.
Simpson, A. (2015). Access 2016 Bible. John Wiley & Sons.
Ulrich, M., & Moch, M. K. (2019). Access 2019 Bible. John Wiley & Sons.
Viescas, J. (2010). Microsoft Access 2010 Inside Out. Microsoft Press.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Gustavo Cavalcante Correa; Nícollas Aguiar Ávila; João Gabriel de Oliveira Silva; Caroline Nunes Carr; Renato Ferreira Carr
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1) Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2) Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
3) Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
