GO19_AC_CH02_GRADER_2B_HW - Athletic Scholarships 1.0
expmen
GO19_AC_CH02_GRADER_2B_HW_Instructions.docxGrader - Instructions Access 2019 Project
GO19_AC_CH02_GRADER_2B_HW - Athletic Scholarships 1.0
Project Description:
This project will be completed by following the Activities in the Project 2B 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 |
Start Access. Open the file Student_ Access_2B_Athletes_Scholarships.accdb downloaded with this project. Then, in your textbook, turn to Project 2B and complete all of the steps in Activities 2.17-2.32. |
0 |
|
2 |
Complete Activity 2.17 Opening an Existing Database and Importing a Spreadsheet as a New Table. |
5 |
|
3 |
Complete Activity 2.18 Creating a One-to-Many Table Relationship. |
5 |
|
4 |
Complete Activity 2.19 Specifying Numeric Criteria in a Query. |
4 |
|
5 |
Complete Activity 2.20 Using Comparison Operators in Criteria. |
4 |
|
6 |
Complete Activity 2.21 Using the Between . . . And Comparison Operator. |
8 |
|
7 |
Complete Activity 2.22 Using AND Criteria in a Query. |
10 |
|
8 |
Complete Activity 2.23 Using OR Criteria in a Query. |
10 |
|
9 |
Complete Activity 2.24 Creating a Query Based on More Than One Table. |
8 |
|
10 |
Complete Activity 2.25 Using a Wildcard in a Query. Save the query as 2B Wildcard Query. |
8 |
|
11 |
Complete Activity 2.26 Creating a Calculated Field in a Query. |
7 |
|
12 |
Complete Activity 2.27 Creating a Second Calculated Field in a Query. |
3 |
|
13 |
Complete Activity 2.28 Formatting Calculated Fields. |
5 |
|
14 |
Complete Activity 2.29 Using the Min, Max, Avg, and Sum Functions in a Query. |
3 |
|
15 |
Complete Activity 2.30 Grouping Records in a Query. |
7 |
|
16 |
Complete Activity 2.31 Creating a Crosstab Query Using the Query Wizard. |
5 |
|
17 |
Complete Activity 2.32 Creating a Parameter Query With One Criteria. |
8 |
|
18 |
Save and close the database, and then submit for grading. |
0 |
|
Total Points |
100 |
Created On: 05/06/2020 1 GO19_AC_CH02_GRADER_2B_HW - Athletic Scholarships 1.0
