Section $2$: Re$-$create your Superstore Order.

$$ Here, you will use the same process used in the Intro Assignment to re$-$create your Order.

$$ The OrderLine ID data is already added to the Order Re$-$creation tab.

$$ Start by using the OrderLine ID data to retrieve the data from the tables directly connected to it in the data model $($Figure $4).$

$$ Use the fields labeled with a $$FK$$ to connect to the corresponding fields labeled with a $$PK$$ to retrieve the desired data.

o Note: Remember to use a mixed reference for your lookup$\_$value, and an absolute reference for your table$\_$array. This will

ensure you can paste your formula and only must make minor adjustments.

$$ After you retrieve the data from the tables connected to the OrderLine ID table, use the added FKs to populate the remaining tables.

$8)$ What Fields are in Columns AB and AC$?$ What are the values in AB$317$ and AC$317$ once you have retrieved

the Product Data?

$$ Reminders:

Finn $201922$

Based on Superstore data from Tableau

o You will need to populate the Fields corresponding to the Product tab $($Columns AA through AD$).$

o You will need to use the Product ID $($FK$)$ as your lookup$\_$value and the data contained in the Product tab as your

Lookup$\_$array.

What Fields are in Columns K and N$?$ What are the values in K$951$ and N$951$ once you have retrieved the

Order Data?

$$ Reminders:

o You will need to populate the Fields corresponding to the Order tab $($Columns H through P$).$

o You will need to use the Order ID $($FK$)$ as your lookup$\_$value and the data contained in the Order tab as your lookup$\_$array.

$$ Remember to change the number format on both date columns once you have autofilled them.

What Fields are in Columns E and F$?$ What are the values in E$317$ and F$317$ once you have retrieved the

Employee Data?

$$ Reminders:

o You will need to populate the Fields corresponding to the Employee tab $($Columns E through F$).$

o You will need to use the Employee ID $($FK$)$ as your lookup$\_$value and the data contained in the Employee tab as your

Lookup$\_$array

What Fields are in Columns B and C$?$ What are the values in B$951$ and C$951$ once you have retrieved the

Customer Data?

$$ Reminders:

o You will need to populate the Fields corresponding to the Customer tab $($Columns B through C$).$

o You will need to use the Customer ID $($FK$)$ as your lookup$\_$value and the data contained in the Customer tab as your

lookup$\_$array

$$ Re$-$orientation of Order Re$-$creation tab

o Compare your results in the Order Re$-$creation tab to the Order Info tab. You should notice you have a few additional

columns $(26$ vs $22),$ and your columns are organized in a different order.

o First, highlight Columns A through H and Insert Column. This will give you the space to move things around easily.

o Reorganize your columns by the same general organization found in the Order Info tab.

o Right click and Hide each of the extra columns $($All of the FKs other than Order ID $($FK$)).$

$$ it is important to Hide them, and not delete them since many of your VLOOKUPs are using the results of these

columns. If you were to delete them, many of your formulas would error.

o Take a Screen Clipping showing the complete top row, and at least $10$ rows of data and paste it below $$Superstore

$$ Here, you will use the same process used in the Intro Assignment to import your Superstore Data into MS Access.

$$ Import each of the colored tabs $($Customer$,$ Employee, Order, OrderLine ID$,$ and Product$)$ into MS Access.

$$ Give each Table the same name as the Tab that was imported.

$$ Establish the Table Relationships using the Superstore Data Model $($Figure $4)$ and PK$/$FKs as a guide.

How many Fields$/$Rows are found in the Customer Table? What is the full Record for Record $256?$

How many Fields$/$Rows are found in the Employee Table? What is the full Record for Record $2?$

How many Fields$/$Rows are found in the Order Table? What is the full Record for Record $512?$

How many Fields$/$Rows are found in the OrderLine ID Table? What is the full Record for Record $4096?$

How many Fields$/$Rows are found in the Product Table? What is the full Record for Record $128?$