ITC101 May 2023 - Lab Assign... 3. The format of the submitted assignment should be as below: - Lab Assignment.accdb - Lab Assignment Report.pdf 4. Students MUST pass this lab assignment in order to pass this subject. (This lab assignment paper consists in 6 printed pages, including cover page) ITCI01 (May 2023 Semester, Lab Assignment) Page 2 Assessment Details: LAB-BASED ASSESSMENT Release Date : 30th June 2023 Due Date :14th July 2023 Value :25% of total assessment in subject Task: This is an individual work. This assignment focuses on utilizing Microsoft Access and Excel to manage and analyse data for a hypothetical business. Assignment Question: Instructions for Microsoft Access: Database Creation: Create a Microsoft Access database for tracking inventory in the hypothetical business. Include fields for product names, quantities, and prices. Queries: Develop 3 queries that extract specific information from the database. For example, find products with low quantities or high prices. Forms: Design 2 user-friendly forms that allow users to input new data into the database. Consider forms for adding products or customers. Reports: Generate 2 reports that summarize data from the database in a clear and understandable format. Present information such as product inventory or customer purchase history. Instructions for Microsoft Excel: Budget Spreadsheet: Create a budget spreadsheet using Microsoft Excel for the hypothetical company above (using the same data from the MS Access). Use appropriate formatting and formulas to calculate expenses and revenue. Line Graph: Utilize Excel to create a line graph illustrating the company's sales data over the past 3 years. Include clear labels for the x-axis and y-axis. Data Analysis: Perform data analysis in Excel by calculating the average, minimum, and maximum values of a provided dataset. Present the results clearly and neatly. The Lab Assignment Report will contain all the screenshots for the above. Hardcopy report would need to be submitted at the admin office. ITC101 (May 2023 Semester, Lab Assignment) Students are required to submit the following documents: 1. Access database file (.accdb) - save the file as "BusinessName".accdb 2. Excel spreadsheet file (.xlsx) - save the file as "BusinessName".xlsx 3. Lab Assignment report (.pdf) - save the file as "BusinessName".pdf Assignment Marking Guide