Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer

Exercise 1

Using the Student-Class-Grade database that you created in this Appendix:
A. Create and run an Access QBE query to duplicate the results in Figure 1-10. Save the query as QBE-Query-A-02.
B. Use the Form Wizard to create a data input form for the STUDENT table. Name the form Student Data Input Form. Using the student data shown in Figure A-49, add the new students to the STUDENT table.
C. Use the Form Wizard to create a data input form for the CLASS table. Name the form Class Data Input Form. Using the class data shown in Figure A-50, add the new classes to the CLASS table.
D. Use the Form Wizard to create a data input form for the GRADE table. Name the form Grade Data Input Form. Using the grade data shown in Figure A-48, add the new grades to the GRADE table.
E. Use the Form Wizard to duplicate the CLASS form in Figure 1-9. Note that this form uses more than one table.
F. Use the Report Wizard to create a report of the data in the STUDENT table. Name the report Student Data Report.
G. Use the Report Wizard and the CLASS, STUDENT and GRADE tables to duplicate the Class Grade Report shown in Figure 1-11. Note that your version of this report will display additional data because of the data you added to the database in steps B, C and D above.