d. Click the Print button in the Print group. Click . Place the printed results in Ok your folder and label them DB-6 #3. e. Click the button in the Close Preview group. Close Print Preview f. the query results datasheet. Close g. Be sure to the query if asked. save Lab DB-7 Format and Print an Order Report - Inventory Database for WorldCraft The primary purpose for reports is to control what data appears on a printed page. In this lab, you will learn how to create a report using the Report Wizard. You will also learn how to format and customize a report with options in the Report Layout Tools. Before creating the report you will modify the to query so it includes two fields “Items Order” from the Suppliers table; then format and print an Order report. 1. Open the database if it is not open already. If you see a WorldCraft Inventory “Security when opening, click the button then select click Warning” options… Enable this Content, OK. You may not see this Warning in the Delta computer labs. 2. Modify the to query to include two additional fields from the Suppliers table by “Items Order” completing the following steps: a. Double-click query within the Navigation Pane to open it. Items to Order b. Switch to Design view by clicking the button View c. Click the button in the Query Setup group, Show Table d. Click click Add, click Close WorldCraft Suppliers, e. Scroll to the right to view the next available blank column in the grid f. Double-click in the WorldCraft Suppliers table to add it to the grid. Supplier Name g. Double-click in the WorldCraft Suppliers table to add it to the grid. Email Address h. Click the button to display the query results. Note the newly added fields in the Run results. i. Change back to Design view by clicking the button. View j. Sort the query by SupplierName in ascending order. To do this, click SupplierName Sort cell list arrow, click Ascending
d. Click the Print button in the Print group. Click Ok . Place the printed results in your folder and label them DB-6 #3. e. Click the Close Print Preview button in the Close Preview group. f. Close the query results datasheet. g. Be sure to save the query if asked. Lab DB-7 Format and Print an Order Report - Inventory Database for WorldCraft The primary purpose for reports is to control what data appears on a printed page. In this lab, you will learn how to create a report using the Report Wizard. You will also learn how to format and customize a report with options in the Report Layout Tools. Before creating the report you will modify the “Items to Order” query so it includes two fields from the Suppliers table; then format and print an Order report. 1. Open the WorldCraft Inventory database if it is not open already. If you see a “Security Warning” when opening, click the options… button then select Enable this Content, click OK. You may not see this Warning in the Delta computer labs. 2. Modify the “Items to Order” query to include two additional fields from the Suppliers table by completing the following steps: a. Double-click Items to Order query within the Navigation Pane to open it. b. Switch to Design view by clicking the View button c. Click the Show Table button in the Query Setup group, d. Click WorldCraft Suppliers, click Add, click Close e. Scroll to the right to view the next available blank column in the grid f. Double-click Supplier Name in the WorldCraft Suppliers table to add it to the grid. g. Double-click Email Address in the WorldCraft Suppliers table to add it to the grid. h. Click the Run button to display the query results. Note the newly added fields in the results. i. Change back to Design view by clicking the View button. j. Sort the query by SupplierName in ascending order. To do this, click SupplierName Sort cell list arrow, click Ascending
Access_Lab.docx