Access
nacaratof
GO16_AC_CH05_GRADER_5A_HW_Instructions.docxGrader - Instructions Access 2016 Project
GO16_AC_CH05_GRADER_5A_HW - Store Inventory
Project Description:
This project will be completed by following the Activities in the Project A of your GO! textbook. You can use the print or eText version to locate and read the Activity instructions. For the purpose of grading the project, you are required to perform the following tasks:
Steps to Perform:
|
Step |
Instructions |
Points Possible |
|
1 |
Open the file a05A_Start.accdb downloaded with this project. Then, in your textbook, turn to Project 5A and complete all of the steps in Activities 5.01-5.10, except where changes are indicated below. Do not print unless required by your instructor |
0 |
|
2 |
Complete Activity 5.01 Creating a Calculated Field Based on Two Existing Fields. Do not save the database with a new name. Do not rename tables. Save the query as 5A Per Item Profit Query |
10 |
|
3 |
Complete Activity 5.02 Creating a Calculated Field Based on One Existing Field and a Number. Save the query as 5A Surfboarding Sale Query |
12 |
|
4 |
Complete Activity 5.03 Adding a Total Row to a Query. Save the query as 5A Total Inventory Cost Query |
10 |
|
5 |
Complete Activity 5.04 Creating a Totals Query. Save the query as 5A Inventory by Supplier Query |
10 |
|
6 |
Complete Activity 5.05 Creating a Select query as the Source for a Crosstab Query. Save the query as 5A On Hand Per Company and Category Query |
6 |
|
7 |
Complete Activity 5.06 Creating a Crosstab Query. In the final step of the query, under What do you want to name your query? type 5A Crosstab Query |
12 |
|
8 |
Complete Activity 5.07 Finding Duplicate Records. In the final step of the query, accept the suggested query name. |
10 |
|
9 |
Complete Activity 5.08 Finding Unmatched Records. In the final step of the query, under What do you want to name your query? type 5A Find Unmatched Query |
10 |
|
10 |
Complete Activity 5.09 Creating a Parameter Query Using One Criterion Save the query as 5A Category Parameter Query |
10 |
|
11 |
Complete Activity 5.10 Creating a Parameter Query Using Multiple Criteria Save the query as 5A On Hand Parameter Query |
10 |
|
12 |
Save and close the file, and then submit the a05A_Start.accdb database for grading. |
0 |
|
Total Points |
100 |
Created On: 07/05/2019 1 GO16_AC_CH05_GRADER_5A_HW - Store Inventory
