Illustrated Access 2016 Modules 58 Sam Capstone Project

Illustratedaccess 2016 Modules 58 Sam Capstone Project 1aillustrat

Illustrated Access 2016 | Modules 5–8: SAM Capstone Project 1a Seminar Database Enhancing tables, queries, forms, and reports

Paper For Above instruction

The project involves working with an Access 2016 database to enhance tables, queries, forms, and reports as part of a comprehensive capstone exercise. The tasks require modifying existing tables and data, creating new relationships, and designing forms and reports to improve data management and presentation. The process begins with opening a provided database file, saving a copy with a new name, and verifying the presence of a specific record in a grading info table.

Next, the user must generate a relationship report, then proceed to modify the Attendees table by applying an input mask to the Phone Number field, setting a required field for HomeCity, and adding a new DateOfBirth field with a Medium Date format. The user is instructed to update properties in the Registration and Companies tables, including validation rules, lookup fields, and data updates, ensuring data integrity and usability. Tasks also include updating specific registration dates, creating and running parameterized queries with specific criteria, and sorting data appropriately.

The project further involves designing and formatting various reports, such as EventMaster List, Event Registration, and Attendees reports, with conditional formatting, section modifications, and subreports to display related data effectively. Emphasis is placed on enhancing report readability and functionality, including adding total calculations, formatting controls, and line drawings for visual clarity.

A significant component is customizing forms, such as the Attendee Entry, Event Entry, and Company Entry forms. This includes setting data sources, aligning controls, adding new fields, and embedding navigation elements like combo boxes and command buttons for efficient user interaction. The exercise concludes with constructing a main menu tab control and editing report properties to improve data presentation.

The final steps involve finalizing form and report designs, performing database maintenance like compacting and repairing, and submitting the completed project according to specified procedures. Overall, the assignment emphasizes practical database design skills, including relationship management, data validation, query design, report formatting, and user interface customization to produce a professional and functional database application.

References

  • Casey, K. (2018). Mastering Access 2016. Sybex.
  • Gill, A. (2017). Microsoft Access 2016 Bible. Wiley.
  • Gaskin, J. (2019). Access 2016 Programming by Example with VBA, XML, and ASP. Packt Publishing.
  • Harrington, J. L. (2016). Relational Database Design and Implementation. Elsevier.
  • Jelen, B., & Haeckel, G. (2017). Microsoft Access 2016 Programming by Example with VBA, XML, and ASP. Addison-Wesley.
  • McGregor, R. (2020). SQL and Relational Theory: How to Think About Data. O'Reilly Media.
  • Rob, P., & Coronel, C. (2016). Database System Design, Implementation, & Management. Cengage Learning.
  • Slater, M. (2018). Microsoft Access 2016 Programming. Wiley.
  • Viescas, J., & Herzberg, B. (2017). SQL Queries for Mere Mortals. Addison-Wesley.
  • Williams, L. (2019). Practical Microsoft Access 2016 Development. Microsoft Press.

Related Assignments