Kelley School of Business – IUB – K201 Graded Project 1 Fall 2022
G RADED P RO JECT 1 T OPI CS (S EE C ANVAS FO R DUE DATE , 15 PTS )
Importing data and tables from files created in other applications
Creating tables and defining fields
Sorting, searching, and modifying the contents of table records
Improving database design
S ET UP A T RUSTED LO CATION T O ENABLE MACROS
Before you begin, read this section to see which applies to you. Save these instructions so that in future
Graded Projects (GPs) you can refer to them in order to open your file.
On-campus computer lab or iuanyware.iu.edu users:
For all students using an IU computer lab or iuanyware.iu.edu, you must follow these instructions to
access your GPs:
1. Find and start Microsoft Access.
2. On the left pane, click Open Other Files.
3. On the left pane, click Options.
4. On the left pane, click Trust Center and then Trust Center Settings.
5. On the left pane, click Macro Settings. Make sure your macro security is set to Enable all macros.
6. Close Access.
Personal PC laptop/computer users:
For all students using their own PC computer/laptop, you must follow these instructions:
Before downloading your Graded Projects (GPs), you must establish a trusted location on your computer. Start by creating
a folder where you would like to store your GP files. Then, add the individual subfolders for GP1, GP2, etc. inside this
folder.
If you are using iuanyware.iu.edu to complete your GPs (MAC users will need to use IUAnyWare), you will need to
follow these instructions each time you log onto IUAnyWare. First, select the STC-Kelley School of Business desktop.
Then, instead of creating a file structure for your GPs, you will create a GP folder on your desktop and select this.
Comfortable with computers? Follow the instructions found in this IU Knowledge Base article:
https://support.microsoft.com/en-us/office/add-remove-or-change-a-trusted-location-7ee1cdc2-483e-4cbb-bcb3-
4e7c67147fb4?ui=en-us&rs=en-us&ad=us
Not sure? That’s okay – at the end of these instructions you will find a step-by-step guide with screenshots to walk you
through the process. Do this now before downloading your GP and continuing with these instructions.
W ARNINGS A ND R EQUI REMENTS
PC requirements
IUAnyWare or Microsoft Office Indiana University 365 (not 365 for Education; our version has more
features in it). If using a Mac, you must use IUanyWare (https://iuanyware.iu.edu). If using a PC, you can
use IUanyWare OR install Office 365 for Indiana University, which is a locally installed version (not a browser-
based version). You can find it at https://office.iu.edu for free. Please see the IU Knowledge Base article for
instructions for installation: https://kb.iu.edu/d/bexq. If using IUanyWare, the Chrome browser is
recommended. Both practical exams will require the use of IUanyWare.
Microsoft Windows PC or Mac, and a high-speed internet connection. If you do not have a personal
computer, you can also use an in-person computer lab on campus (subject to all university guidelines for in-
6/16/2023 7701d05d12ea4f937e8c726f29a46c90.docx 1 of 12
, Kelley School of Business – IUB – K201 Graded Project 1 Fall 2022
person settings). If you are sharing a computer with anyone, you must have your own personal account for the
computer. If you are unsure about your configuration, call 812-855-6789.
Security
NEVER be in possession of another student’s K201 files or allow another student to access your file. This
is Academic Misconduct - Please see the course syllabus.
Disk requirements
Do not open this graded project from an e-mail account, a zip file, or a web page; doing so may result in lost work or a
damaged file. Complete this project on the local drive, opened locally from IU OneDrive or your preferred cloud storage
platform.
Saving your work
Periodically save your file to help prevent accidental loss of your work.
Keeping a backup
When you are finished or want to stop working, close Access. Copy the file to another drive, ensure OneDrive syncs, or
upload to some other cloud account. See https://kb.iu.edu/d/aewd regarding syncing OneDrive.
Checking your progress
Use the GP1_Student_Grader.accdb file for grading. First, close your GP file, and then open the grading file. Click the
Grade Your GP File button and follow the prompts. You may check your progress as often as you wish by repeating this
process.
Submitting your project
When you have completed your project and checked all your work, upload your file to your K201 lab section’s Canvas site.
Submission directions are near the end of this document. Make sure your file is closed before attempting to submit the
project. No extensions are given for hardware, software, connectivity, or timeout issues.
C ASE B AC KGROUND
Happy Pfrog Incorporated (HP) is the brainchild of Frances Marshall and Preston Eagleson, two
alumni from Indiana University. The company was incorporated five years ago as an outfitter
specializing in escorting adults and children on white water rivers throughout the United States.
More recently they have expanded their company to sell a variety of products via mail order catalogs.
They offer such products as outdoor clothing, fishing gear, elephant boots, talking birdhouses, and
multi-colored crocodiles. Sales have exploded to $5 billion per year. Here is some expedition
information from their Web site.
6/16/2023 7701d05d12ea4f937e8c726f29a46c90.docx 2 of 12
G RADED P RO JECT 1 T OPI CS (S EE C ANVAS FO R DUE DATE , 15 PTS )
Importing data and tables from files created in other applications
Creating tables and defining fields
Sorting, searching, and modifying the contents of table records
Improving database design
S ET UP A T RUSTED LO CATION T O ENABLE MACROS
Before you begin, read this section to see which applies to you. Save these instructions so that in future
Graded Projects (GPs) you can refer to them in order to open your file.
On-campus computer lab or iuanyware.iu.edu users:
For all students using an IU computer lab or iuanyware.iu.edu, you must follow these instructions to
access your GPs:
1. Find and start Microsoft Access.
2. On the left pane, click Open Other Files.
3. On the left pane, click Options.
4. On the left pane, click Trust Center and then Trust Center Settings.
5. On the left pane, click Macro Settings. Make sure your macro security is set to Enable all macros.
6. Close Access.
Personal PC laptop/computer users:
For all students using their own PC computer/laptop, you must follow these instructions:
Before downloading your Graded Projects (GPs), you must establish a trusted location on your computer. Start by creating
a folder where you would like to store your GP files. Then, add the individual subfolders for GP1, GP2, etc. inside this
folder.
If you are using iuanyware.iu.edu to complete your GPs (MAC users will need to use IUAnyWare), you will need to
follow these instructions each time you log onto IUAnyWare. First, select the STC-Kelley School of Business desktop.
Then, instead of creating a file structure for your GPs, you will create a GP folder on your desktop and select this.
Comfortable with computers? Follow the instructions found in this IU Knowledge Base article:
https://support.microsoft.com/en-us/office/add-remove-or-change-a-trusted-location-7ee1cdc2-483e-4cbb-bcb3-
4e7c67147fb4?ui=en-us&rs=en-us&ad=us
Not sure? That’s okay – at the end of these instructions you will find a step-by-step guide with screenshots to walk you
through the process. Do this now before downloading your GP and continuing with these instructions.
W ARNINGS A ND R EQUI REMENTS
PC requirements
IUAnyWare or Microsoft Office Indiana University 365 (not 365 for Education; our version has more
features in it). If using a Mac, you must use IUanyWare (https://iuanyware.iu.edu). If using a PC, you can
use IUanyWare OR install Office 365 for Indiana University, which is a locally installed version (not a browser-
based version). You can find it at https://office.iu.edu for free. Please see the IU Knowledge Base article for
instructions for installation: https://kb.iu.edu/d/bexq. If using IUanyWare, the Chrome browser is
recommended. Both practical exams will require the use of IUanyWare.
Microsoft Windows PC or Mac, and a high-speed internet connection. If you do not have a personal
computer, you can also use an in-person computer lab on campus (subject to all university guidelines for in-
6/16/2023 7701d05d12ea4f937e8c726f29a46c90.docx 1 of 12
, Kelley School of Business – IUB – K201 Graded Project 1 Fall 2022
person settings). If you are sharing a computer with anyone, you must have your own personal account for the
computer. If you are unsure about your configuration, call 812-855-6789.
Security
NEVER be in possession of another student’s K201 files or allow another student to access your file. This
is Academic Misconduct - Please see the course syllabus.
Disk requirements
Do not open this graded project from an e-mail account, a zip file, or a web page; doing so may result in lost work or a
damaged file. Complete this project on the local drive, opened locally from IU OneDrive or your preferred cloud storage
platform.
Saving your work
Periodically save your file to help prevent accidental loss of your work.
Keeping a backup
When you are finished or want to stop working, close Access. Copy the file to another drive, ensure OneDrive syncs, or
upload to some other cloud account. See https://kb.iu.edu/d/aewd regarding syncing OneDrive.
Checking your progress
Use the GP1_Student_Grader.accdb file for grading. First, close your GP file, and then open the grading file. Click the
Grade Your GP File button and follow the prompts. You may check your progress as often as you wish by repeating this
process.
Submitting your project
When you have completed your project and checked all your work, upload your file to your K201 lab section’s Canvas site.
Submission directions are near the end of this document. Make sure your file is closed before attempting to submit the
project. No extensions are given for hardware, software, connectivity, or timeout issues.
C ASE B AC KGROUND
Happy Pfrog Incorporated (HP) is the brainchild of Frances Marshall and Preston Eagleson, two
alumni from Indiana University. The company was incorporated five years ago as an outfitter
specializing in escorting adults and children on white water rivers throughout the United States.
More recently they have expanded their company to sell a variety of products via mail order catalogs.
They offer such products as outdoor clothing, fishing gear, elephant boots, talking birdhouses, and
multi-colored crocodiles. Sales have exploded to $5 billion per year. Here is some expedition
information from their Web site.
6/16/2023 7701d05d12ea4f937e8c726f29a46c90.docx 2 of 12
