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. Double click the to open the form, then click the lower WorldCraft Suppliers 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 the WorldCraft Suppliers close form. 4. create our first query by completing the following steps: Now let’s a. Click the tab Create b. Click the button in the Other group, then click to accept Query Wizard OK Simple Query Wizard. c. Verify that is selected in the Tables/Queries text box Table:WorldCraft Products d. Click the button to select all the fields in the Products table Select All Fields e. Click Next f. Click Next to accept a query Detail g. Select the contents of the Title text box, press the delete key to delete the current text. Type as the query name. Asia Jewelry h. Click the option button, then click The query is now in Modify the query design Finish. Design view. See figure below. i. Click the [Region] Criteria cell, type as shown in figure above. Access automatically Asia the criteria. inserts quotations “” around j. Click the [Category] Criteria cell, type as shown in figure above. Jewelry k. Click the button in the Results group to display a datasheet showing the results of the Run 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 then slide over to Print Print Preview
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
Access_Lab.docx