Database Access Information System: The Person Who Originall

Database Access Information Systemthe Person That Originally Did This

Database Access Information system The person that originally did this did a horrible job. I need this in 4-6 hours Create a database called Volunteer as shown in Chapter Extension 8 (Page: 398). Use the data (for tables Prospect and Work) as shown in page 400 (CE 8-2). Create the tables, relationships, Data Entry form, Queries and reports as explained in the Chapter Extension 8. Upload the database file to the drop box. Enter your name as one of the prospects in the “prospect” table replacing one of the names given. Review the following material. Review the following material. Using Microsoft Access Tutorial Please select the Access Topic on the web page and click to watch the presentation. Here are the pages

Paper For Above instruction

Database Access Information Systemthe Person That Originally Did This

The task involves creating a comprehensive database named "Volunteer" using Microsoft Access, following specific instructions outlined in Chapter Extension 8 (Page 398). The core components include designing tables, establishing relationships, designing data entry forms, queries, and reports, as per the guidelines provided within the chapter extension. Additionally, the user is instructed to use predefined data for the "Prospect" and "Work" tables as shown in page 400 (CE 8-2).

Furthermore, the user must update the "Prospect" table by entering their own name, replacing an existing prospect's name, thereby personalizing the database entry. Emphasis is given to reviewing supplementary learning materials, specifically Microsoft Access tutorials available online, to ensure proper understanding of functionalities such as table creation, relationship setup, form design, query configuration, and report generation.

Lastly, the completed database project is required to be uploaded to a designated drop box, emphasizing the importance of timely submission within a 4 to 6-hour window from assignment receipt.

Paper For Above instruction

Introduction

Creating a functional and efficient database is an essential skill for managing information systematically. This project involves developing a "Volunteer" database in Microsoft Access, which encompasses multiple components such as tables, relationships, data entry forms, queries, and reports. The objective is to follow detailed instructions from the specified chapter extension, ensuring a comprehensive understanding of database design and implementation.

Designing Tables and Relationships

The initial step involves designing the main tables, "Prospect" and "Work," as delineated in the textbook. The "Prospect" table captures details about potential volunteers or donors, including fields such as prospect ID, name, contact information, and the date of inquiry. The "Work" table tracks the tasks or projects assigned or associated with prospects, including work ID, description, date, and related prospect ID to maintain referential integrity. Establishing relationships between these tables is crucial for maintaining the integrity and ease of data retrieval, typically achieved through primary and foreign keys.

Data Entry and Personalization

Following database setup, data should be entered into the "Prospect" table, substituting one of the existing names with the user's own, to personalize the database. This step emphasizes user engagement and ensures that the database reflects individual input. Proper data validation and entry techniques should be employed to maintain data integrity, especially when updating the prospect's information.

Creating Forms, Queries, and Reports

Designing user-friendly forms for data entry is essential for efficient data management. The main form allows users to input, update, or view prospect information seamlessly. Queries are then configured to extract specific data sets, such as prospects who have been contacted within a certain date range or projects assigned to particular prospects. Reports are generated to present summarized or detailed views of the data, facilitating decision-making and record-keeping.

Utilizing Microsoft Access Tutorials

To ensure quality and accuracy, additional learning through Microsoft Access tutorials is recommended. Available online, these tutorials guide users through the process of database creation, form design, query setup, and report generation. Watching these presentations enhances understanding, especially for those new to Access or database design principles.

Submission and Finalization

After completing the database with all components—tables, relationships, forms, queries, and reports—the final step involves exporting or saving the database file. The user must then upload this file to the designated drop box within the stipulated timeframe of 4 to 6 hours from receipt of the assignment. Timely submission ensures compliance with course requirements and assessment criteria.

Conclusion

Developing a comprehensive "Volunteer" database in Microsoft Access involves understanding relational database design, efficient data entry, and effective report generation. Following the chapter extension instructions, utilizing available tutorials, and personalizing data entries are critical steps to successfully complete this project. The completed database not only demonstrates technical proficiency but also enhances data management capabilities within an organizational context.

References

• Harrington, J. L. (2016). Relational Database Design and Implementation. Elsevier.
• Gaskin, J. (2020). Microsoft Access 2019: The Complete Guide. John Wiley & Sons.
• Microsoft Corporation. (2023). Access Help & Learning. Retrieved from https://support.microsoft.com/en-us/access
• Rob, P., & Coronel, C. (2007). Database Systems: Design, Implementation, & Management. Cengage Learning.
• Murach, J. (2015). Murach's SQL for Programmers. Mike Murach & Associates.
• McFedries, P. (2016). Microsoft Access 2016 Programming by Example. Microsoft Press.
• Teorey, T. J. (2014). Database Modeling & Design. Elsevier.
• Hoffer, J. A., Ramesh, V., & Topi, H. (2016). Modern Database Management. Pearson.
• Pratt, T., & Adamski, S. (2018). Visual Basic and VBA in a Windows Environment. Pearson.
• Wang, W. (2019). Data Management for Researchers. CRC Press.