Posted: July 25th, 2024
GO19_AC_CH05_GRADER_5G_AS – Tuition and Fees 1.0
Merone_GO19_AC_CH05_GRADER_5G_AS.zip100 GO19_AC_CH05_GRADER_5G_AS_Instructions x
GO19_AC_CH05_GRADER_5G_AS – Tuition and Fees 1.0
Start Access.Open the file Student_Access_5G_Tuition_Fees_AS.accdb downloaded with this project.
Create a new query in Design view using the Categories and Students tables. From the Categories table, add the Category field. From the Students table, add the Student ID, Age Group and Monthly Tuition fields (in that order).
In the design grid, in the first blank field column, type Annual Tuition: [Monthly Tuition]*12. Run the query.
View the query in Design view. In the design grid in the first blank field column, type Total Cost: [Annual Tuition]+[Competition Fee]. Run the query and adjust all column widths to view data. Save the query as Total Cost. Close the query.
Create a new query in Design view using the Categories and Students tables. From the Categories table, add the Category field. From the Students table, add the Age Group and Monthly Tuition fields (in that order).
Run the query. Display the total row and sum the Monthly Tuition field. Save the query as Tuition by Category and Age Group. Close the query.
Using the Query Wizard, create a new crosstab query based on the Total Cost query. Use the Category field as the row headings and the Age Group field as the column headings. Sum the Total Cost field, and deselect the option to summarize each row. Save the query as Crosstab Query. Close the query.
Create a new query in Design view using the Categories and Students tables. From the Categories table, add the Category field. From the Students table, add the Monthly Tuition field.
In the design grid, click in the Criteria row under Category, and type Gymnastics.
Change the query type to an update query.
In the query, update the Monthly Tuition field by increasing it by 10%. Run the query and save the query as Update Gymnastics Tuition. Close the query.
Save the database. Close the database, and then exit Access. Submit the database as directed.
GO19_AC_CH05_GRADER_5G_AS_Instructions x
Grader – Instructions Access 2019 Project
GO19_AC_CH05_GRADER_5G_AS – Tuition and Fees 1.0
Project Description:
In this project, you will manage a database for the owners of the Movers and Shakers Studio. To complete the project, you will create queries to calculate data, and then summarize and group data to analyze enrollment. Additionally, you will create a query to update the monthly fee for gymnastics students.
Steps to Perform:
Step
Instructions
Points Possible
1
Start Access.Open the file
Student_
Access_5G_Tuition_Fees_AS.accdb downloaded with this project.
0
2
Create a new query in Design view using the Categories and Students tables. From the Categories table, add the Category field. From the Students table, add the Student ID, Age Group and Monthly Tuition fields (in that order).
15
3
In the design grid, in the first blank field column, type
Annual Tuition: [Monthly Tuition]*12. Run the query.
10
4
View the query in Design view. In the design grid in the first blank field column, type
Total Cost: [Annual Tuition]+[Competition Fee]. Run the query and adjust all column widths to view data. Save the query as
Total Cost. Close the query.
13
5
Create a new query in Design view using the Categories and Students tables. From the Categories table, add the Category field. From the Students table, add the Age Group and Monthly Tuition fields (in that order).
9
6
Run the query. Display the total row and sum the Monthly Tuition field. Save the query as
Tuition by Category and Age Group. Close the query.
8
7
Using the Query Wizard, create a new crosstab query based on the Total Cost query. Use the Category field as the row headings and the Age Group field as the column headings. Sum the Total Cost field, and deselect the option to summarize each row. Save the query as
Crosstab Query. Close the query.
21
8
Create a new query in Design view using the Categories and Students tables. From the Categories table, add the Category field. From the Students table, add the Monthly Tuition field.
6
9
In the design grid, click in the Criteria row under Category, and type
Gymnastics.
4
10
Change the query type to an update query.
4
11
In the query, update the Monthly Tuition field by increasing it by 10%. Run the query and save the query as
Update Gymnastics Tuition. Close the query.
10
12
Save the database. Close the database, and then exit Access. Submit the database as directed.
0
Total Points
100
Created On: 07/11/2019 1 GO19_AC_CH05_GRADER_5G_AS – Tuition and Fees 1.0
Merone_Access_5G_Tuition_Fees_AS.accdb
CatCode
Category
mSysRowId
DNC
Dance
SB7JEbQr8EaRuLFSbqDsQ4tqpNFINahAsrKm7cfRDwk=-~5Q9Gqckh618WTsLD9ZhwHw==
CHR
Cheerleading
SB7JEbQr8EaRuLFSbqDsQ4tqpNFINahAsrKm7cfRDwk=-~5Q9Gqckh618WTsLD9ZhwHw==
GYM
Gymnastics
SB7JEbQr8EaRuLFSbqDsQ4tqpNFINahAsrKm7cfRDwk=-~5Q9Gqckh618WTsLD9ZhwHw==
ID
mSysRowId
1
W4hey1Y6pIBDSQ+mWExXH81f9DYu5RvG94RDx36gkqE=-~ikYjxNpsOVAypI6LqP5PHw==
Student ID
Last Name
First Name
Age Group
Category
Monthly Tuition
Competition Fee
Instructor
mSysRowId
MAS101
Rogers
Deanna
Teen
CHR
¤ 160.00
¤ 200.00
Jenny
MAS102
Rogers
Jennifer
Senior
DNC
¤ 245.00
¤ 125.00
Jenny
MAS120
Preston
Mike
Senior
CHR
¤ 160.00
¤ 200.00
Jenny
MAS124
Hale
Penny
Adult
DNC
¤ 200.00
¤ 0.00
Randy
MAS131
Burt
Jenna
Youth
GYM
¤ 125.00
¤ 100.00
Kenzi
MAS137
Eminez
Andrea
Youth
DNC
¤ 245.00
¤ 15.00
Tina
MAS139
Matthews
Antonio
Adult
GYM
¤ 175.00
¤ 0.00
Kenzi
MAS142
King
Vickie
Senior
CHR
¤ 150.00
¤ 200.00
Dana
MAS145
Simon
Ellen
Teen
DNC
¤ 245.00
¤ 125.00
Jordan
MAS150
Cassidy
Crystal
Preschool
GYM
¤ 125.00
¤ 0.00
Randy
MAS156
Robert
Jessie
Teen
DNC
¤ 245.00
¤ 125.00
Jordan
MAS159
Silverbery
Cindy
Preschool
CHR
¤ 160.00
¤ 0.00
Jenny
MAS160
Flynn
Taylor
Youth
CHR
¤ 185.00
¤ 200.00
Dana
MAS162
King
Vickie
Senior
GYM
¤ 100.00
¤ 0.00
Randy
MAS164
Moxley
Sandy
Adult
GYM
¤ 175.00
¤ 0.00
Kenzi
MAS168
Flowers
Suzy
Preschool
CHR
¤ 160.00
¤ 200.00
Randy
MAS171
Lawrence
Allison
Adult
DNC
¤ 200.00
¤ 125.00
Jordan
Grader – Instructions Access
2
0
1
9
Project
GO19_AC_CH0
5
_GRADER_5G_AS – Tuition and Fees 1.0
Project Description:
In this project, you will manage a database for the owners of the Movers and Shakers Studio. To complete the project, you will create queries to calculate data, and then summarize and group data to analyze enrollment. Additionally, you will create a query to update the monthly fee for gymnastics students.
Steps to Perform:
|
Step |
Instructions |
Points Possible |
||
| 1 |
Start Access.Open the file |
0 | ||
| 2 |
Create a new query in Design view using the Categories and Students tables. From the Categories table, add the Category field. From the Students table, add the Student ID, Age Group and Monthly Tuition fields (in that order). |
15 |
||
|
3 |
In the design grid, in the first blank field column, type 12 . Run the query. |
10 |
||
|
4 |
View the query in Design view. In the design grid in the first blank field column, type |
13 |
||
| 5 |
Create a new query in Design view using the Categories and Students tables. From the Categories table, add the Category field. From the Students table, add the Age Group and Monthly Tuition fields (in that order). |
9 | ||
|
6 |
Run the query. Display the total row and sum the Monthly Tuition field. Save the query as |
8 |
||
|
7 |
Using the Query Wizard, create a new crosstab query based on the Total Cost query. Use the Category field as the row headings and the Age Group field as the column headings. Sum the Total Cost field, and deselect the option to summarize each row. Save the query as |
21 |
||
|
Create a new query in Design view using the Categories and Students tables. From the Categories table, add the Category field. From the Students table, add the Monthly Tuition field. |
||||
|
In the design grid, click in the Criteria row under Category, and type |
||||
|
Change the query type to an update query. |
||||
|
11 |
In the query, update the Monthly Tuition field by increasing it by 10%. Run the query and save the query as |
|||
| 12 |
Save the database. Close the database, and then exit Access. Submit the database as directed. |
|
Total Points |
100 |
Created On: 07/11/2019 1 GO19_AC_CH05_GRADER_5G_AS – Tuition and Fees 1.0
Expert paper writers are just a few clicks away
Place an order in 3 easy steps. Takes less than 5 mins.