Import records from excel file dec$4$formatting and paste the formatting each of the title placeholders on Slides $3$ through $10.$

$5.$ Open the Top't Corn Sales Database Access file from the location where you saved the data files

for this project. $($Downloaded from the Resources link.$)$

a$.$ Import records from the Excel file Dec$4-10$Sales $($located with the data files for this project$)$ and append a copy of the records to the OnlineSales table. $($Hint: After the import, there should be $234$ records in the OnlineSales table.$)$

b$.$ In the OnlineSales table, rename the ID field: SaleID

$6.$ Create a query to display sales of Old Bay flavored popcorn from buyers in Maryland and then export the query results to an Excel file.

a$.$ Include the following fields in this order: SaleID, Date, Quantity, and State fields from the OnlineSales table and the ItemName field from the' table.

Reset Progress

$5$

Back to top

b$.$ Add criteria to the query to limit the results to records where the Item Name