Fill in Order Details

  • Submit paper details for free using our simple order form

Make Payment Securely

  • Add funds to your account. There are no upfront payments. The writer will only be paid once you have approved your paper

Writing Process

  • The best qualified expert writer is assigned to work on your order
  • Your paper is written to standard and delivered as per your instructions

Download your paper

  • Download the completed paper from your online account or your email
  • You can request a plagiarism and quality report along with your paper

Assignment 21: Access 2019 Challenge Yourself

In this access 2019 challenge yourself project you will continue working with the greenhouse database from Chapter 1 Challenge Yourself 1.3. You will add a new table to keep track of the fertilizers used in the greenhouse and the plants that use them. You will make changes to the Plants, Employees, and MaintenanceLog tables including adding fields, deleting fields, and modifying field properties. You will also create and modify table relationships.

Skills needed to complete this access 2019 challenge yourself project:

  • Creating a Table in Design View and Setting the Primary Key (Skill 2.8)
  • Modifying the Field Size Property (Skill 2.13)
  • Renaming Fields (Skill 2.3)
  • Setting the Default Value Property (Skill 2.12)
  • Adding Fields in Datasheet View (Skill 2.4)
  • Adding a Lookup Field from Another Table (Skill 2.16)
  • Deleting Fields in Datasheet View (Skill 2.6)
  • Working with Attachment Fields (Skill 2.15)
  • Adding a Lookup Field from a List (Skill 2.17)
  • Inserting, Deleting, and Moving Fields in Design View (Skill 2.9)
  • Using Quick Start to Add Related Fields (Skill 2.5)
  • Moving Fields in Datasheet View (Skill 2.7)
  • Changing Data Type (Skill 2.10)
  • Formatting Fields (Skill 2.11)
  • Creating Relationships (Skill 2.18)
  • Enforcing Deletions and Updates in Relationships (Skill 2.19)
  1. Open the start file AC2019-ChallengeYourself-2-3.
  2. If the database opens in Protected View, click the Enable Content button in the Message Bar at the top of the database so you can modify it.
  3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
  4. Create a new table in Design view using the following information. Table displays the field name, datatype, and caption information for the Fertilizers table. Field Name Data Type Caption FertID Short Text FertilizerName Short Text Fertilizer Name NutrientRatio Short Text Nutrient Ratio Price Currency
    1. Set the FertID field as the primary key.
    2. Save the table with the name: Fertilizers
    3. Close the table.
  5. Open the Plants table and make the following changes. You may work in Datasheet view or Design view as appropriate.
    1. Set the field size for the PlantID field to: 10
    2. Rename the FlowerColor field to: PrimaryColor
    3. Set the Default Value property for the PrimaryColor field to white.
    4. Add a lookup field named PreferredFertilizer to the end of the Plants table to reference the FertilizerName field in the Fertilizers table. The lookup list should be sorted alphabetically by the FertilizerName data. The primary key field should be hidden. Enforce referential integrity.
    5. Add an Attachment field after the PreferredFertilizer field. Add the image azaleas.jpg to the record for the Wild azalea.
    6. Delete the MaxHeightFeet field.
    7. Save and close the table.

Or Get a Class Quote

  1. Open the Employees table and make the following changes. You may work in Datasheet view or Design view as appropriate.
    1. Move the LastName field so it appears before the FirstName field. Hint: Make the change in Design view so the change is applied to the underlying structure of the table.
    2. Add the Phone Quick Start fields between the FirstName and Position fields.
    3. Modify the Position field to use a lookup list limited to the following values: Supervisor, Greenhouse Tech 1, and Greenhouse Tech 2. Hint: Use the Lookup Wizard to create the lookup list and enter the values yourself. Double-click the right border of the Col1 column in the wizard to AutoFit the column to the data. Don’t forget to limit data entries to the value in the list.
    4. Save and close the table.
  2. Open the MaintenanceLog table and make the following changes:
    1. Change the data type for the Watered field from Short Text to Yes/No.
    2. Change the data type for the Inspected field from Short Text to Yes/No.
    3. Change the data type for the Pruned field from Short Text to Yes/No.
    4. Change the format for the MaintenanceDate field to Medium Date.
    5. Save and close the table.
  3. Review the table relationships and make the following changes.
    1. Create a one-to-many relationship between the PlantID field in the Plants table and the PlantID field in the MaintenanceLog table. Enforce referential integrity.
    2. Modify the relationship between the EmployeeID field in the Employees table and the EmployeeID field in the MaintenanceLog table so any deletions or changes to the EmployeeID in the Employees table will be carried through to the EmployeeID field in the MaintenanceLog table.
    3. Close the Relationships window, saving the layout changes.
  4. Close the database and exit Access.
  5. Upload and save your project file.
  6. Submit project for grading.

Reviews


Anonymous

Excellent job, received an A+ (96) on the paper. Thank you so much.

Anonymous

On time and beyond the work I expected. Communication is fast and amazing, this is the only writing service I will be using.

Consider Your Assignments Done

“All my friends and I are getting help from eliteacademicresearch. It’s every college student’s best kept secret!”

Jermaine Byrant
BSN

“I was apprehensive at first. But I must say it was a great experience and well worth the price. I got an A!”

Nicole Johnson
Finance & Economics

See Why Our Clients Hire Us Again And Again!

OVER
10.3k
Reviews

RATING
4.89/5
Avg Rating

YEARS
12
Experience

Elite Academic Research Promises You:

Always on Time

If we are a minute late, the work is on us – it’s free!

Plagiarism-free

If the work we produce contains plagiarism we’ll pay out a £5,000 guarantee.

Quality

Providing quality work is core to our beliefs, which is why we will strive to give you exactly that, and more!

Written to Standard

All of our assignments go through a stringent quality checking process from start to finish.

Success Guarantee

When you order form the best, some of your greatest problems as a student are solved!

Reliable

Professional

Affordable

Quick

What our customers say
_____

Writer provided excellent layout and research assistance I needed in order to create my own essay.
Great service fast and friendly. Have used the team more than once for assistance with work of a high standard. Communications have been faultless and everything arriving by promised time line. Will definitely use again ! 5 star
error: Content is protected !!