Solved by verified expert:I have an exam due tomorrow that has all of the instructions listed, I will send you my logins once a tutor is assigned. Class has a strict no plagiarism policy so be careful with the users and the names being used. Here are the requirements.Part 1 – Get content for your database and update tablesEach student has a unique file for this assignment. CAUTION: RIGHT CLICK and select to save the files. DO NOT Left Click to open files directly from the links or the data may be corrupted. Download your database file. – Products and orders Download your text file. – Sales order details (you must right-click and choose to save it) Download your spreadsheet file. – Supplier dataCaution: These data files are unique and are only valid for you! If you do not use these data files or if you share these files with another student then you and any student you share these files with will receive 0 points credit for this assignment and risk being dropped or failing the class. Save the database file with the name Andrew.Meram_Exam2 (your file should automatically be named)Start Access and open the Exam 2 database file you downloaded.If you see the yellow security warning then click the Enable Content button.Open Table1 and verify that there are 68 records in the table. – ExampleOpen Table2 and verify that there are 100 records in the table. – ExampleIf you don’t have the number of records listed above contact your instructor before proceeding.Rename Table1 to tblProductRename Table2 tblOrderClose all tablesPart 2 – Import DataImport the text file as a table named tblOrderDetail. Note 1: The text file is a comma delimited data file where the first row contains field names.Note 2: No key field or index required for this table!Import the spreadsheet file as a table named tblSupplierNote 1: SupplierID should be set as the primary key See example of tables excluding your employee table/sReview the field types and set them as appropriate for the data size and type.In tblSupplier change the name of record 1 contact A. Schmitt to A. MeramImport 2 tables (tblEmployees and tblJobs) which you created in your Andrew.Meram_Exam1Exam 1 database.Part 3 – Update Table DesignModify table design following best database design practices. You can refer to your text starting on page A2-104You can also review Microsoft Database Design and my Database Design information pages.Update each table by setting appropriate field types, format, and sizes.Set appropriate key fields. Every table except tblOrderDetail requires a key field.Save any change to your tables.Part 4 – Add Validation and Lookup FieldAdd Validation to the Category field of tblProduct so that only the follow entries are allowed:Beer Candy Drinks Food Other SnackAdd the following validation text:Must be one of the following: Beer, Candy, Drinks, Food, Other, Snack.Modify the Category field to be a Lookup Field such that the following values can be selected from a list when you click in the Category field of any item:Beer, Candy, Drinks, Food, Other, SnackSave the changes to the table.Part 5 – Create RelationshipsNow that all the tables have had their design optimized and key fields are set the relationships can be set. If you have trouble creating a relationship you may need to modify the table design.Include all 6 tables in the Relationship view.Add appropriate relationships between the tables.Make sure that Enforce Referential Integrity and Cascade Update Related Fields is set for each relationship.Adjust the relationship layout so relationship lines are not hidden or go behing any of the tables and do not cross other relationship lines.Save the changes to the relationshipsPart 6 – Create a FilterCreate a filter in tblProduct that lists only the ItemCost is equal to OR below 1 Your filter must produce the correct results if the values are changed or new items are added to the table.Toggle the filter on to verify that it works.Toggle the filter off and close the table saving your changes with the filter off.Part 7 – Create QueriesThe manager wants to set up a discount section by the register with items which cost 99 cents. He also want a list of all the items from California which are from the Other category.Create a new query named qry99CentItems including items which have an ItemPrice of 99 cents including the following fields in this order: Item, ItemPrice, and Inventory.Sort the query design by Inventory in descending order.Save the queryCreate a new query named qryOtherItemsFromCA using data from tblProduct and tblSupplierthat displays only the SupplierName and Item fields in the results for all items in the Other category for suppliers in California.Sort the query design by Item in Ascending order.Adjust the width of each column as needed to properly display the results in the datasheet view.Save the query. – ExamplePart 8 – Create a FormCreate a form for tblProducts using the Form Wizard in the columnar format.Adjust the width of the Category, ItemCost, and ItemPrice so they are the same width as SuplierIDand Inventory. Do not adjust the width of the Item field.Change the text of the form header of the form to ProductsSave the form as frmProduct – ExamplePart 9 – Create a ReportCreate a report including the SupplierName from tblSupplier and Item, ItemCost, Inventory from tblProduct.Select to view by tblSupplierSort by Item and select Stepped layoutSave the report as rptSupplierItemsAdjust the columns so all the column names and data are correctly displayedChange the report title in the header to Supplier ItemsAdd a total in the SupplierID footer to list the number of items from each supplier and align it with the left edge of the ItemsAdd a caption Total Items for the sumChange the font color for the Total Items caption and the calculated totalChange the text of the report header to Supplier Items – ExampleSave the reportPart 10 – Finish and SubmitSet the database file option to compact on close. See the video how to do this.Upload your Andrew.Meram_Exam2 file using the Exam 2 link. Caution! Files must be submitted to the class drop box to earn credit.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more