Build Access Database for Assignment
Budget: $10 – $30 USD
I’m working on a university assignment that calls for a fully-functional Microsoft Access (.accdb) database. The scenario revolves around three core entities—Products, Customers, and Orders—so those will be the three related tables, each with its own primary key and enforced referential integrity. I already have partial field lists in mind but need a bit of guidance on tightening data types and any additional fields that would make the relationships robust.
The assignment requirements are straightforward:
• Three related tables (Products, Customers, Orders) with primary keys and proper relationships
• 15–20 sample records in every table
• At least two meaningful queries that demonstrate the relationships
• One clean data-entry form for day-to-day input
• One professional report that summarizes data meaningfully
• Final deliverable: a single .accdb file that opens without issues in Microsoft Access
I’ll share the official assignment brief along with my past lab files so you can see the grading rubric and the partial work I’ve already completed. As long as the file meets the criteria above, runs error-free, and clearly shows the referential links, I’ll consider the project a success.
The assignment requirements are straightforward:
• Three related tables (Products, Customers, Orders) with primary keys and proper relationships
• 15–20 sample records in every table
• At least two meaningful queries that demonstrate the relationships
• One clean data-entry form for day-to-day input
• One professional report that summarizes data meaningfully
• Final deliverable: a single .accdb file that opens without issues in Microsoft Access
I’ll share the official assignment brief along with my past lab files so you can see the grading rubric and the partial work I’ve already completed. As long as the file meets the criteria above, runs error-free, and clearly shows the referential links, I’ll consider the project a success.