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

Group Project – Stage 3

Kim’s Flowers Inc. Purchasing (Expenditure) Cycle

Don't use plagiarized sources. Get Your Custom Essay on
Create a MS Access database using the attached normalized tables, forms, validation rules, queries, reports, controls.
Just from $13/Page
Order Essay

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

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

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
error: Content is protected !!
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code GOODESSAY