Competency Assessments Project 6-1: Soccer Team Report You need a copy of the soccer team’s roster that you can print and take with you to work. Create a simple report and apply a theme. GET READY. LAUNCH Access if it is not already running. 1. OPEN the SoccerTeam database. 2. Save the database as SoccerTeamXXX (where XXX is your initials). 3. Click the Roster table to select it. 4. On the Create tab, in the Reports group, click the Report button. A new report is created. 5. Resize each field so that all fields fi t on one page. 6. On the Report Layout Tools Design contextual tab, in the Themes group, click the Themes button. 7. Select the purple format in the seventh row, column named Opulent. 8. Click the Save button on the Quick Access Toolbar. The Save As dialog box appears with the name Roster in it. Click OK to accept that name for the report. 9. the report. 10. CLOSE the database. LEAVE Access open for the next project. Project 6-2: Fourth Coffee Inventory Report In your job at Fourth Coffee, you are responsible for maintaining the coffee inventory. Create a report to view the inventory and prepare for the next order. GET READY. LAUNCH Access if it is not already running. 1. OPEN Coffee from the data fi les for this lesson. 2. SAVE the database as CoffeeXXX (where XXX is your initials). 3. Click the Coffee Inventory Table in the Navigation Pane to select it. 4. On the Create tab, in the Reports group, click the Report Wizard button. The first Report Wizard screen appears. 5. Click the double arrow >> to move all the fields to the Selected Fields list and click Next. 6. On the grouping screen, click the Scheduled Order Date field, click the >, and click Next. 7. On the sorting screen, click the active down arrow on the menu, select Pounds, and click Next. 8. Keep the defaults as is on the layout screen and click Next.
Competency Assessments Project 6-1: Soccer Team Report You need a copy of the soccer team’s roster that you can print and take with you to work. Create a simple report and apply a theme. GET READY. LAUNCH Access if it is not already running. 1. OPEN the SoccerTeam database. 2. Save the database as SoccerTeamXXX (where XXX is your initials). 3. Click the Roster table to select it. 4. On the Create tab, in the Reports group, click the Report button. A new report is created. 5. Resize each field so that all fields fi t on one page. 6. On the Report Layout Tools Design contextual tab, in the Themes group, click the Themes button. 7. Select the purple format in the seventh row, column named Opulent. 8. Click the Save button on the Quick Access Toolbar. The Save As dialog box appears with the name Roster in it. Click OK to accept that name for the report. 9. the report. 10. CLOSE the database. LEAVE Access open for the next project. Project 6-2: Fourth Coffee Inventory Report In your job at Fourth Coffee, you are responsible for maintaining the coffee inventory. Create a report to view the inventory and prepare for the next order. GET READY. LAUNCH Access if it is not already running. 1. OPEN Coffee from the data fi les for this lesson. 2. SAVE the database as CoffeeXXX (where XXX is your initials). 3. Click the Coffee Inventory Table in the Navigation Pane to select it. 4. On the Create tab, in the Reports group, click the Report Wizard button. The first Report Wizard screen appears. 5. Click the double arrow >> to move all the fields to the Selected Fields list and click Next. 6. On the grouping screen, click the Scheduled Order Date field, click the >, and click Next. 7. On the sorting screen, click the active down arrow on the menu, select Pounds, and click Next. 8. Keep the defaults as is on the layout screen and click Next.
MOAC%20Access%206%20Student%20Assessment%20Projects.docx