You are given a database $-$ MGMT$2006\_202324$S$02\_$Boutique Inc Student File.accdb,

containing Currencies, Sales, and Locations tables to provide some results for MGMT Boutique

INC. $($That is$,$ your CC will provide you with the database$).$ You should:

$1.$ Rename the database as MGMT$2006\_$Boutique$\_$ is your actual name.

$2.$ Create relationships between pairs of tables and enforce referential integrity

$3.$ Append two $(2)$ new customers, two $(2)$ old customers and two $(2)$ new POS transactions. Be

sure to include sales for your two new customers.

$4.$ Create the following queries:

a$.$ List the names of places from which the company sells. Show all columns in the table.

Name this query Q$1-$SELLING$-$LOCATIONS.

b$.$ What is the total sales by location for May $2008,$ sorted in descending order? Name

this query Q$2-$SALES$-$MAY$2008.($Hint: $$Where$$ clause may be useful$)$

c$.$ The company has been informed that the tax has been increased to $17\mathrm{.}5\%.$ Calculate

how much additional tax $($i$.$e$.$ the difference$)$ would have been collected by the store by

year. Name this query Q$3$ ADDED$-$TAX.

$5.$ Create a report showing the following for Jan, Feb, Mar in $2009.$ Duty$-$free sales, duty$-$paid

sales, and taxes $($original$)$ are collected monthly by location. The report should be grouped by

month, sorted by location, and include detail $($one per month$)$ and summary $($the quarter$)$

numbers. For printing purposes, ensure the report prints each month on a new page with portrait

orientation. This report will be distributed at a meeting. Name the report $$MGMT Boutique

INC, Monthly Sales Q$1,2009$ and put the title on each page.

$6.$ You think that perhaps a chart showing sales for the ten $(10)$ top brands would be helpful for

the next round of buying. Create an Excel column chart showing sales for the top $10$ brands.

You would want to create a separate query to facilitate this. Export the query to a new sheet in

a spreadsheet and create a suitable chart. Ensure the chart is labelled appropriately and placed

on a new sheet. Name the Spreadsheet as MGMT$2006\_$Boutique$\_$first name$\_$last name,

where is your actual name.

$7.$ Create a switchboard with the first three queries and the report. Use the note provided to create

MGMT$2006$ Management Information Systems I $5|$ Page

a switchboard named $$MGMT Boutique INC: Menu System$.$ In the bottom right$-$hand

corner, create a label using an $8-$point font that states you created the switchboard. For

example, $$Created by Jane John$.$