Open the database you created in question. Import the data from Excel that you created for...

Open the database you created in question. Import the data from Excel that you created for question into this database. (Yes, you are re-importing the same data from Excel that you previously exported to Excel. You should have the original copy of the data as well.) Compare the values for the original data to the values of the export/import data. They should be the same. Using the imported data, construct a report similar to that in Figure.

Question

Create an Access database with a table called My_Expenses that has the fields Date, Expense Category, and Amount. Fill the table with 12 rows of hypothetical student expense data. Ensure that you have several expenses for each date and for each expense category. Create a query that shows the total expenses for each date. Create a query that shows the total and average expenses for each category.

Figure Resulting Report

Source: Microsoft Access 2010