You are the programs director at a local fitness center. You recently purchased Access to track information about your students, classes, and instructors. You need to create a report that shows a listing of all your students for the upcoming classes, grouped by class. The report also needs to show the amounts due for each student. You will create this report from existing tables in the database.
a. Start Access, then open the database L-4.accdb from where you store your Data Files. Save the database as L-Fitness Center.
b. Use the Report Wizard to create a report based on the Classes and Students tables. Include the Class Name, Instructor Last Name, and Per Class Fee fields from the Classes table, and the Last and First fields from the Students table. Specify to view the data by the Classes table, then group the fields by Class Name . •