Kelley School of Business – IUB – K201 Graded Project 1 Spring 2023
G RADED P ROJECT 1 T OPICS
(S EE CA NVAS FOR 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 L OCATION TO ENABL E 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 Options.
3. On the left pane, click Trust Center and then Trust Center Settings.
4. On the left pane, click Macro Settings. Make sure your macro security is set to Enable all macros.
5. 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.
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 AND R EQUIREMEN TS
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.
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-
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.
10/6/2023 7566ed65d2c5b74e1e74c3ca9e9bd1ea.docx 1 of 10
, Kelley School of Business – IUB – K201 Graded Project 1 Spring 2023
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 cloud platform such as IU OneDrive; doing so may
result in lost work or a damaged file. Instead, download to your desktop or downloads folder, open it from there, and
proceed with your work.
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 A CKGROUN D
Happy Pfrog Incorporated (HP) is the brainchild of Frances Marshall and Preston Eagleson, two
alumni from Indiana University. The company was incorporated several 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.
HP is looking for ways to streamline its business operations. Frances and Preston have started keeping business-related
information in an Access database. They have provided you with the basic database structure including a few tables that
have already been created. Your job is to start implementation using Access.
A. OPENING THE FILE
1. Before opening your file, rename your K201_GP1_SP23.accdb file to username-K201_GP1_SP23.accdb,
where the prefix is your username. (Example: jsmith-K201_GP1_SP23.accdb).
2. If you try to open your file and a message displays (You must enable macros for this program to run), click
the OK button, and the file will automatically close. Follow the instructions contained in this document to enable
macros or set up a trusted location.
3. Open your username-K201_GP1_SP23.accdb file. The first time you open your file, you will be prompted to
enter your username, after which the Documentation form will display. You must enter accurate
information. The Documentation form will automatically provide the current date. Close the Documentation
form when you are finished entering your information.
10/6/2023 7566ed65d2c5b74e1e74c3ca9e9bd1ea.docx 2 of 10
G RADED P ROJECT 1 T OPICS
(S EE CA NVAS FOR 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 L OCATION TO ENABL E 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 Options.
3. On the left pane, click Trust Center and then Trust Center Settings.
4. On the left pane, click Macro Settings. Make sure your macro security is set to Enable all macros.
5. 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.
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 AND R EQUIREMEN TS
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.
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-
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.
10/6/2023 7566ed65d2c5b74e1e74c3ca9e9bd1ea.docx 1 of 10
, Kelley School of Business – IUB – K201 Graded Project 1 Spring 2023
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 cloud platform such as IU OneDrive; doing so may
result in lost work or a damaged file. Instead, download to your desktop or downloads folder, open it from there, and
proceed with your work.
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 A CKGROUN D
Happy Pfrog Incorporated (HP) is the brainchild of Frances Marshall and Preston Eagleson, two
alumni from Indiana University. The company was incorporated several 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.
HP is looking for ways to streamline its business operations. Frances and Preston have started keeping business-related
information in an Access database. They have provided you with the basic database structure including a few tables that
have already been created. Your job is to start implementation using Access.
A. OPENING THE FILE
1. Before opening your file, rename your K201_GP1_SP23.accdb file to username-K201_GP1_SP23.accdb,
where the prefix is your username. (Example: jsmith-K201_GP1_SP23.accdb).
2. If you try to open your file and a message displays (You must enable macros for this program to run), click
the OK button, and the file will automatically close. Follow the instructions contained in this document to enable
macros or set up a trusted location.
3. Open your username-K201_GP1_SP23.accdb file. The first time you open your file, you will be prompted to
enter your username, after which the Documentation form will display. You must enter accurate
information. The Documentation form will automatically provide the current date. Close the Documentation
form when you are finished entering your information.
10/6/2023 7566ed65d2c5b74e1e74c3ca9e9bd1ea.docx 2 of 10
