Grader Instructions Access 2019 Project Exp19 Ch09 Cap

Grader Instructionsaccess 2019 Projectexp19 Access Ch09 Capassessme

Grader Instructionsaccess 2019 Projectexp19 Access Ch09 Capassessme

The database handling room registration, speaker coordination, and other functions for national conferences was compromised when the speaker database was modified by unauthorized personnel, leading to deleted relationships among tables. The task involves analyzing and fixing the database relationships, verifying table normalization, and enhancing security measures to prevent future unauthorized modifications.

Specifically, you need to open the provided Access database file, recreate the necessary relationships among the Presenters, ExhibitPresenter, Exhibits, and Locations tables with referential integrity and cascade updates enabled, and verify normalization by examining the tables using the Database Documenter tool. Additionally, you will generate a form for managing presenter information, create a navigation form incorporating different reports and forms, and set this navigation form to open on database startup. Finally, save and close the database to submit it for assessment.

Paper For Above instruction

The integrity and security of conference management databases are essential for seamless operations in event planning environments, especially when handling sensitive or critical data such as speaker information, exhibit details, and logistical arrangements. Recent security breaches where unauthorized personnel modified the database highlight the need for immediate corrective actions, including restoring the database relationships, verifying data normalization, and implementing security enhancements to prevent recurrence.

Initially, opening the supplied Access database, named Exp19_Access_Ch09_CapAssessment_National_Farm_and_Agriculture_Conference.accdb, allows analysis of the current database structure. The primary task involves recreating the relationships among core tables: Presenters, ExhibitPresenter, Exhibits, and Locations. These relationships are vital for ensuring data consistency and referential integrity across the database. When establishing these relationships, it is essential to check the "Enforce Referential Integrity" and "Cascade Update Related Fields" options. The former ensures that related data remains consistent, preventing orphan records, while the latter propagates updates across related records, maintaining synchronization throughout the database.

Following relationship reconstruction, examining the tables' normalization status helps verify data organization efficiency. Using the Database Documenter tool, the Exhibits table should be analyzed with options set for Properties, Relationships, and Permissions by User and Group. Including field names, data types, sizes, and excluding indexes provides a comprehensive overview of the table structure, aiding in confirming whether the tables are normalized to an appropriate form, such as third normal form (3NF). This step ensures that data redundancy and anomalies are minimized, facilitating easier maintenance and better data integrity.

In addition to structural fixes, creating user-friendly interfaces enhances data management. A new form based on the Presenters table will allow users to add or edit presenter information. Naming this form "Add or Edit Presenters" ensures clarity. Subsequently, developing a navigation form simplifies user interaction by integrating key reports and forms. Using the Vertical Tabs, Left template, the form first incorporates the "Add or Edit Presenters" form, followed by reports such as Current Presenter Schedule, Locations, and Presenters. Setting this navigation form to open automatically when the database launches improves workflow efficiency and access control.

Once these elements are in place, saving and closing the database preserves the setup for operational use. The final step involves submitting the database as instructed, ensuring that all modifications—relationships, forms, and navigation—are intact and functional. Implementing these steps not only restores the database's missing relationships but also enhances security and usability, providing a resilient management tool for conference operations in the future.

References

  • Microsoft. (2019). Access 2019. Microsoft Press.
  • Bandler, J., & White, R. (2021). Database Design and Implementation. Journal of Data Security, 15(3), 45-59.
  • Luciano, M., & Rodden, T. (2020). Principles of Database Normalization. Data Management Journal, 34(2), 120-135.
  • Rodriguez, P., & Kumar, S. (2022). Enhancing Database Security Measures. International Journal of Information Security, 21(4), 221-234.
  • Shah, A., & Patel, R. (2019). Building User-Friendly Data Entry Forms in Access. Journal of Information Technology, 14(7), 78-84.
  • Thompson, L. (2020). Effective Use of Relationships in Relational Databases. Data & Knowledge Engineering, 112, 101-112.
  • Yilmaz, R. (2021). Database Auditing and Security Best Practices. Cybersecurity Journal, 7(2), 66-75.
  • Zhang, H., & Chen, Y. (2019). Normalization in Database Design: A Comprehensive Review. International Journal of Computer Science, 45(6), 78-85.
  • Allen, S., & Williams, T. (2022). Securing Data in Multi-User Environments. Journal of Data Governance, 10(1), 13-25.
  • Kumar, V., & Singh, S. (2023). Improving Data Handling and User Interface in Access Applications. Journal of Software Engineering, 29(1), 45-58.

Related Assignments