Create a MS Access database using the attached normalized tables, forms, validation rules, queries, reports, controls. Please read carefully the instructions attached.

Group Project – Stage 3

Kim’s Flowers Inc. Purchasing (Expenditure) Cycle

Requirements:

The final part of the project requires your team to implement the logical data model in MS Access. Please read carefully the instructions below before you start working on your project. You should submit your database file and a separate word document with answers/explanations as requested below.

1. Create tables in the MS Access file by using the provided docs (i.e., the normalized tables, ERA Diagram)

   • In each table, define the primary key.

   • For each attribute, define the data type, provide a field description, and define the field properties.

   • For each table, there should be at least one validation rule and a corresponding validation text and explain why these validation rules are implemented.

2. Establish relationships between all the tables you created.

   • Make sure that you enforce the referential integrity in all your relationships.

3. Create at least three forms.( see Forms)

   • One of which should be a form with a subform.

   • Describe the function of each form, who would use it, and its purpose.

   • Reference

4. Populate your tables with fictitious data entries.

   • You should sufficiently populate your tables so that you can demonstrate your design (about 20 rows for events and 10 for agents and resources).

5. Create queries and explain why these queries are important for managers/decision makers.

   • You should have at least four multiple table queries in your design, and three other queries.

   • At least one of your queries should perform calculation. You can create a query using either SQL (i.e., SELECT statement) or Expression Builder in Query Design.

6. Create at least two reports for management/decision makers.

   • Describe what benefits these reports provide for decision makers, and how often they will be used.

7. Document the existing internal control structure based on your current design.

ERA Diagram