Go19_ac_ch05_grader_5g_as – tuition and fees 1.0

Sep 14, 2023

GO19_AC_CH05_GRADER_5G_AS – Tuition and Fees 1.0

     

Don't use plagiarized sources. Get Your Custom Essay on
Go19_ac_ch05_grader_5g_as – tuition and fees 1.0
Just from $13/Page
Order Essay

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.

Recent Posts