Part 2 Provider Database MS Access Use The Project Descripti

Part 2provider Database Ms Accessuse The Project Description Here T

Create a provider database and related reports and queries to capture contact information for potential PC component providers that might be used to purchase the equipment specified in your MS Word project – the PC specifications. The database must include a table with fields for provider contact info, a form for data entry, two reports for presenting the data, and a Word document answering specific questions about the database.

Specifically, the database should include:

• A table named “Provider Information Table” with fields such as Provider ID (autonumber, primary key), Provider’s Company Name, Provider Contact First and Last Name, Billing Address, City, State (2 characters), Zip Code (5 characters), Phone Number (area code and number), YTD Orders (currency), and Preferred Provider (Yes/No). Some fields require captions for report display. All fields must be properly set with appropriate data types and sizes.
• A data entry form named “Provider Data Entry Form” created via the Form Wizard, utilizing all table fields with a columnar layout and a theme other than the default Office style. The form must be used to enter data for at least seven providers, with at least one marked as a Preferred Provider based on a specified YTD Orders criterion.
• A report titled “Provider Contact Information” generated using the Report Wizard in landscape orientation, sorted by Provider Contact Last Name, displaying selected fields in order: company name, contact names, complete address, and phone number. The report must be styled for readability, with all data visible and no truncations.
• A second report creating mailing labels that display provider contact full names, company names, and mailing addresses in a format suitable for printing on envelopes. Save this as “Provider Mailing Labels.”

Additionally, create an MS Word document titled “First Initial Last Name Access Questions” (for example, JSmith Access Questions). The document must be double-spaced, Arial, 12 point, and include a title page with project title, your name, course ID, and due date. Answer the following questions in 4-5 sentences each:

1. What additional fields would you add to the database created to assist in selecting a provider to fulfill the PC purchase? Explain why these fields would be useful.
2. Could you replicate the database activity using an Excel spreadsheet? Discuss the advantages and disadvantages of using Excel over Access for this case study.

Ensure both the Access database file (containing the table, form, and reports) and the Word document are submitted together. The overall appearance of the project should be professional, clear, and well-formatted for both screen and print output.

Paper For Above instruction

The development of a provider database using MS Access serves as an essential tool for managing and analyzing potential supplier information efficiently. It enables organizations to organize crucial contact details, streamline data entry, and generate reports that facilitate informed decision-making when selecting providers for PC component procurement. This project not only enhances technical skills in database design but also emphasizes the importance of data integrity, clarity, and usability in business applications.

To begin with, the creation of the Provider Information Table forms the backbone of this database. It includes key fields such as Provider ID, which is set as an autonumber primary key to uniquely identify each provider. Essential contact details like company name, contact person’s first and last names, billing address, city, state, zip code, and phone number are incorporated to ensure comprehensive contact records. The inclusion of a YTD Orders field, recorded in currency, helps quantify the volume of business done with each provider, while the Preferred Provider checkbox distinguishes preferred vendors based on YTD order criteria. Setting appropriate field sizes and captions enhances report readability and data consistency.

The data entry form, created with the Form Wizard, allows for straightforward manual data input and editing. Using a columnar layout and applying a professional theme ensures ease of use and visual appeal. Entering data for at least seven providers, with at least one marked as preferred, enables a realistic and functional dataset for subsequent reporting and analysis. Verifying data accuracy through manual review of the table prior to report creation is critical for maintaining data quality.

The first report, generated with the Report Wizard, displays provider contact details in a clear, organized manner. Sorted by contact last name, it allows users to quickly locate vendor information. The landscape orientation and stylistic adjustments improve readability. The second report, a mailing label format, offers a practical tool for printing address labels. Proper formatting ensures the labels are correctly spaced and suitable for mailing purposes, facilitating effective communication with providers.

In the accompanying Word document, the applicant addresses two critical questions. The first discusses additional fields that could enhance provider selection, such as delivery lead times, pricing tiers, payment terms, or ratings based on past performance. These fields would provide a more comprehensive view of each provider’s capabilities and reliability, aiding in strategic decision-making. The second question explores using Excel as an alternative to Access.

Excel offers advantages like simplicity, ease of use, and flexibility for small datasets or when advanced relational features are unnecessary. However, it lacks the robust data integrity, multi-user access, and relational capabilities of Access, which are vital for larger, more complex databases. For this case study, Access’s structured environment and query/reporting functionalities make it the better choice, especially when managing multiple providers and performing detailed data analysis.

In conclusion, the database development process demonstrated here underscores the significance of organized data management in business operations. It showcases the importance of thoughtful design, appropriate data entry procedures, and useful reports, all contributing to more effective vendor management. Proper documentation and professional presentation of the database and supplemental answers exemplify best practices in business information systems and project management.

References

• Harrington, J. L. (2016). Relational Database Design and Implementation. Morgan Kaufmann.
• Kroenke, D. M., & Auer, D. J. (2019). Database Processing: Fundamentals, Design, and Implementation. Pearson.
• Rob & Coronel (2018). Database Systems: Design, Implementation, & Management. Cengage Learning.
• Brown, K. (2020). Mastering MS Access: Building Business Applications. Packt Publishing.
• Navathe, S., & Elmasri, R. (2015). Fundamentals of Database Systems. Pearson.
• Wang, W., & Wu, B. (2017). Practical Database Design. Springer.
• Laudon, K. C., & Traver, C. G. (2018). E-Commerce 2018: Business, Technology, Society. Pearson.
• Shelly, G. B., & Cashman, T. J. (2018). Microsoft Access 2019 Intermediate. Course Technology.
• Hoffer, J. A., & Venkataraman, R. (2014). Modern Database Management. Pearson.