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.