f. Double-click the Format Painter button in the Font group, then click each of the labels to apply bold. 6. Enter records into the newly created Form by completing the following steps: a. Click the View button in the Views group, press [Tab] key b. Type Carved Polar Bear, press [Tab] c. Type N to show North American, press [Tab] d. Type A to show Art, press [Tab] e. Type A to show America Arts, press [Tab] f. Type 15, press [Tab] g. Type 250, press [Enter] h. Click the Previous record button toward the bottom near the status bar to move back to record 1. Compare your Form showing record 1 with the graphic below. Notice how you minimize typing time when you create lookup fields for as many fields as possible. 7. Enter more records in to the Form: a. Click the Next record button to start a new record, press [Tab] b. Type Coral Pendant, press [Tab] c. Type As to select Asia, press [Tab] d. Type J for Jewelry, then press [Tab]. The supplier you want is not listed. Often when you create a database, you need to go back and add data to related tables. So let’s close this Form and add a needed record to one of your tables. e. Close the database by clicking the close button (X) to the far right of the WorldCraft Products Form tab. f. If prompted to save, use the default name and click OK. g. Double click WorldCraft Suppliers in the Navigation bar to show the WorldCraft Suppliers form. h. Click the New button in the records group, press [Tab] i. Type Far East Imports for the Suppliers Name and as the Email Address. j. Close (X) the Form. 8. Enter the rest of the records in the WorldCraft Products form by completing the following steps:
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. Double click the WorldCraft Suppliers to open the form, then click the lower Next record button several times to view all the records associated with each of the four suppliers. See figure. As a result of the one-to-many relationship you created between the Suppliers table and the Products table, you can create queries that list all the products purchased from a specific supplier. 3. After viewing all four suppliers and there associated products close the WorldCraft Suppliers form. 4. Now let’s create our first query by completing the following steps: a. Click the Create tab b. Click the Query Wizard button in the Other group, then click OK to accept Simple Query Wizard. c. Verify that Table:WorldCraft Products is selected in the Tables/Queries text box d. Click the Select All Fields button to select all the fields in the Products table e. Click Next f. Click Next to accept a Detail query g. Select the contents of the Title text box, press the delete key to delete the current text. Type Asia Jewelry as the query name. h. Click the Modify the query design option button, then click Finish. The query is now in Design view. See figure below. i. Click the [Region] Criteria cell, type Asia as shown in figure above. Access automatically inserts quotations “” around the criteria. j. Click the [Category] Criteria cell, type Jewelry as shown in figure above. k. Click the Run button in the Results group to display a datasheet showing the results of the query. See figure below. Note: The results show all Jewelry products in Asia. 5. Print the query results by completing the following steps: a. Click the Office button b. Select Print then slide over to Print Preview
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
b. Click the Zoom list arrow within the Zoom group. Select 75% c. Click the Print button in the Print group, click OK. Place your one page printout in your folder and label it DB-7 #1. d. Save the report by clicking the disk icon in the Quick Access Toolbar. e. Close the report by clicking the close button (X) to the far right of the WorldCraft Products tab. f. Close Access by clicking the Office button then click Exit Access. Lab DB-8 Assessment The 1 Minute Paper Use the WordPad or Word application to write a simple and quick recap of your thoughts concerning the DB set of labs. Place your name and “Database lab Feedback at the top” – use 12-point. Please answer the following questions: Did you understand the directions? Did you complete the labs in a reasonable length of time? Are you interested in learning more about Access? How can we improve this set of labs? Print your document and label it DB-8. Place it in your folder.