ComputerCondition come from the Computers table; the SalePrice field comes from ComputerSalesInfo table) (4pts) the 8....

Transcribed Image Text:

"ComputerCondition" come from the "Computers" table; the "SalePrice" field comes from "ComputerSalesInfo" table) (4pts) the 8. (12 points) Create a new parameter query named "8 - Filter Sale Records By Sale Price" with the following information: a. SaleID b. SalePrice (Hint: create two parameters for "SalePrice" field, one is for the upper bound of sale price, the other is for the lower bound of sale price. Once the user enter the upper bound and lower bound, the executed query should display sale records such that the sale price is in the range of [lower bound, upper bound]) (5pts) c. ComputerCost d. ComputerBrand 9. (9 points) Create a new query named "9 - Find Sale Records in 202x" with the following information: a. SalelD b. SalePrice c. ComputerCost d. ComputerBrand e. SaleDate (Hint: create a criterion for "SaleDate" field, which will find sale records that happen in 202x, i.e., it will find records that the computer is sold in 2020, 2021, but not 2019) (9pts) 10. (4 points) Create a report named "10 - Report of Computers" including all the fields from the "Computers" table a. Make sure the width of the report columns are adjusted such that the report fits the size of the page. (1 pt) b. Add page number with format of "Page N" centering in the top of the page (3 pts) 11. Save and Submit your work. Save your answers in the Access file, and name it as "nnn00000_access_assignment_spring2023.accdb" where nnn00000 is your NetID (AKA the account you log into HuskyCT with) Note: It's recommended that you close the database file after you save the file in Access. When the database file is still open, another associated middle file with .laccdb file name extension can be shown in your folder with the Access file with .accdb file name extension. Please don't submit the .laccdb file! Your submission Access file should be the one with the .accdb file name extension. (If you submit the .laccdb file, I will give you another chance to submit the correct file and it will cost you 10 pts) "ComputerCondition" come from the "Computers" table; the "SalePrice" field comes from "ComputerSalesInfo" table) (4pts) the 8. (12 points) Create a new parameter query named "8 - Filter Sale Records By Sale Price" with the following information: a. SaleID b. SalePrice (Hint: create two parameters for "SalePrice" field, one is for the upper bound of sale price, the other is for the lower bound of sale price. Once the user enter the upper bound and lower bound, the executed query should display sale records such that the sale price is in the range of [lower bound, upper bound]) (5pts) c. ComputerCost d. ComputerBrand 9. (9 points) Create a new query named "9 - Find Sale Records in 202x" with the following information: a. SalelD b. SalePrice c. ComputerCost d. ComputerBrand e. SaleDate (Hint: create a criterion for "SaleDate" field, which will find sale records that happen in 202x, i.e., it will find records that the computer is sold in 2020, 2021, but not 2019) (9pts) 10. (4 points) Create a report named "10 - Report of Computers" including all the fields from the "Computers" table a. Make sure the width of the report columns are adjusted such that the report fits the size of the page. (1 pt) b. Add page number with format of "Page N" centering in the top of the page (3 pts) 11. Save and Submit your work. Save your answers in the Access file, and name it as "nnn00000_access_assignment_spring2023.accdb" where nnn00000 is your NetID (AKA the account you log into HuskyCT with) Note: It's recommended that you close the database file after you save the file in Access. When the database file is still open, another associated middle file with .laccdb file name extension can be shown in your folder with the Access file with .accdb file name extension. Please don't submit the .laccdb file! Your submission Access file should be the one with the .accdb file name extension. (If you submit the .laccdb file, I will give you another chance to submit the correct file and it will cost you 10 pts)

Answer rating: 100% (QA)

To create the requested queries and report in Microsoft Access follow thes... View the full answer