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