Section $4$: Gather Specific Data using Queries and Filter$/$Sort

$$ Here, you will use the same process used in the Intro Assignment to create a Query in MS Access.

$$ You will create a Query that contains the same Fields, and in the same order, as the Order Info Tab in the Superstore Data.

$$ You will then execute four Queries in MS Access and MS Excel and take Screen Clippings of both.

$$ MS Access Instructions

o Use the Order Info Query that you create as a template for the following four modified Queries.

o Copy the Order Info Query in the Navigation Pane four times, and name each copy Order Info Query $$ SC$4/5/6/7($with the

number corresponding to which Screen Clipping they refer to$).$

o You will modify each Query in the Design View, so it fulfills your specific criteria, and only the specific Fields requested.

$$ To hide any of the Fields in the Query, de$-$select the $$Show$$ box.

$$ Rank your Query results Ascending$/$Descending by a certain Field:

$$ Go to the desired Field

$$ Click the Sort cell

$$ Choose Ascending$/$Descending

$$ Show $$Top N$$:

$$ Go to the Query Setup

$$ Adjust the number in the $$Return$$ box to the desired number of records

$$ Show one specific entry type for a certain Field:

$$ Go to the desired Field

$$ Click the Criteria cell

$$ Enter the desired entry in quotes

$$ Show Date Range:

$$ Go to the desired Field

$$ Click the Criteria cell

$$ Enter the desired date range in the following format: $>=$#Lower Range# And #Upper Range#

o Note: Use the equal signs if you want the Lower$/$Upper Range dates to be included in your

Query

MS Excel Instructions

o Use the Order Re$-$creation tab that you create as a template for the following four modified Queries.

o Copy the Order Re$-$creation tab four times, and name each copy Order Re$-$creation $$ SC$4/5/6/7($with the number

corresponding to which Screen Clipping they refer to$).$

o You will show the desired results for each Query by making use of Filter$/$Sort and Hiding the columns that are not the

specific Fields requested.

$$ Note: When you add Filters to your columns make sure you add Filters to all your columns. If you only add them

to some, you will get incorrect results.

$$ Rank your Query results Ascending$/$Descending by a certain Field:

$$ Go to the desired Field and click the Filter$/$Sort arrow

$$ Click the Sort Smallest to Largest or Largest to Smallest

$$ Show $$Top N$$:

$$ Go to the desired Field and click the Filter$/$Sort arrow

$$ Click $$Number Filters$$

$$ Click Top $10,$ and choose the specific number of records desired

$$ Show one specific entry type for a certain Field:

$$ Go to the desired Field and click the Filter$/$Sort arrow

$$ Click the Search box

$$ Enter the desired entry and hit enter

$$ Show Date Range:

$$ Go to the desired Field and click the Filter$/$Sort arrow

$$ Click the $$Select All$$ box to deselect everything

$$ Expand the dates to the depth $($Year $->$ Month $->$ Day$)$ needed to select the Date Range you require

o Note: You will need to ensure all boxes between your start and end Date are checked $($Yes$,$ this can be annoying depending on your range and how your data is structured$)$

I need help and a CLEAR step by step on how to solve these pls