Software Tool to be used: Microsoft Access
KJ’s Disclaimer about MS Access and it’s Relevance in the workplace:Granted, few organizations use MS Access as it is more of an individual solution tool and easy to navigate BUT…..
MS Access showcases data tables, table relationships and more importantly, the ability to create queries of the data selecting whatever fields and attaching criteria (AND-n-OR) to FILTER or SUMMARIZE massive amounts of data easily
Remember a “Query is a Query” no matter what language it is written in including SQL (Structured Query Language)
Additionally, MS Access allows you to create data entry/inquiry forms and reports too which are NOT required for this assignment.
Instructions
ghadah alshakkakee (name to be used in some data fields that require name)
Step 1: View the assignment Description document with step-by-step instructions:ISAN3380-HW1-BigData-Access Queries.pdf (file below)
Step 2: Download the 2 starter files to your local device/folder (Recommend the Downloads Folder so you remember WHERE you put them)Starter Access Database: Foodmart4g.accdb (file below)
YOUR Answer Sheet: ISAN3380-HW1-LnameFname.docx (file below)
Follow the Assignment Instructions creating the queries, Saving Results as PDF’s and Answering the questions in your answer sheet
Once completed, Save/Close ALL files
Submit all of the required files (or as many as you are able to create) to this Assignment by the due date.
Submit the following 6 files to/for this Assignment HERE:
File 1: HW1-LnameFname-Top10Products.pdf
File 2: HW1-LnameFname-Top10Custs.pdf
File 3: HW1-LnameFname-SalesByStore.pdf
File 4: HW1-LnameFname.docx or doc
File 5: HW1-LnameFname.xlsx
File 6: HW1-Foodmart4g.accdb