You just need follow the instruction: Skills needed to complete this 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) Open the start file AC2019-ChallengeYourself-2-3. 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. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor. 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 Set the FertID field as the primary key. Save the table with the name: Fertilizers Close the table. Open the Plants table and make the following changes. You may work in Datasheet view or Design view as appropriate. Set the field size for the PlantID field to: 10 Rename the FlowerColor field to: PrimaryColor Set the Default Value property for the PrimaryColor field to white. 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. Add an Attachment field after the PreferredFertilizer field. Add the image azaleas.jpg to the record for the Wild azalea. Delete the MaxHeightFeet field. Save and close the table. Open the Employees table and make the following changes. You may work in Datasheet view or Design view as appropriate. 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. Add the Phone Quick Start fields between the FirstName and Position fields. 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. Save and close the table. Open the MaintenanceLog table and make the following changes: Change the data type for the Watered field from Short Text to Yes/No. Change the data type for the Inspected field from Short Text to Yes/No. Change the data type for the Pruned field from Short Text to Yes/No. Change the format for the MaintenanceDate field to Medium Date. Save and close the table. Review the table relationships and make the following changes. 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. 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. Close the Relationships window, saving the layout changes. Close the database and exit Access. Upload and save your project file. Submit project for grading.

Project Plan InceptionOverviewThis is the first of a series of five sequential assignments (the course project) in which you will act as the Chief Technology Officer (CTO) of a hypothetical, e-commerce start-up company of your design. A venture capital group has funded this innovative start-up.The CEO has given you 60 days to deliver an information technology project plan in anticipation of the company relocating to a new facility. Since this is a start-up company, currently no building or technology infrastructure exists to support the business. All information technology (hardware and software) must be implemented in a hosted solution, an on-site solution, or a hybrid model. The CEO expects you to integrate different technologies from a variety of partners and incorporate industry best practices to develop the company’s technological systems.Additional background on the hypothetical companyCompany InformationCurrent StatusGrowth Projections (over next two years)Facility TypeNew facility is a two-story standalone building--Number of Employees1030Revenue$5 million$30 millionThis assignment consists of two parts:Part 1: Project Plan InceptionYou will write a 5–7-page document outlining the project specifics, such as company background information, company business, and an overview of the company’s information systems infrastructure.Part 2: Supporting Gantt ChartYou will use Microsoft Project to create a Gantt chart for your e-commerce company project.Note:You are to create or assume all necessary assumptions to successfully complete this assignment.You must submit both parts as separate files to the assignment area. Label each file name according to the appropriate part.InstructionsPart 1: Project Plan InceptionIn a 5–7-page project plan inception document, you are to:Develop your hypothetical e-commerce company's background information.Refer to this article: Top 10 Largest Ecommerce Companies in the US in 2020, when developing your company’s background information.This article outlines the major types of e-commerce companies in existence. Use this as a guide when deciding what background information to include about your hypothetical e-commerce company in your project plan inception document.Document your chosen e-commerce company's business type, customers, and demographic information.Describe the key elements of your e-commerce company's information systems infrastructure.Develop a high-level block diagram of your e-commerce company's information systems infrastructure.Use three sources to support your writing.Choose sources that are credible, relevant, and appropriate.Cite each source listed on your source page at least one time within your assignment.Access the library or review library guides for help with research, writing, and citation.Part 2: Supporting Gantt ChartUse Microsoft Project to create a Gantt chart identifying the major and minor tasks, illustrating dependency relationships between activities.FormattingThis course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions. Note the following:The preferred method is for the project plan inception portion of your assignment to be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides.Include a cover page containing the assignment title, your name, your professor's name, the course title, and the date. The cover page is not included in the required page length.Include a source list page. Citations and references must follow SWS format. The source list page is not included in the required page length.Learning OutcomesThe specific course learning outcome associated with this assignment is:Create an initial information systems project plan for a new startup company.