Question $9$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

For this question, you need to download a file, and save it to your Desktop. $$

Desktop

When prompted with this $$ press the Save as button. Do not Open the file in your browser $($You will lose time$).$ Remember to Save the file to your Desktop. When finished with this question, you must delete the file.

To start downloading, press this link or this icon X$$ then download this file also or press this icon $$

Do the following to answer the question quickly:

Import the data from the Excel file provided into the database provided. Note the database file is empty, you must import the worksheet into a table in the Access database.

Create a query with all fields from the table. Create a calculated field where necessary. Set it with criterias and$/$or Sorting keys to answer the following question:

What is the price including GST $(5\%)$ of the second most expensive book written in the French $($F$)$ language published on or before $1980$ and currently out of stock in this database?

Select one:

$$121\mathrm{.}00$

$$130\mathrm{.}20$

$$124\mathrm{.}00$

$$69\mathrm{.}69$

$$188\mathrm{.}00$